Re: Does binlog stay in memory when replication happens?

2009-02-28 Thread Cui Shijun
hi, Thank you for your reply :-) > What does replication have to do with it? I wonder whether mysql will copy its binlog from memory( if it exists ) then send to slave. I haven't refer to the source codes yet... > Slave's binlog?  The slave's binlog is not tied to the master's > binlog.  I am n

Re: Does binlog stay in memory when replication happens?

2009-02-27 Thread Baron Schwartz
On Fri, Feb 27, 2009 at 7:04 AM, Cui Shijun wrote: > hi, >  I wonder if it is safe to assume that binlog can stay in master's > memory when replication happens It's not safe to assume. It varies from system to system depending on operating system, filesystem, scheduler algorithm, amount of memor

Does binlog stay in memory when replication happens?

2009-02-27 Thread Cui Shijun
hi, I wonder if it is safe to assume that binlog can stay in master's memory when replication happens. If not, when the binlog getts corruptted, will the slave's binlog also get corrupted? Is there way to make the slave's binlog survive even in master's disk failure? Thank you -- MySQL Gen