Bug #13604 | MASTER_POS_WAIT and lock at pos | ||
---|---|---|---|
Submitted: | 29 Sep 2005 12:47 | Modified: | 29 Sep 2005 13:43 |
Reporter: | Martin Friebe (Gold Quality Contributor) (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | 4.1 | OS: | Any (*) |
Assigned to: | CPU Architecture: | Any |
[29 Sep 2005 12:47]
Martin Friebe
[29 Sep 2005 13:37]
Guilhem Bichot
Hello, what you ask for has also been suggested by another user not long ago, so we have it on our long-term TODO. I think that for now you could use the START SLAVE UNTIL command to do the synchronization: #slave stop slave sql_thread; #master lock table t1; show master pos; #slave start slave sql_thread until (<values from above>); lock table t1; #master checksum table t1; unlock tables; #slave checksum table t1; unlock tables; start slave sql_thread; How does this sound?
[29 Sep 2005 13:43]
Martin Friebe
Does exactly what I am looking for, sorry, didnt research good enough, thanks anyway