Documentation Home
MySQL Utilities 1.5 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 1.5Mb
PDF (A4) - 1.5Mb
HTML Download (TGZ) - 289.5Kb
HTML Download (Zip) - 301.7Kb


8.2.3.2 Configuration File

The location of the MySQL Fabric configuration file varies depending on the operating system it is installed on and how you installed it. The table below lists the default configuration file locations for pre-built packages from http://dev.mysql.com/downloads/utilities/. Alternatively, the optional --config option accepts to use a path to a Fabric configuration file, and if defined, the file is loaded and used instead of the default configuration file location.

Table 8.1 Default MySQL Fabric configuration file location

Platform Package Location
Microsoft Windows mysql-utilities-1.5.6-win32.msi UTILITIES_INSTALLDIR/etc/mysql/fabric.cfg
Ubuntu Linux 14.04 mysql-utilities_1.5.6-1ubuntu14.04_all.deb /etc/mysql/fabric.cfg
Debian Linux 6.0 mysql-utilities_1.5.6-1debian6.0_all.deb /etc/mysql/fabric.cfg
Red Hat Enterprise Linux 6 / Oracle Linux 6 mysql-utilities-1.5.6-1.el6.noarch.rpm /etc/mysql/fabric.cfg
OS X mysql-utilities-1.5.6-osx10.9.dmg /etc/mysql/fabric.cfg

Modify the configuration file and include the users and passwords defined in the previous step (Section 8.2.3.1, “Create the Associated MySQL Users”), here is an example Fabric configuration file:

[DEFAULT]
prefix = /usr/local
sysconfdir = /usr/local/etc
logdir = /var/log

[storage]
address = localhost:3306
user = fabric_store
password = secret
database = mysql_fabric
auth_plugin = mysql_native_password
connection_timeout = 6
connection_attempts = 6
connection_delay = 1

[servers]
user = fabric_server
password = secret
backup_user = fabric_backup
backup_password = secret
restore_user = fabric_restore
restore_password = secret
unreachable_timeout = 5

[protocol.xmlrpc]
address = localhost:32274
threads = 5
user = admin
password = secret
disable_authentication = no
realm = MySQL Fabric
ssl_ca =
ssl_cert =
ssl_key =

[protocol.mysql]
address = localhost:32275
user = admin
password = secret
disable_authentication = no
ssl_ca =
ssl_cert =
ssl_key =

[executor]
executors = 5

[logging]
level = INFO
url = file:///var/log/fabric.log

[sharding]
mysqldump_program = /usr/bin/mysqldump
mysqlclient_program = /usr/bin/mysql

[statistics]
prune_time = 3600

[failure_tracking]
notifications = 300
notification_clients = 50
notification_interval = 60
failover_interval = 0
detections = 3
detection_interval = 6
detection_timeout = 1
prune_time = 3600

[connector]
ttl = 1

Each section has one or more variables defined that provide key information to the MySQL Fabric system libraries. You might not have to change any of these variables other than the users and passwords. For more information on the sections and variables in the configuration file, see Section 8.2.3.3, “Configuration File Sections”.


User Comments
Sign Up Login You must be logged in to post a comment.