… 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…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
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: 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…
Comment: Finding your MySQL High-Availability solution – The questions
October 20, 2009 By 36 Comments
… acceptable. Even NDB cluster now support replication (row based only) and I have even done some experiments with NDB to InnoDB replication and, it…
Comment: Filtered MySQL Replication
November 9, 2007 By 7 Comments
… than Innodb Cluster is. Funny enough back when 4.1 was in beta and 5.0 was in early development (before NDB Cluster) I…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… of architecture implementation details of how it would compare to Innodb storage engine – old timer in this space. Does it add… will be an extra pressure to do the fixes. While Innodb was only transactional storage engine there surely was less pressure… talk but doing it in simple efficient and innovative way. NDB cluster is yet another example I’d put in here. I…
