Skip to content

README.md

Latest commit

 

History

History
45 lines (31 loc) · 1.08 KB

README.md

File metadata and controls

45 lines (31 loc) · 1.08 KB

HAProxy Firebird Wrapper

Lua library for handle with Firebird database connections.

Goals

  • Encapsulate the logic of knowing which server to connect to

Dependencies

  • HAProxy must be compiled with Lua support.
  • The lua pgmoon library must be installed.

Instalation

Copy the firebird_wrapper.lua file to the server where you run HAProxy.

Example

For example, haproxy.cfg and docker-compose.yml are used to run HAProxy and databases in containers.

  1. Start docker test environment:

    docker-compose up -d

  2. Run the following code on the postgreSQL database:

    CREATE TABLE databases (
    id integer NOT NULL,
    name character varying(125),
    host character varying(125)
);

INSERT INTO databases VALUES
(1, '/firebird/data/db1.fdb', 'firebird1'),
(2, '/firebird/data/db2.fdb', 'firebird2');

  3. Connect to a firebird database through HAProxy:

    isql-fb 127.0.0.1/3050:/firebird/data/db1.fdb -u docker -p docker

The module will determine which host the database is on.