![](https://secure.gravatar.com/avatar/9436a3d9b045a3bf216ff93b88fad32e.jpg?s=120&d=mm&r=g)
Rhys, Thank you very much for the reply. I have to decide if I will stick
replication, replication with MaxScale or migrate to a maria galera
cluster. In any case I have a lot of learning to do.
Thanks again.
Richard
El mié., 20 mar. 2019 a las 3:27,
In general I advise avoiding all replication filtering where possible. For whatever advantage it supposedly gives it very often just causes other problems.
Checkout pt-table-checkum for verifying your slaves…
https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-checksum.html
Also have a look at row-level replication and GTIDs. They will toughen up your repl setup.
MariaDB Tech Support https://mariadb.com/services/technical-support-services/
*From:* Maria-discuss
*On Behalf Of *Richard Reina *Sent:* 19 March 2019 16:31 *To:* maria-discuss@lists.launchpad.net *Subject:* [Maria-discuss] OT Advice Sought: Migrating from to MySQL replication to Maria cluster Since 2001 I have been running MySQL for a database application that runs on a private LAN. There all only a few users but the data is important to me so I have had replication with a handful of slave servers -- I also backup daily with mysqldump. I recently found out that my slaves were broken -- in that not all update quieres replicate becuase I configured them wrong using replicate-ignore-db. https://stackoverflow.com/questions/55151424/update-database-table-set-name-... My master server is also pretty old and running an old version of MySQL. It is definitely time to upgrade.
My question is should I try to migrate to MariaDB replication or MariaDB/Galera Cluster? How much harder is configuring and maintaining a DB cluster vs replication? Does MariaDB have any paid support option where I can hire someone to help me set up a DB cluster?
Thanks,
Richard