… in addition to the textual explanation. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A… back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL is up and running. That… with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically… know) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the… responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What was I missing…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the number of possible HA solutions. From…) Excellent Heartbeat/DRBD Good NDB Cluster Excellent 5. For what level of growth are you planning? Since NDB Cluster is an integrated sharding environment…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… come up at about the same time, it is not too bad but what if one the critical node takes much longer… a running cluster controlling nothing. The trick with NDB Cluster is that Heartbeat is required to start the resources but not to stop… cibadmin –replace –xml-file local.xml Once NDB is started, you can even stop heartbeat, it is no longer required. P.S.: As…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…include -I../../../../include -I../../../../storage/ndb/include -I../../../../storage/ndb/include/ndbapi ndbapi_scan.cpp …has example table: GARAGE. Dropping it… ^C What‘s that? Wow… look at the … * ******************/ drop_table(mysql); create_table(mysql); } } That one is sweet, no need to be a…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… the NDB cluster to shutdown. This can be solved by using host names instead of IPs in the config.ini file. What needs to be done is to define, in /etc/hosts, on entry per…] Id=4 Hostname=data2 [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] This is, of course, a very minimalistic configuration but I am sure…
Comment: MySQL Partitioning - can save you or kill you
June 29, 2012 By 45 Comments
…) supports partitions, but does not support partition pruning. Eh? Is that a NDB deficiency? Pruning “always” works with InnoDB or MyISAM. (I… app is CPU-intensive. Do not allow swapping; that will kill MySQL performance. “50 users” — a useless metric without knowing what they…, or a single user might bring it to its knees. Is NDB involved or not? You have mentioned MyISAM and InnoDB; they…
Comment: Finding your MySQL High-Availability solution – The questions
October 27, 2009 By 36 Comments
Dba Zed, NDB cluster does not really make sense for Data warehouse applications. There was a discussion on what is good for cluster… Hanlon’s post in the thread sums up rather well what scales well with NDB.
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… Alexey is his practical approach and ability to explain why something is a good solution rather than stating the fact this is what is being done in organization. A lot of approaches Alexey is going… Trudeau will run NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology which is rapidly gaining…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… NDB makes it more complicated when it should be and still because it has to serve so many use cases it is… different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95% of applications single storage engine would… which drops everything but Innodb Storage engine (it could be NDB, PBXT etc, it does not matter). We could save a…
