Re: [Maria-discuss] Testing Slave's data integrity

2020-07-24 Thread Jeff Dyke
Yes percona toolkit is great. But executing a lot of those tools on a large dataset can take time. If you have spent the time to put up "a couple of slaves". Those can be transitioned into being a galera cluster. The way i use the cluster, is to route all traffic through HAProxy(there are other

Re: [Maria-discuss] Testing Slave's data integrity

2020-07-24 Thread Vincent Hoffman-Kazlauskas
I'd have a look at the percona toolkit https://www.percona.com/software/database-tools/percona-toolkit. Its free and got loads and loads of useful stuff but for this in particular have a look at https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-checksum.html Vince On 23/07/2020 19:53, R

[Maria-discuss] Testing Slave's data integrity

2020-07-23 Thread Richard Reina
Good afternoon, I have a couple slaves that I have set up over the last year. Is there a way to perhaps compare them to the master on a database or table level to ensure their integrity? Thanks ___ Mailing list: https://launchpad.net/~maria-discuss Post