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.

Improve this question

1 Answer 1

Reset to default
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
2
  • 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, 2017 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, 2017 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.