… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific…-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY… is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue… statements http://mysqlopt.blogspot.co.uk/2013/06/restrictions-on-replication-with-gtids.html
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … the time of this writing, from async stream, MyISAM is not being replicated at all which I reported on this bug. This… fixed, and you still have MyISAM tables you wish to keep running under PXC, wsrep_replicate_myisam allows you to do so. However…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL… keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM to Innodb through plain ALTER TABLE statements… of specific issues might be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication… all the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL replication. The main…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like… use replication because it is async and your load loads CPU more than IO subsystem it may sense configure multiple MySQL servers… remember MySQL simply was not repairing corrupted tables in this configuration even if myisam_repair is set. Space Saving ? As I mentioned replication…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…: pt-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables… server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables. Since MyISAM tables can…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… before, they are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff. Some of this… seen people being confused about the fact you can copy MyISAM tables on file basics but not Innodb ? By the fact you can have transactions with MyISAM tables but they would not actually roll back ? Replication which can get broken by Server…
