… 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… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
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…, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What…
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… those, NDB Cluster, a hash based sharding framework, is the easy and cheap solution. Maybe I have lucky, but the only InnoDB corruption…, most of them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways of replicating data, from…
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… about loss of data, you are most likely using the InnoDB storage engine, since MyISAM is not transactional and do not…) Excellent Heartbeat/DRBD Good NDB Cluster Excellent 5. For what level of growth are you planning? Since NDB Cluster is an integrated sharding environment…
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… value operations N is 1 or 2 ms. For InnoDB (ie XtraDB Cluster) you will not see as stable performance as this… 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
… been a high availability solution of choice for MySQL with Innodb storage engine in case no transaction loss can be tolerated… 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
…, which may be not full Percona XtraDB Cluster ● It is based on widely used XtraDB/InnoDB engine. ● It is almost drop-in… 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…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… –> 1 index (ObjectClass, Timestamp), PK –> (ObjectClass, ObjectInstance, Timestamp) – Unique. Using InnoDb engine as the client is very finiky about his records… columns (Strange…??) 2. We are using mysql ndb cluster version Distrib 5.1.56-ndb-7.1.19 (to maintain consistency across the…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
Gerry, NDB cluster can do rolling restarts, so the cluster can stay available during the restart. http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-rolling-restart.html You can also use disk based tables… cache to minimize IO. In simple terms this is what InnoDB does with the buffer pool and MyISAM with its key…
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
… feedback is welcome! As for changes for Build13 it contains InnoDB Data Dictionary restriction patch, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/). Speaking of deb binaries I tried to keep… case. 2. I removed NDB cluster engine from builds, we have not tested combination of our patches with NDB so I really do…
