Hi,
"WARNING: When using Galera Cluster in master-slave mode, all four isolation levels levels are available to you. In multi-master mode, however, you can only use the REPEATABLE-READ level"
We did not know you can run a galera cluster in master-slave mode? We wanted to run galera in multi-master mode, and connect our drupal web sites to galera through proxysql.
Questions:
1) where can I read more on galera in master-slave node, in order to make
all four (including the read-commited) isolation levels levels available?
2) if configure proxysql to redirect all WRITES to the same galera backend server and use the other galera nodes only for reading, how real is the risk of these deadlocks?
But also more generally: anyone with tips and ideas on the subject of drupal with galera, do's and don'ts, anything is welcome really. (success stories, as well as failures)
Or ideas for other DB solutions to achieve HA and maximise db uptime, spread load and reduce SPoFs.
Thanks in advance!
MJ