… the MySQL world, except maybe MyISAM 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 going… 3 node cluster in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql_install…
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… far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this… 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
… MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…/storage/ndb/ndbapi-examples/ndbapi_scan$ LD_LIBRARY_PATH=/usr/local/mysql-cluster-gpl-7.0.8a/lib/mysql ./ndbapi_scan /usr/local/mysql-cluster-gpl… USING HASH (REG_NO))” ” ENGINE=NDB“)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already has example table: GARAGE. ” << “Dropping…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…. Next 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: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
… MySQL is the MySQL server manipulating FRM files. The only MySQL storage engine I’m aware of having fully crash safe DDL is MySQL Cluster (NDB…
Post: Percona welcomes Stewart Smith
May 16, 2011 By 8 Comments
… the team. Stewart does not need an extended introduction for MySQL Community, but just in case: Stewart has a long history with both the MySQL and Drizzle code bases. He’s been one of the… Rackspace), he maintains HailDB and previously worked for MySQL (and then Sun) on MySQL Cluster (NDB). Stewart joins Percona to lead our development team…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
…/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1 ] do /bin/sleep 60 done root@testvirtbox:~# cat /usr/local/bin/fake_ndb_cluster_start #!/bin/bash #Give some time to the nodes to connect /bin/sleep 15 /usr/local/mysql/bin/ndb_mgm…/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: 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 gaining popularity for building high performance and highly available systems with MySQL. Initially designed for Telecom Applications MySQL Cluster…
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…
