EmergencyEMERGENCY? Get 24/7 Help Now!

Global Transaction ID and other patches available!


Posted on:

|

By:


PREVIOUS POST
NEXT POST
Share Button

I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on Launchpad (https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids).

For me it was a big wall in using these patches that they were part of one big patch, which you can apply only to 5.0.37, and now there is no barrier to include patches into our builds or MySQL releases.

If you do not know what is Global Transactional ID is – it is worth to look http://code.google.com/p/google-mysql-tools/wiki/GlobalTransactionIds. From my point of view – it is absolutely new view on MySQL replication and it can change MySQL replication architecture.

We definitely will look if we can integrate patches into percona builds and provide binaries if there is no problems. Also I mostly sure the patches will be included into MariaDB along with other Percona-improvements and XtraDB storage engine.

Share Button
PREVIOUS POST
NEXT POST


Vadim Tkachenko

Vadim 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. Percona Labs designs no-gimmick tests of hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products. He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.



Tags:

Categories:
Percona Software


Comments
  • Mark Callaghan

    Justin did a great job on this and I can’t wait for it to show up in a Percona binary.

    Reply

  • will you add the innodb-freeze patch to xtradb?

    Reply

  • global-transaction-id will support row based replication?

    Reply

  • Vadim Post author

    uxio,

    No we are not going to add innodb-freeze to xtradb, we have xtrabackup to cover our backup needs.

    Reply

  • Vadim Post author

    uxio,

    As far as I understand global_transaction_id does not work with row-level replication.

    Reply

  • Mark Callaghan

    The innodb-freeze patch needs much more work to be stable in production.

    The global transaction id patch is published for 5.0. Row-based replication is not available in 5.0.

    Reply

  • We’ve been using innodb freeze for a while now but I think that in conjunction with LVM snapshots we’ve been avoiding any bugs with it…

    It’s redundant now though with LVM snapshots.

    We were using innodb freeze BEFORE we started using LVM to bypass a bug in xfs_freeze…

    Would be nice if it were fixed though so that we don’t have to rely on LVM.

    Reply

  • Kevin,

    How do you do backups ? Why do you need innodb freeze ? As I said we think xtrabackup makes innodb freeze unneeded.
    But if you still interested in innodb_freeze you know how to contact us :)

    Reply

  • We use this primarily to do slave clones….. I saw your note about xtrabackup doing clones but I have not yet had a chance to look at it.

    Our current setup works 😉

    Reply

Leave a Reply

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.