…. 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: 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
… 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…
Comment: Disaster: MySQL 5.5 Flushing
September 19, 2011 By 27 Comments
… could be solved, I tried to think how NDB behaves. Let’s compare: NDB has database in memory. InnoDB has buffer pool in memory. NDB writes REDO log. InnoDB does too. NDB has a background thread that periodically dumps…, transactions get stalled until they can be completed. (This means NDB is hard real-time database and InnoDB is not. InnoDB…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… the application might a complex and costy task. For those, NDB Cluster, a hash based sharding framework, is the easy and…, most of them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways of replicating data… the schema is not partitioned correctly. I have worked with NDB having 24 ndbd nodes handling insanely huge loads. 2.8…
Comment: How to replace a NDB node on EC2
February 22, 2012 By 10 Comments
… restart. but, in phase 100 not progress next phase. [ndbd(NDB)] 2 node(s) id=4 @10.0.0.1 (mysql-5.1.56 ndb-7.1.13, Nodegroup: 0, Master) id=5 @10.0.0.3 (mysql-5.1.56 ndb-7.1.913 starting, Nodegroup: 0) ndb_mgm> all status; Node 4: started (mysql… 5: starting (Last completed phase 100) (mysql-5.1.56 ndb-7.1.13) Do you know any solution to the…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 12, 2012 By 30 Comments
… clusters. One point that didn’t come up is that NDB is a real-time database. You can be guaranteed that… be pretty good in practice. Also, it is said that NDB is totally different and therefore very difficult to understand, and… changes if migrating from a standard MySQL server to an NDB Cluster. This is all true. Otoh in your case if…
