Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for:
- Backup of binary logs in real time
- High availability, to switch master load to slave with mirrored binary logs
By request of our friends EngineYard we extracted this patch from Google’s patchset and going to include in our next releases. Actually our patch contains features for both MirroredBinlogs and FastMasterPromotion patches, as second provides feature to make slave as master in case of main master failure.
At this moment you can download patch by itself there
https://www.percona.com/mysql/5.0.67-b6/patches/mirror_binlog.patch
with docs on our wiki
Also the patch will be included in OurDelta binaries beside our releases for CentOS / RedHat platform, so you can download and test this feature for your OS.
About the Author
Vadim TkachenkoVadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.
Yes it’s good stuff.
For OurDelta, thes patches (we’ll split them into separate ones for maintenance/porting reasons – we’ll want them in 5.1 etc as well) will be in the upcoming d7 build.
Thanks, my work is continued 🙂
Wei,
Thank you for patch!
Are you aware of any problems / bugs with patch ? Just to know if we need to look at something in details.