multi master setup with schema sharding
Hello, I would create a master-master setup with several slaves attached.
Master-1 will receive the writes of schema1 while Master-2 will receive the writes of schema2. This way I can spread the writes on 2 servers and those 2 writes don't conflit (can't create problems). All the slaves will replicate from both master (possible now).
I'd like to find a way to manage this in MaxScale, failover too. Basically I would that the writes of schema1 will go to Master-1 (as said), but if that master is down they go to Master-2. The same for the writes of schema 2, they should go to Master-2, but if this master is down should go to the other master.
Possible to achieve this?