The Ultimate Guide to High Availability with MariaDB

multi master setup with schema sharding

You are viewing an old version of this question. View the current version here.

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?

Thank you

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.