replication-manager icon indicating copy to clipboard operation
replication-manager copied to clipboard

Multi master topology- GUI shows one as slave.

Open hobsRKM opened this issue 4 years ago • 1 comments

image

I have multi-master topology and tested it and bi-directional sync is working on write, but replication manager status is showing one as master and the other has slave instead of showing both as master and master in the status column. Is this intended or a bug on replication-manager UI?

hobsRKM avatar Jan 15 '21 04:01 hobsRKM

HI HobRKM ,

Yes this is intended so far replication-manager will not allow writes to happen on all master in regards to the proxies so it elect one of the nodes to be the master and set the other one to be read only declaring it as a slave. managing eventually consistency topology is not very complex regarding databases topology just use a different domain-id for each node and use weight in each ProxySql to write to is colocated master , but you will put yourself at risk with auto-increment and in case of split brain you can may end up with wrong consistency of updates . Auto increment can be managed using custom PK like UUIDSHORT ot auto increment increment.

svaroqui avatar Jan 15 '21 08:01 svaroqui