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 | |
---|---|
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. |