Well that was freakishly easy. Thanks again Digital Ocean. Seemed easier to set up than master-slave replication and this is way more featureful in that you can write to any node in the cluster, not just the master.
There may be a way to override this, but its like every Galera node is the same server. With a master-slave setup, you have to be careful about individual databases. I suppose this could be useful if you wanted to have a master put databaseA on slave1, and databaseB on slave2, but from the Digital Ocean tutorial on Galera, this is way simpler. Really blown away by how easy this was to set up.
Leave a Reply