search

hugowan / maatkit

Automatically exported from code.google.com/p/maatkit
0 stars 0 forks source link

check and report after running mk-table-checksum --replicate #24

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently you can either do a checksum operation, or check the results of a
checksum operation. When using --replicate, they should be possible to do
one after the other. An optional MASTER_POS_WAIT() to let the slave(s)
catch up would be a good idea.

The recursive check operation is depth-first, which is not good if the
slave takes a while to catch up. Breadth-first would be a better idea.

Original issue reported on code.google.com by baron.schwartz on 6 Aug 2008 at 1:38

GoogleCodeExporter commented 9 years ago

Original comment by baron.schwartz on 1 Oct 2008 at 3:11

GoogleCodeExporter commented 9 years ago 
Bulk update -- these are issues that are looking for either a well-tested
patch, or a sponsor to pay for development.

Original comment by baron.schwartz on 25 Dec 2008 at 4:41

GoogleCodeExporter commented 9 years ago 
Changing to Enhancement

Original comment by baron.schwartz on 25 Dec 2008 at 10:06

GoogleCodeExporter commented 9 years ago

Original comment by dan...@percona.com on 3 Jun 2009 at 7:21

GoogleCodeExporter commented 9 years ago 
We need a function in MasterSlave.pm that will get a list of all slaves, get the
master's current position, and then sleep in a loop until all slaves have 
passed the
master's position.

Then, mk-table-checksum needs to do the checksum, get the master's position, 
and wait
till all slaves have passed that position, then run --replicate-check.

If any slave has a connection failure during this process, it should just be 
dropped
from the list with a warning.

Original comment by baron.schwartz on 16 Dec 2009 at 4:38

GoogleCodeExporter commented 9 years ago

Original comment by dan...@percona.com on 23 Mar 2010 at 5:59

GoogleCodeExporter commented 9 years ago

Original comment by dan...@percona.com on 23 Mar 2010 at 6:00