…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what I… response back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL is up and running. That… might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… 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
… on! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the number of possible HA solutions…. MySQL DBA + strong Sysadmin skills Heartbeat/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…What‘s that? Wow… look at the create_table code… void create_table(MYSQL &mysql) { while (mysql_query(&mysql…NDB“)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… instead of IPs in the config.ini file. What needs to be done is to define, in /etc/hosts, on entry per… the NDB configuration must use the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB_MGMD] Id=2 Hostname=mgmn2…
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… Trudeau will run NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology which is rapidly gaining popularity…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed great to provide users… different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95% of applications single storage engine would… what we could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it could be NDB…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…will cover what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to…with all the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL replication. …
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… dozen of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB cluster… solution nearly 10 years ago. There is quite a lot of confusion surrounding HA solutions for MySQL, I will try to present… first define what is meant by high-availability. The most general definition would be that a high-availability setup is special computer…
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…@testvirtbox:~# cat /usr/local/bin/fake_ndb_mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1 ] do /bin/sleep 60 done root@testvirtbox:~# cat /usr/local/bin/fake_ndb_cluster…
