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


MySQL Utilities 1.5 Manual  /  ...  /  Old Configuration System

8.2.5 Old Configuration System

Important

This documentation describes the MySQL Fabric configuration before version 1.5.5. The previous configuration documentation is archived here for informational and upgrade purposes.

Configuring MySQL Fabric requires creating a MySQL user to access the backing store, and editing the configuration file with the MySQL user details. This section assumes you have already set up the backing store. See Section 8.6, “Backing Store” for more information.

Create a MySQL User

The first thing you must have is a user account on the MySQL server that you plan to use for your backing store. The user account information is stored in the configuration file.

The user account must have full privileges for the database named fabric. To create the user and grant the privileges needed, use the following statements:

CREATE USER 'fabric'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL ON fabric.* TO 'fabric'@'localhost';

In the preceding example, substitute a password of your choice (replace 'secret'). Also, if you are going to run MySQL Fabric on a host other than where the backing store resides, substitute the 'localhost' for the host name.

MySQL Fabric uses the same user account, who must have all privileges on all databases, to access all MySQL servers that it manages. The user and password are defined in the configuration file as shown below. To create this user and grant all the necessary privileges, execute the following command on all MySQL servers:

CREATE USER 'fabric'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL ON *.* TO 'fabric'@'localhost';

In the preceding example, substitute a password of your choice (replace 'secret'). Also, if you are going to run MySQL Fabric on a host other than where the managed MySQL servers reside, substitute the 'localhost' for the Fabric's host name.

Configuration File

The next step is to modify the configuration file with the user and password we defined in the previous step. Open the configuration file:

MySQL Fabric configuration file location

Table 8.2 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

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 =
backup_user = fabric
backup_password =
restore_user = fabric
restore_password =
unreachable_timeout = 5

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

[protocol.mysql]
address = localhost:32275
user = admin
password =
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 should not have to change any of these variables other than the user and password for the backing store (in the storage section).


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