spamassassin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antony Stone <Antony.St...@spamassassin.open.source.it>
Subject Re: Replicating bayes in mariadb over multiple systems
Date Fri, 20 Jul 2018 08:49:48 GMT
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.

Mime
View raw message