Tuesday, May 12, 2009

Patch for global transaction IDs, binlog event checksums and crash-safe replication state

Justin just added a patch for global transaction IDs, binlog event checksums and crash-safe replication state. It is at code.google.com. This patch is based on MySQL 5.0.68, so Justin did a bit of work to port code forward from the version we use (5.0.37).

Well, I assume that this includes support for crash-safe replication state. This replaces transactional replication. But it works for all storage engines.

Percona has ported a few of the replication features from previous Google patches. Hopefully, they are interested in these changes. MySQL has semi-sync replication in 6.0 with a promise to backport to 5.4. Perhaps these changes will end up there too.

5 comments:

  1. Yes, the patch includes the crash-safe replication work. When running with the patch, turn the feature on with --rpl-hierarchical-slave-recovery on the command line or in the my.cnf.

    ReplyDelete
  2. Thanks! That's excellent.

    Vote to post it on LaunchPad !! :)

    ReplyDelete
  3. Code is now in a branch on LaunchPad: https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids.

    ReplyDelete

 
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.