Re: MySQL Enterprise Backup Remotely
Posted by:
Rick James
Date: March 09, 2012 09:41AM
> sync with the slaves binary log positions
I need to quibble with the terminology. Do are you really referring to the Slave's "binlog"?...
A Master has "binary logs" ("binlogs").
A Slave has "relay logs".
A Slave _may_ have binlogs, too, if it replicating to (being master to) other Slaves. (Maybe MEB requires Slaves to turn on binlogging?)
The two or three logs contain the same information (barring replicate/binlog-do/ignore-* statements), but the are _not_ interchangeable. FLUSH LOGS and other actions cause a log file to be closed and a new one to be started, but _only_ on the machine where the FLUSH LOGS is performed.
That is, filename and position are machine-specific.
Subject
Views
Written By
Posted
3487
March 05, 2012 03:39PM
1686
March 06, 2012 09:07AM
1770
March 07, 2012 10:28AM
1852
March 07, 2012 11:16AM
1721
March 08, 2012 09:07AM
Re: MySQL Enterprise Backup Remotely
1609
March 09, 2012 09:41AM
2137
March 09, 2012 10:00PM
1506
March 09, 2012 10:19AM
2017
March 09, 2012 10:02PM
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.