… volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual…re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll…like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… 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… is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk/2013/06/restrictions-on-replication-with-gtids.html
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other … the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… 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… performance is somewhat dependent on the slowest node – this overhead can easily become visible on the whole cluster and your async replication…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM and Innodb in the same terms, in fact they are quite different for Replication. As you probably know MyISAM uses… update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication. But…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… Master (and dropping not replicated tables) to set up replication becomes more tricky because you need to perform mapping between master positions which… same with MyISAM tables, because MyISAM can’t be disabled and so if you create tables as MYISAM or ALTER them to MyISAM you… to see how well MySQL 5.1 row based replication works and performs and I will be testing filtered scenarios as well…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… build the functionality you need and get the performance you need. Because I’ve built two such … cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-… data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason is – replication. In MySQL before 5.1 replication is statement based which means…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… with MyISAM. QA has to be performed as part of the move. Performance Innodb has a lot to offer in terms of performance – Performance benefits… costs between storage engines may not be well balanced or replication of mixed table types which is quite complicated. I prefer… would not switch table to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…important than performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance …proper master to fall back to. Also be worried about replication with different storage engines. Then performance improvements are worth the risk.
