June 19, 2013

Comment: Finding your MySQL High-Availability solution – The questions

NDB cluster. @Gerry: I have seen cluster that have been up for more than a years and I maintain it is 5 9s. NDB… are giving that you have implemented sharding. You have probably tune your schema in a way to reduce cross-node interactions…, most of them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways of replicating data, from…

Post: Return of the Query Cache, win a Percona Live ticket

…’t care beyond that. Here’s my favorite query cache tuning guide. The second important change is really minor. It didn… time; don’t miss your opportunity to learn subjects from NDB Cluster to InnoDB Architecture and Performance Optimization. These detailed presentations will…

Post: MongoDB Approach to Availability

… to MySQL Server but MySQL Cluster, especially in newer versions which implement “sharding”. Same as commit to NDB Storage engine does not… behavior somewhat similar – you’re not expected to run MySQL Cluster without replication, MongoDB is practically the same. Second – if we… fails driver fails over to different master. Things are again tuned to deal with Asynchronous Replication. Consistency is maintained but at…

Post: The Doom of Multiple Storage Engines

… nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB makes it more complicated when it… with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95…