maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05867
Re: Testing Slave's data integrity
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Vincent Hoffman-Kazlauskas <vince@xxxxxxxxxxxx>
-
Date:
Fri, 24 Jul 2020 11:55:40 +0100
-
Autocrypt:
addr=vince@xxxxxxxxxxxx; prefer-encrypt=mutual; keydata= mQGiBESPz78RBADybNTkAA4eQLuwYC1Qsn7qaDLzBvq2RmA0niwngigEPy/tLh9aF2zR85fL PTvxh9MyLzFZHc5RVO0tKM93CSRXjTo5xo2P1/YTopPyzTBB3eOB7uqJRi+suBnKPfXvkeW1 g5yo3pKINsqW0ed91lDwrQ1NofbIFkOOYnhQpccdiwCg0GF13Vk9Rz683bkSawFethAcVx8E AKGPTj6KfVmnhB8a3y0UeZ46LMfoZnjLF4ZDMtrZHY639zbZBJiKJ/M1B8z3GJgmRmOEXoW4 Mdoi0XaSkinIWmtdI+vhIfb/7ufFzujM0wEbEnpJ/mvTuSas6DG7MPMiJMavz3Hf/dVOX7Dd Ma+z03JKIHuMj8HVMFccjgFJLmteBADkdDBQin+YzgGuPs/Sf8KvVPVRDT5QJkHUEU/gcmSP YbPfmwC7tl1iXR9Gu4foQyk2UJJezCRUWggNScybcrLp2jQ0XWkw18uus/QC2ZCfW/f2vXg8 uL5W7cLGbeSKh3K0CFMbACmcrcMZk7JwW9a/VlAhmqOUk1MYJ1rR2ZZIp7QmVmluY2VudCBI b2ZmbWFuIDx2aG9mZm1hbkBuYW1lcy5jby51az6IYAQTEQIAIAUCRI/PvwIbAwYLCQgHAwIE FQIIAwQWAgMBAh4BAheAAAoJEMQkmEPMfxC+ik0An0EFsHC1cTRRq+MgAWoM3WRvOeQFAJ9D 2GwjK6Zaiu6s+KaxeWh4yrk0JbkCDQREj8/REAgA5AQP4RpCo/O9U/Zd4s0mArJpGQhAnYb8 2r+u3e/MyGK5hTH+ODAOZ1TeiPb75xYQ9QGOX+ygpCSDmDjG+MJyPivdZMuuwnhisYZPNuhE Tw/CdP5mekqPzZAvIqBi5q6Bdmz0tORu4L6y/zPnQ8qrkBnibK9AOKz1XkguOlzcIlfxpsOC AgTRWoOpW8oQtQl80Ik22prSExgKllBfq3/sRix28r86L51P5hHG7mlWtbv8txaLyihBO3aw mkTXLAk5IMgrlillkDvMYUsO7lOkwk54C3oq+lYarNJ4Ul7Wfyg1ufjCc8CynXrlgFMJ+wbg Uhk4lbidSuGRkT10yqlNrwAECwf/YA3W3eSNQIn6s5eBTR+Qocmp+11zTNQMwB3xRzKQFBBd UwTbFiyhxMS7+xJzEUzuhTOy/OI/QCto595C/68y53TU0fwII0e2XLRYDIWO1FqSCGyDMviO 1ixnSHMkXeIEPbalF9n+KB2ozX0OOxl3oA7wt/DmOq8nLNzCMOKHD6mJRnBAp0En9WYpnbSl nucjh2+Ry9XAK5HCZ9k1SWxFPCEvxv4nwhZnYFdm5O4M6MHw8T/viWIBa96yt2CTGP7gOz+s YKcjUTQ7UdtYFVguGW9uehvtqbCLv69clBCmooRYAmTkiupI8R1zIfKVDjllDONWoPZfCz2d LwHnLW/ZMohJBBgRAgAJBQJEj8/RAhsMAAoJEMQkmEPMfxC+he0An3g4+nwMH9lsde9IFgQY TDhDySz9AKCZSsEaPlGPvj7Fd7c47Eh4Nt9j9w==
-
In-reply-to:
<CAKLxnzbi9CvWKk+PGrVQCaXO07UKUS0XxwZmqnbAkLk6LS0Nsw@mail.gmail.com>
-
User-agent:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Thunderbird/68.10.0
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, Richard Reina wrote:
> 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 to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
>
Follow ups
References