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
Alternatively, the optional
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
|Ubuntu Linux 14.04||mysql-utilities_1.5.6-1ubuntu14.04_all.deb||
|Debian Linux 6.0||mysql-utilities_1.5.6-1debian6.0_all.deb||
|Red Hat Enterprise Linux 6 / Oracle Linux 6||mysql-utilities-1.5.6-1.el6.noarch.rpm||
Modify the configuration file and include the users and passwords defined in the previous step (Section 22.214.171.124, “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 126.96.36.199, “Configuration File Sections”.