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.7.4.5 Configure MySQL Fabric

On just the one (DRBD active) host, do the following:

shell> cp /etc/mysql/fabric.cfg /var/lib/mysql_drbd/fabric.cfg
shell> chmod 600 /var/lib/mysql_drbd/fabric.cfg
shell> chown root:root /var/lib/mysql_drbd/fabric.cfg

Edit the /var/lib/mysql_drbd/fabric.cfg:

  1. Set address to 192.168.1.200:32274 in the [protocol.xmlrpc] section

  2. Set password to password in the [protocol.xmlrpc] section

  3. Set address to 192.168.1.200:32275 in the [protocol.mysql] section

  4. Set the password to password in the [protocol.mysql] section

  5. Set the password to secret in the [storage] section

Warning

Do not change the address in the [storage] section.

Take the opportunity to set the other options if you need/want to do so, specially the user/password in the [servers] and [client] sections. Finally, create MySQL Fabric's state store as follows:

[root@host1]# mysqlfabric --config /var/lib/mysql_drbd/fabric.cfg \
   --param protocol.xmlrpc.address=localhost:32274 \
   --param protocol.mysql.address=localhost:32275 manage setup

From this point onwards all resources are managed by the clustering software so they have to be stopped:

[root@host1]# /etc/init.d/mysql stop
[root@host1]# umount /var/lib/mysql_drbd
[root@host1]# drbdadm secondary clusterdb_res

Then DRBD should be stopped as well:

[root@host1]# /etc/init.d/drbd stop
[root@host2]# /etc/init.d/drbd stop

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