Comment 0 for bug 2066585

By following the tutorial:
https://microstack.run/docs/multi-node-maas

3 MySQL instances (for HA) per service will be deployed as follows. It comes with 21 MySQL instances out of the box, and more to be added when adding more services like octavia for example.

Splitting database into per-service might be a good idea for scalability and to be more microservice-y. However, those 21 instances are running on the same physical machine so it doesn't give many benefits in terms of performance.

Moreover, this micro DB everywhere approach comes with operational burden. An operator has to take a backup of all databases instead of one, and I don't think OpenStack allows inconsistency between those data bases. Meaning OpenStack can work with separate database per service in normal circumstances, but snapshot of the database must be consistent across all of the databases otherwise Nova, Neutron, and Cinder can disagree about the status of a VM (Nova might think the VM is deleted, but Neutron and Cinder might think the resources are still used, etc.).

cinder-mysql/0
cinder-mysql/1*
cinder-mysql/2
glance-mysql/0
glance-mysql/1
glance-mysql/2
horizon-mysql/0
horizon-mysql/1
horizon-mysql/2
keystone-mysql/0
keystone-mysql/1
keystone-mysql/2
neutron-mysql/0
neutron-mysql/1
neutron-mysql/2
nova-mysql/0
nova-mysql/1
nova-mysql/2
placement-mysql/0
placement-mysql/1
placement-mysql/2*