On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine nor...@khine.net wrote:
hello,
i have a working master-slave replication, the problem i find is that
if i restart the MASTER there is a difference in the MASTER_LOG_FILE
and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two
since u r starting slave by postion beyond master, and if some of the
changes are already present on slave, it would error out with duplicate.
You need
show slave status\G;
slave stop;
show slave status\G;..wait for few min..than again
show slave status\G;just to make sure...slave is in
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either the master or
slave. If the master is down, then the slave recieves no updates. If
the slave is down, when it comes back up it checks the master log pos
and plays thro any changes that are
True,
But some times, this does not work and u need to know the master bin-log
file and position to start, so that there is no loss of data.
regards
anandkl
On Thu, Aug 26, 2010 at 6:39 PM, a.sm...@ukgrid.net wrote:
That is really bad, you will loose changes.
You shouldnt have to do anything
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
On Thu, Aug 26, 2010 at 3:09 PM, a.sm...@ukgrid.net wrote:
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either
Yes,
You need to note down the master bin-log file name and position on the
slave, this is a must.
regards
anandkl
On Thu, Aug 26, 2010 at 7:34 PM, Norman Khine nor...@khine.net wrote:
i see, so the best is to just stop slave and then check the master
status, and when the master status
Quoting Norman Khine nor...@khine.net:
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
Well Im willing to hear from others experiences, but if you really
shouldnt have to do anything. If you want you can
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
On Thu, Aug 26, 2010 at 8:48 PM, a.sm...@ukgrid.net wrote:
Quoting Norman Khine nor...@khine.net:
i see, so the best is to just stop slave and then check the master
status, and when the
Hi,
The best way to use sync the master and slave is using mk-checksum tools. just
google it and use the the tools for online sync of master and slave.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Norman Khine nor...@khine.net wrote:
From: Norman Khine nor...@khine.net
Subject:
Quoting Ananda Kumar anan...@gmail.com:
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
If you have experience of this fair enough. Theres no reason it should
make any difference, as everything is based upon the binlog file and
Quoting jitendra ranjan jitendra_ran...@yahoo.com:
Hi,
The best way to use sync the master and slave is using mk-checksum
tools. just google it and use the the tools for online sync of
master and slave.
Jeetendra Ranjan
MySQL DBA
Yes, data integrity isnt guaranteed with MySQL
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row ***
Slave_IO_State:
Master_Host:
Hello List,
On 8/26/2010 3:00 PM, Daevid Vincent wrote:
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row ***
13 matches
Mail list logo