… future of the PHP replication plugin….What?…Think of a global transaction ID as a unique identifier for a change set in a… transaction…CREATE TABLE trx .trx id BIGINT UNSIGNED NOT NULL. ENGINE memory ..INSERT INTO trx VALUES 0 ..When ever you commit a transaction UPDATE the trx id field ..UPDATE trx SET trx id trx id 1.From ….Dear MySQL database…
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… replication: it should be possible to just replay the lost transactions, not having to do a full copy. Does this mean… log? Since they have global transaction id’s, a disconnected slave could just ask to get all transactions after a certain id. Of course, xtrabackup…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… cluster all nodes have their individual LSNs. Instead Cluster uses Global Transaction ID (GTID), in form 50176f05-69b5-11e2-0800-930817fe924a:8549230. So… is updated for each transaction. So even the system crashes, we can access information about the last commited transaction. In XtraDB Cluster…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
… feature to keep the InnoDB transaction log and slave replication state in sync after a crash (transactional replication). But the most interesting… redo support for hierarchical replication and transparent slave failover with global transaction IDs.
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… gaps. So slaves only acknowledged that they have received the transaction (and even then a majority of slaves is enough?). Since the Galera cluster imposes a consistent ordering among transactions, there’s no need for everyone to certify anything, it… so far this makes sense.) @Vadim: If you store the Global transaction ID into an InnoDB table, there you have a relation to…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 22 Comments
… the writesets. The reason for this is keeping track of global transaction ID and caching the writesets for potential IST. This overhead can… either unloading Galera wsrep provider or setting wsrep_on=0 globally. But that of course will effectively turn it into a…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… Galera node can operate as MySQL master as well) * Galera global transaction ID could be mapped with binlog positions and/or LSNs. It… contains authentication information, which is visible to the world through global variables. This is a problem in mysqldump based configurations, and…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… knowing that mysql does not have a way match the transactions as ‘global transactions id‘.I agree that matching logs is very tedious but…
Comment: Storing MySQL Binary logs on NFS Volume
August 3, 2010 By 19 Comments
…, then failing a slave to a new master without losing transactions would be trivial. Today you get to play the game… the offset from the old master. Or you can use global transaction IDs from the Google patch. Replication is also much more expensive…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 4, 2013 By 13 Comments
…-wide commit, I meant at the point at which a global transaction ID is issued, then certification takes place, when I said local…
