…replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication…work because Slave thread seems to have problems picking up long_query_time when …MySQL but this would make replication to be delayed few more hours because of the time Innodb…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… a 3 hour tutorial focusing on indexing within MyISAM and Innodb with a side of Partitioning. I’d expect folks interested… at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary… eliminate temporary tables. This problem may not exist for row-based replication in MySQL 5.1 and …temporary table with ENGINE=InnoDB, and the InnoDB transaction ID does not change in SHOW INNODB STATUS. The…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in… binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems in some environments with 4+ cores…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication… Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B,… replication system with optimistic locking. So, when is this really a problem? …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
….5 years ago: State of the art: Galera – synchronous replication for InnoDB. It was about the 0.7 release, which was more… MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High Availability solution for systems based on InnoDB… with master” pain-in-the-neck problems. Combining all above, now we can setup distributed replication systems with masters in different data…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking …. It is especially problem if you’re running replication Slave as slave …MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… state of MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication state… http://bugs.mysql.com/bug.php?id=34058 bug report. Basically we want to store the state of replication in InnoDB transactional log…
