Introduction

Currently Cloud Stack has only one active master DB setup. Going forward it should support multiple Master/Slave cluster setup to enable High Availability of the Database.

Scope

To Achieve Active/Active cluster set up (Multiple masters and slaves).

Options Available

1. MariaDB
2. Percona Xtra DB (uses Galera cluster)
3. MHA provided by SkySql
4. Mysql Active/Active setup with connector specific configuration to read from slaves in case of master goes down

Results

# MariaDB

1. • It does not support any DB HA out of the box, we can use Galera with it but the same can be used with Mysql directly