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

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread Vincent Hoffman-Kazlauskas
On 03/04/2019 08:54, mj wrote: > Hi, > > On 3/28/19 11:59 AM, Reindl Harald wrote: >> our production datadirs date back to 2002, originally on windows then >> moved to MacOS and in 2008 to Fedora and i did not dump/restore a single >> time in my whole life, this is not postgresql > > Just curio

[Maria-discuss] Drop user not replicating in 10.2.16/17 galera cluster with NO_AUTO_CREATE_USER in mysql_mode

2018-08-15 Thread Vincent Hoffman-Kazlauskas
Hi all, not sure if this is expected or not. I am running a test cluster in preparation for upgrading from 10.0 to 10.2 and noticed that DROP user commands were not being propagated to other members of the galera cluster. The only user management changes of note I know of was the addition of NO_A