On Friday 20 July 2018 at 02:52:48, Alex wrote: > Hi, > > On Thu, Jul 19, 2018 at 8:05 PM, Antony Stone wrote: > > 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.
> > 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). > > I wasn't aware I needed Galera to do that. It's certainly the easiest way to get multiple writeable masters set up. > This ensures that all content is sync'd to all systems at all times? Yes. > >> 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. > > Tips on how to get that going would be appreciated. I found these helpful: https://mariadb.com/kb/en/library/getting-started-with-mariadb-galera-cluster/ http://galeracluster.com/documentation-webpages/ > I followed the basic mariadb replication instructions Okay, that'll be traditional MySQL-style Master-Slave replication (which can be extended easily enough to Master-Master for a single pair, but gets very "delicate" once you try to have more than two Masters which can be written to). > This is on fedora28 x86_64. > > # rpm -q mariadb-server > mariadb-server-10.2.16-1.fc27.x86_64 Looks good. It's even a later version than I use with Debian Stretch. > after using this guide to set up bayes in mariadb: > https://svn.apache.org/repos/asf/spamassassin/branches/3.4/sql/README > > No bayes autolearn. Good luck :) Antony. -- Just when you think you're done, a cat floats by with buttered toast strapped to its back. - Steve Krug, "Don't make me think" Please reply to the list; please *don't* CC me.
