8.2.3.2. Configuration File

The next step is to modify the configuration file with the user and password we defined in the previous step (Section 8.2.3.1, “Create a MySQL User”). Open the configuration file located in /usr/local/etc/mysql/fabric.cfg on Unix and Linux systems.

The following shows the content of the configuration file and the modifications necessary. In the [storage] section, store the user and password of the user created in the previous step.

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

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

[servers]
user = fabric
password = 

[protocol.xmlrpc]
address = localhost:32274
threads = 5
user = admin
password = 
disable_authentication = no
realm = MySQL Fabric
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

[client]
password = 

Each section has one or more variables defined that provide key information to the MySQL Fabric system libraries. You should not have to change any of these variables other than the user and password for the backing store (in the storage section). For more information on the sections and variables in the configuration file, see Section 8.6, “Configuring MySQL Fabric”.


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