MySQL Forums
Forum List  »  MySQL Administrator

MySQL replication - possible problems
Posted by: HEDG ,,,
Date: December 04, 2012 09:21AM

Hello All!
People, there is little question about mysql replication
There is a master and slave.
Type bin logs on master - STATEMENT.
If you fall off replication, most online sources recommend the following steps.
on slave
mysql> stop slave;
on the master
mysql> flusr logs;
mysql> show master status;
Here we find the name of bin log on the master and the position in it.

go to slave and specify a new log name and position in it and execute command change master ...
Do on the slave
mysql> start slave;

So, the actual question:
If the slave can not continue to read from the current position in the bin log on the master, it is given a new log name and new position. In this situation, some of the data from the bin logs on the slave may be omitted, because the next binlog we start reading from the new position ignoring the previous data.
Ie it turns out that a certain amount of SQL queries (which are stored in the bin logs) are not met?
Ie it turns out that the data on the slave will not get and therefore lost synchronization database?

Thanks in advance for your help!

Edited 1 time(s). Last edit at 12/04/2012 09:22AM by HEDG ,,,.

Options: ReplyQuote

Written By
MySQL replication - possible problems
December 04, 2012 09:21AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.