Group Replication support SAVEPOINT

Group Replication has been around as GA for some months now. Nonetheless, work continues and now we are happy to let you know that you can now use transaction savepoints when write-set extraction is enabled.

This enhancement was released as in MySQL 8.0.1.

The SAVEPOINT statement sets a named transaction allowing to parts of a transaction to be rolled back before COMMIT.

This behavior has some implications on write-set extraction, since on ROLLBACK TO the collected transaction write set – the identification of the changed rows on the current transaction – needs to be updated,  ensuring that the transaction changes and the corresponding write-sets are consistent between each other.

Moreover, now that SAVEPOINTS are supported when write-set extraction is enabled, mysqldump can be used with the –single-transaction option –single-transaction without the need of locks.

Download the new MySQL 8.0.1 DMR and check it out. As usual, lets us know your feedback, e.g., through bug reports, feature requests, the replication mailing list or even through comments on this or other blogs on this website. Mind you that MySQL 8.0.1 is a development milestone release (DMR), thence not declared generally available yet. Use it at your own risk.

 23,102 total views,  16 views today

About Aníbal Pinto

I am a group replication developer since 2016, just in time of first release of Group Replication on a GA version, 5.7.17. My main focus is improving Group Replication be it by fixing details or adding new features to simplify users life when setting up High Availability solution.

5 thoughts on “Group Replication support SAVEPOINT

      1. Hi Antonio,

        Not in 5.7.18, but keep an eye out for the next 5.7 maintenance release. You should see at least one thing in the release notes that will make you happy. 🙂

        Best Regards

Leave a Reply