… 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: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 9 Comments
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…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… and Yves Trudeau will run NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology which is rapidly… MySQL Cluster installations. Yves is perhaps one of the most experienced MySQL Cluster consultants in United States, having worked with MySQL Cluster deployments…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 11, 2012 By 30 Comments
… additional knowledge for DBA is required to run XtraDB Cluster than NDB Cluster. MySQL NDB Cluster is totally different engine than MySQL Replication ○ Requires changes… diagnostic and troubleshooting ○ expensive to deploy and maintain Percona XtraDB Cluster has: ○ Minimal entry barrier for one who switches from MySQL…
Comment: Is VoltDB really as scalable as they claim?
March 2, 2011 By 3 Comments
… node (data nodes) MySQL Cluster. That’s the largest NDB Cluster I’ve heard of so far. Even if NDB allows some hundred nodes in the configuration file, I was still impressed to hear about such a large cluster actually… as a reminder: Just like with VoltDB, MySQL Cluster nodes form a single cluster, a single consistent database with transparent sharding. All…
