[Building Sakai] distributed databases

[Charles Hedrick]

Is there any experience with a distributed database for Sakai, particularly with mysql or mariadb? We’re going to be installing a server in a new data center, but can probably keep the existing system. It would be attractive to us to have databases kept in sync, so that we could do essentially immediate automatic failover. 

From the documentation, it looks to me like Galera Cluster would work. The main constraints seem to be that you can do “lock tables,” that all tables need an index, and that you can’t depend upon auto increment columns being allocated sequentially.