… (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… makes reads consistent and therefore makes the replication between servers consistent. If you execute SELECT * …START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout exceeded; …/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default …
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… other way your normally prepare a slave. Now change the “replication_info” manually in corosync to the new binlog and logpos… you’ll get an error when you try to edit it, so use the command that the mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v “||” Now start corosync…
Comment: Percona XtraDB Cluster Feature 1: High Availability
April 20, 2012 By 18 Comments
Also to mention, if mysql replication on the cluster node (the slave) had any problem (dup key or something like that), after fix the replication, this node will NOT distribute/receive transactions within the cluster. No errors until reboot.
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… about failover from intermediate slaves to master and knowing that mysql does not have a way match the transactions as ‘global… ignore the duplicate key errors for some time untill replication catches up.This should work fine in ‘row based replication‘ correct ? because even pointing to previous position and by ignoring duplicate key errors we are bringing the…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication… Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto-increment increment 4, offset 2 InnoDB… read_only Filters replicate_wild_ignore_table=foo%.mount% Binary logging ROW Slave status 0 seconds behind, running, no errors Slave mode…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. … applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured to alert …
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
… complete until all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit completes before the transaction is even… not what happens in semi-synchronous replication. And if there is an error in semi-synchronous replication, such as a crash at the…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:…:3306′,replication resumed in log ‘master-bin.003676′ at position 444298239 After setting up new slave Server I’m getting error log… would be nice to include possible reason for this error message which MySQL already does in many other cases. I’ve now…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… out-of-sync situation, as it regularly happens with regular MySQL replication if you imprudently write to the wrong server. This is… and master is the reason why this replication named “virtually synchronous replication“, not real “synchronous replication” The described behavior of COMMIT also has… you may experience. In InnoDB usually DEADLOCK and LOCK TIMEOUT errors happen in response on particular query, but not on COMMIT…
