MySQL Forums
Forum List  »  Replication

[suggestion]Is writing relay log necessary in slave?
Posted by: feng guo
Date: December 20, 2014 08:20AM

I have a question about slave's relay log mechanism -- Why is relay log necessary?Why not applying SQL after getting master's binlog immediately?
What I mean is to disable writing relay log to disk, just use a small memory area to receive binlog from master and then executing master's binlog SQL,When a SQL statement was applied,then writing this SQL's corresponding master's binlog file name and position to an transaction safe table,even slave crashes suddenly, reading this transaction safe table could know where to receive from master~
I think this approach could avoid slave disk's relay log writing load~

I just do one thing all my life--do things interesting me!
Blog: www.leafonsword.org

Options: ReplyQuote


Subject
Views
Written By
Posted
[suggestion]Is writing relay log necessary in slave?
1579
December 20, 2014 08:20AM


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.