… with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… now it’s common to see much higher numbers from NDB and 5.5.x clusters with not just simple queries… cloud service that can be used to host rapidly scalable NDB clusters (commence with inserting a shameless plug that users can…
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…
Comment: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
April 16, 2013 By 10 Comments
Yves , Geat work ……. Got it to work on raspberry PI Model B Together with SQL loadbalaning witz ldirectord managed by crm/corosync 2 Pi´s for ndb/sql 2 Pi´s for the LB 2 Pi´s for the WEB regards
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
…. I know at least 2 sets of scripts to manage NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. If…=”param-mgmd-pidnile” name=”pidfile” value=”/var/run/heartbeat/fake_ndb_mgmd.pid”/>
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
… scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and I decided to take a…-exceptions -I/usr/include -I../../../../include -I../../../../storage/ndb/include -I../../../../storage/ndb/include/ndbapi ndbapi_scan.cpp ndbapi_scan.cpp: In…(20) NOT NULL,” ” PRIMARY KEY USING HASH (REG_NO))” ” ENGINE=NDB“)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… of the degraded node group (NoOfReplicas=2) will cause the NDB cluster to shutdown. This can be solved by using host… present and identical, at least for the NDB part, in all hosts. Next the NDB configuration must use the hostname like: [NDBD...=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB_MGMD] Id=2 Hostname=mgmn2 [NDBD] Id…
Post: NDB tutorial at Percona Live London + Free TIcket Give Away
September 23, 2011 By Leave a Comment
…) and I will be giving a full day tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items covered: – Achitecture – Installation – Loading data – Administration (common procedures) – Node recovery – NDB for sharding – Replication – Online scaling – Other access methods If…
Comment: Finding your MySQL High-Availability solution – The questions
October 18, 2009 By 36 Comments
… actual size of the data set after being imported into NDB. Of particular note is that blob/text columns (for several reason) are less than ideal for NDB. 2.3 DDL in NDB has had historic issues with replicating correctly via… (external replication…) but this introduces even more complexity. 2.5 NDB has bugs like all software and the userbase is not…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These technologies are by far, not a one size… Fair Heartbeat/SAN (depends on SAN) Excellent Heartbeat/DRBD Good NDB Cluster Excellent 5. For what level of growth are you…/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills and strong Sysadmin skills…
