Not if servers are missing. There is no reliable way to correlate positions between servers when there is a server in between that is simply missing. We need TRUE global transaction IDs to do this programmatically and reliably.
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… tend to break MySQL replication (your point #2). These include global transaction IDs for safe slave promotion, crash-safe slaves, and built-in…
Comment: Global Transaction ID and other patches available!
May 14, 2009 By 9 Comments
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.
Comment: Global Transaction ID and other patches available!
May 14, 2009 By 9 Comments
uxio, As far as I understand global_transaction_id does not work with row-level replication.
Comment: Global Transaction ID and other patches available!
May 14, 2009 By 9 Comments
global-transaction-id will support row based replication?
Comment: Recovery beyond data restore
August 3, 2008 By 11 Comments
Thanks Mark, Good to know. Indeed the global transaction IDs are better, though I guess it was harder to implement. Are you going to support only master-slave replication or master-master and tree replication w filtering and writing to intermediate nodes as well ?
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… large. Transaction id is current transaction identifier – it is incremented for each transaction. Purge done for trx’s n:o is number of transaction to… a bit conflicting information. This is by design as requiring global lock to provide consitent information would cause significant overhead. Note…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… transactions that are replicating over and over in a Multi Master Replication relationship. This happens because those transactions belong to a server-id… change the server-id interactively, this is an action you should never perform on a slave. “SET GLOBAL server_id =…” You promote a…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
… script that just inserted data into a TC table ( an id, and a timestamp) and did a kill -9 on theÂ…, or starting,commiting, or aborting a transaction. Note a transaction in TC is actually a global transaction and locks all write operations ( used… Cabinet. In a sense it is implemented as a global sync, not a record sync. i.e. all changesÂ…
Comment: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…/global-transaction-identifiers-feature.html The preview cab be downloaded today from labs.mysql.com in the mysql-5.6-labs-global-trans-ids…
