I am looking to experiment with MariaDB 10 Galera Cluster. I am looking for highly available, scalable and reliable architecture. Basically I am curious what would be the better architecture and would this be possible and is it a good practice?
1) Galera Cluster + maxscale for spliting read write operations - here I'll logically separate both read/write operations. I want the writes to be applied on all nodes but eventually to have a specific nodes only for read operations. Similar like Master-Slave replication where writes goes to the master and slave goes to the slaves. Would this be possible here?
2) Galera Cluster with Master-Master replication and can I connect another Galera Cluster to this only for read operations?
My main goal would be to have couple of write nodes and couple of read nodes so I can split the operations and actually have a backup of each node if somethings goes wrong? What would be the best approach here?