Atom feed of this document
  
 

 Highly available MySQL

MySQL is the default database server used by many OpenStack services. Making the MySQL service highly available involves

  • configuring a DRBD device for use by MySQL,
  • configuring MySQL to use a data directory residing on that DRBD device,
  • selecting and assigning a virtual IP address (VIP) that can freely float between cluster nodes,
  • configuring MySQL to listen on that IP address,
  • managing all resources, including the MySQL daemon itself, with the Pacemaker cluster manager.
[Note]Note

MySQL/Galera is an alternative method of configuring MySQL for high availability. It is likely to become the preferred method of achieving MySQL high availability once it has sufficiently matured. At the time of writing, however, the Pacemaker/DRBD based approach remains the recommended one for OpenStack environments.

Questions? Discuss on ask.openstack.org
Found an error? Report a bug against this page

loading table of contents...