… 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
… 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: 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…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
…). So, 4 app servers. — 2 Databases (Separate mysqld instances) a) Clustered NDB, on the two nodes mentioned above b) InnoDb/MyISAM on… with both the DBs, storing records @ 800 rps. deletion from NDB database has to happen very frequently. Deletion from MyISAM/InnoDb…
Comment: Percona Server now both SQL and NOSQL
December 15, 2010 By 19 Comments
… distribute it, nice! Correcting one thing in the post: MySQL Cluster (NDB) was the first MySQL solution that allowed non-SQL access… in this way. (In fact, HandlerSocket was inspired by MySQL Cluster.)
Comment: Finding your MySQL High-Availability solution – The questions
January 7, 2010 By 36 Comments
Hi, I just want to indicate that you can lose data with MySQL Cluster (NDB Cluster) ! See description of the TimeBetweenGlobalCheckpoints parameter…
