On Friday 20 July 2018 at 01:47:38, Alex wrote:
> Hi,
>
> I'm trying to configure bayes in mariadb to have a central database
> that is replicated across multiple systems so they can all share the
> same database.
Are you using Galera for the replication?
> I thought the best way to do that would be to have one master with
> multiple slaves that all write to the master. I've configured the two
> other systems as slaves and replicated the databases between them.
That sounds like strange terminology - "slave" usually means a machine which
replicates *from* a master, but can't write back to it.
Two machines replicating to each other, either of which can be written to,
would generally be called "master-master replication" (and can be done with
MariaDB or MySQL, without using Galera).
If you want more than two machines, all replicating to each other, and any of
which can be written to, I would only consider doing this with MariaDB +
Galera, since the alternative (MySQL or MariaDB in Master-Master ring-
replication) is too fragile and difficult to recover from breakages in the
network connectivity (in my opinion).
> However, when the master goes off-line, the slaves are still looking
> to the master.
What do you mean by "looking to"? Are the slaves able to accept local
updates, or are they dependent on the master to be able to resolve queries and
apply updates to the DB?
> How can I configure it to either fallback to the local replicated copy or
> otherwise configure it to be more resilient in case of failure?
It sounds like Galera (which is automatically installed if you're using
MariaDB 10.1 or later) is the solution to your problem.
Give us a few more details about:
- the version of MariaDB you're using
- the distribution (and version) you've installed this on
- the replication setup you're using between the "master" and the "slaves"
That may give us more ideas about how you can achieve what you want.
Antony.
--
A user interface is like a joke.
If you have to explain it, it means it doesn't work.
Please reply to the list;
please *don't* CC me.
