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.
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. However, when the master goes off-line, the slaves are still looking to the master. 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? bayes_learn_to_journal 1 bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:bayesdb:db.example.com # master system bayes_sql_username amavis # sitewide user bayes_sql_password password I've also configured txrep in mariadb as part of this replication that I would like to make more fault tolerant. use_txrep 1 txrep_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:txrepdb:db.example.com user_awl_sql_table txrep user_awl_sql_username amavis user_awl_sql_password password Thanks, Alex
