… for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL 5.6: Redefining Replication” by…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved…’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1… backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not creating…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything…with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_…
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… errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com… 3 InnoDB version 1.0.16-12.8 So that’s how you can quickly find out what’s in your replication…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… of specific issues might be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will… replicated setup or plan some downtime for upgrade. Q: Upgrading to MySQL 5.5 do we really need all tables changed to Innodb… new release. Also note the default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering slave and… can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if you…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication…_name=DPE binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 wsrep_sst_auth…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which would be… with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention … The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly….
