maria-discuss team mailing list archive

[Richard Reina <gatorreina@xxxxxxxxx>]

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, <Rhys.Campbell@xxxxxxxxxxxx> escribió:

> 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 <maria-discuss-bounces+rhys.campbell=
> swisscom.com@xxxxxxxxxxxxxxxxxxx> *On Behalf Of *Richard Reina
> *Sent:* 19 March 2019 16:31
> *To:* maria-discuss@xxxxxxxxxxxxxxxxxxx
> *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-tesla-where-id-420-not-updating-on-slaves?noredirect=1#comment97043196_55151424
> 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
>
>
>
>
>