0

Is it possible to configure replication with one master node and 2 slaves in MariaDB like replication works in mongodb? I noticed that the default is multi master mode. Thanks in advance.

1

Yes, of course. Standard replication configuration is master and single or multiple slaves. If you use MariaDB Galera cluster you can point your applications to a single node and the other two serves as slaves.

| improve this answer | |
  • thanks. my mention of master relates to writes. I want to be sure that writes are not possible via slaves. After Galera was up, i saw that writes are possible via all the nodes. So it's multi master from the 'writes' point of view – rok Jan 26 '17 at 15:22
  • 1
    writes are still possible, but you can set read_only=1 on the 'slave' nodes and remove SUPER privs on regular mysql accounts. – jerichorivera Jan 26 '17 at 15:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.