grot.cfg

NAME
DESCRIPTION
THE GROT SECTION
THE SLAVE SECTION
SEE ALSO
COPYRIGHT

NAME

grot.cfg - grot configuration file

DESCRIPTION

The grot configuration file contains information about master and slave MySQL servers. Its format is the same as of my.cfg file, i.e. it consists of sections, which contain variable assignments. A section begins with a section header enclosed in square brackets. A variable assignement occupies a separate line and consists of variable name and value separated by equals sign with arbitrary amount of white space around it.

Grot uses the sections named grot, slave and, additionally any sections whose names coincide with existing slave host names.

THE GROT SECTION

This section defines the master server parameters. Allowed variables are:

host

Defines the host name or IP address of the master SQL server.

port

Specifies the port the server listens to. Use this variable if the port differs from the default 3306.

socket

Specifies the UNIX socket name, if the server listens on a UNIX socket.

user

Sets the MySQL user name. This user must be granted the PROCESS, SUPER and RELOAD global privileges. The latter is optional, if grot is run with the --no-flush option.

password

Password for that user.

THE SLAVE SECTION

The slave section configures the settings needed to connect to the host servers, such as user credentials, port number etc. If all slaves use the same set of these settings, this section is enough for grot to work. Otherwise, you need to specify the credentials for each particular slave in a separate section, named after that slave’s host name.

port

Specifies the port the server listens to. Use this variable if the port differs from the default 3306.

socket

Specifies the UNIX socket name, if the server listens on a UNIX socket.

user

Sets the MySQL user name. This user must be granted the REPLICATION CLIENT global privilege.

password

Password for that user.

SEE ALSO

grot(1).

COPYRIGHT

Copyright © 2009 Sergey Poznyakoff License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.


Manpage server at man.gnu.org.ua.

Powered by mansrv 1.1