Databases
Database servers configuration (db-servers
)
db-servers-hosts
(2.0), hosts
(1.1)
Item |
Value |
Description |
List of database hosts to monitor, IP and port (optional), specified in the host:[port] format and separated by a comma |
Type |
list |
Example |
"127.0.0.1:5055,127.0.0.1:5056" |
db-servers-credential
(2.0), user
(1.1)
Item |
Value |
Description |
Database login with root privileges, specified in the [user]:[password] format |
Type |
string |
Example |
"root:password" |
Database login credentials will use IP (not socket). If you are using local configuration with MySQL or MariaDB, please set up credentials and privileges for 127.0.0.1
instead of localhost
.
If the host is not specified or is localhost, a connection to the local host occurs:
On Windows, the client connects using shared memory, if the server was started with the [shared_memory](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_shared_memory) system variable enabled to support shared-memory connections.
On Unix, MySQL programs treat the host name localhost specially, in a way that is likely different from what you expect compared to other network-based programs: the client connects using a Unix socket file. The [--socket](https://dev.mysql.com/doc/refman/8.0/en/connection-options.html#option_general_socket) option or the MYSQL_UNIX_PORT environment variable may be used to specify the socket name.
db-servers-prefered-master
(2.0), prefmaster
(1.1)
Item |
Value |
Description |
Database preferred candidates for master election, in host:[port] format |
Type |
list |
Example |
"127.0.0.1:5055,127.0.0.1:5056" |
If db-servers-prefered-master
specified, it will failover to candidates mentioned list first. db-servers-prefered-master
does not prevent candidates outside the list to be master. If no suitable candidates found within the list, then it will try to failover outside the list.
If you want to exclude the database, you need to put the host address within db-servers-ignored-hosts
.
db-servers-ignored-hosts
(2.0), ignore-servers
(1.1)
Item |
Value |
Description |
Database list of hosts to ignore for master election |
Type |
list |
Example |
"127.0.0.1:5057,127.0.0.1:5058" |
db-servers-connect-timeout
(2.0), connect-timeout
(1.1)
Item |
Value |
Description |
Database connection timeout in seconds. The server will timeout if the connection cannot be established before that value. |
Type |
integer |
Default Value |
5 |
db-servers-read-timeout
(2.0), read-timeout
(1.1)
Item |
Value |
Description |
Database I/O read timeout in seconds. The server will timeout if, on an already established connection, no data is received during a period equal to this option's value. |
Type |
integer |
Default Value |
15 |
db-servers-tls-ca-cert
(2.0)
Item |
Value |
Description |
Path to the database connection TLS authority certificate. |
Type |
string |
Default Value |
"" |
db-servers-tls-client-cert
(2.0)
Item |
Value |
Description |
Path to the database connection TLS client certificate. |
Type |
string |
Default Value |
"" |
db-servers-tls-client-key
(2.0)
Item |
Value |
Description |
Database TLS client key. |
Type |
string |
Default Value |
"" |
db-servers-binary-path
(2.0), mariadb-binary-path
(1.1)
Item |
Value |
Description |
Path to mysqld binary for replication-manager-tst package to provisioning local clusters. |
Type |
string |
Default Value |
"/usr/local/mysql/bin" |