man dbbalancer.conf (Formats) - configuration file for the dbbalancer daemon.

NAME

/etc/dbbalancer/dbbalancer.conf - configuration file for the dbbalancer daemon.

DESCRIPTION

This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page. Instead, it has documentation in HTML format located in the /usr/share/doc/dbbalancer/manual.

The Debian startup scripts for DBBalancer look in the /etc/dbbalancer/conf.d directory for configuration files and start a DBBalancer Daemon for each file found. If a filename ends with `-w' then the init script will start a writer process, otherwise a reader process will be started.

PLEASE NOTE

This configuration file may contain sensitive information, such as usernames and passwords to connect to databases, possibly on other systems.

If that is the case for your configuration you should ensure that these files are mode 600, and are owned by root. Since that probably is the case, that is the default configuration at installation.

DIRECTIVES

Directives fall into two categories:

•
`Daemon' directives control the operation of the connections made to dbbalancer by the application.
•
`Machine' directives control the operation of the connections made by dbbalancer to the backend database.

In the Debian GNU/Linux installation of DBBalancer the init script will start a dbbalancerd daemon process for each configuration file found in /etc/dbbalancer/conf.d

These two groups of options are described briefly below. For a complete description, see the HTML documentation.

Daemon Section

daemon.reader-port=port
Specify the port on which to listen for incoming client database connections for reading activities.
daemon.writer-port=port
Specify the port on which to listen for incoming client database connections for write activities.
When running in connection pool mode this will be the same as the read port.
daemon.init-threads=num
Specify the number of client connections to set at startup.
daemon.min-threads=num
Do not ever have fewer than this many client connections available.
daemon.max-threads=num
Do not ever have more than this many client connections available.
daemon.init-db-connections=num
Specify the number of connections to the backend database to initialise at startup.
daemon.min-db-connections=num
Do not ever have fewer than this many connections available with the backend database.
daemon.max-db-connections=num
Do not ever have more than this many connections available with the backend database.
daemon.reaper-delay=num
The number of seconds between invocations of the periodic thread that enforces the max / min settings.
daemon.dbname=database
The database name which clients must supply to connect to the daemon.
daemon.user=username
The username which clients must supply to connect to the daemon.
daemon.password=password
The password the client must use to connect to the daemon.
daemon.auth-method=(trust|password)
The authentication method used by connectors.

Machine Section

machine.host=hostname
The name (or IP address) of the host on which the database server is running.
machine.dbname=database
The name of the database to connect to.
machine.port=port
The port on which the backend database is listening for connections.
machine.dbuser=username
The database user to connect as.
machine.dbpassword=password
The password to use for connections to the backend database.

SEE ALSO

dbbalancer (1).

The programs are documented fully by the HTML manual available in /usr/share/doc/dbbalancer/manual

AUTHOR

This manual page was written by Andrew McMillan <debian@mcmillan.net.nz> for the Debian GNU/Linux system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts.