… files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are… give it a shot. I set up a 3 node cluster in AWS, got the volume mounted, and went to try…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…’s common to see much higher numbers from NDB and 5.5.x clusters with not just simple queries or simple transactions… to show just how far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a… cloud service that can be used to host rapidly scalable NDB clusters (commence with inserting a shameless plug that users can then…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… the logic required to manage NDB Cluster startup. Okay it might seems weird to control a cluster by cluster but if you think about…/fake_ndb_mgmd.pid” primitive ndbcluster ocf:heartbeat:anything \ params binfile=”/usr/local/bin/fake_ndb_cluster_start” pidfile=”/var/run/heartbeat/fake_ndb_cluster…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked…-laptop:/opt/mysql-cluster-gpl-7.0.8/storage/ndb/ndbapi-examples/ndbapi_scan$ LD_LIBRARY_PATH=/usr/local/mysql-cluster-gpl-7… (REG_NO))” ” ENGINE=NDB“)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already has example table…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
NDB cluster is a very interesting solution in term of high availability … the cluster is already in degraded mode, restarting the surviving node of the degraded node group (NoOfReplicas=2) will cause the NDB cluster…] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB_MGMD] Id=2 Hostname=mgmn2…
Post: NDB tutorial at Percona Live London + Free TIcket Give Away
September 23, 2011 By Leave a Comment
… tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items… – Administration (common procedures) – Node recovery – NDB for sharding – Replication – Online scaling – Other access methods If NDB cluster is a technology that interests you…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… 99.9% NDB Cluster 99.999% From the table, if your requirements are for 99.99%, you are restricted to NDB Cluster while if…) Excellent Heartbeat/DRBD Good NDB Cluster Excellent 5. For what level of growth are you planning? Since NDB Cluster is an integrated sharding environment…/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills and strong Sysadmin skills 7…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… NDB cluster. @Gerry: I have seen cluster that have been up for more than a years and I maintain it is 5 9s. NDB… the application might a complex and costy task. For those, NDB Cluster, a hash based sharding framework, is the easy and cheap…, most of them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways of replicating data, from…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 12, 2012 By 30 Comments
Pretty good discussion here on NDB vs XtraDB clusters. One point that didn’t come up is that NDB is a real-time… N is 1 or 2 ms. For InnoDB (ie XtraDB Cluster) you will not see as stable performance as this, although… server to an NDB Cluster. This is all true. Otoh in your case if you are already running on MySQL Cluster, the same…
