June 20, 2013

Comment: Finding your MySQL High-Availability solution – The questions

… 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

… 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)

… 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…

Comment: How to replace a NDB node on EC2

… had already a cluster setup and got this: ndb_mgm> show Cluster Configuration ——————— [ndbd(NDB)] 2 node(s) id=3 @10.20.2.2 (mysql-5.1.56 ndb-7.1.13, Nodegroup: 0, Master) id=4 @10.20.2.4 (mysql-5.1.56 ndb-7.1.13, Nodegroup: 0) after changing node id 4…

Comment: Looking at Redis

… curious – did you try to run any tests with NDB engine?.. Because NDB is way more mature and already integrated within MySQL… already reached 1.5M(!) TPS (yes, per second!) with NDB. And currently NDB team claims to be able to do much more…

Comment: MySQL Partitioning - can save you or kill you

…, but does not support partition pruning. Eh? Is that a NDB deficiency? Pruning “always” works with InnoDB or MyISAM. (I quote… a single user might bring it to its knees. Is NDB involved or not? You have mentioned MyISAM and InnoDB; they…

Comment: How to replace a NDB node on EC2

… IPs, do I need to open the firewall on the NDB communication port in a way that open it to the outside world. NDB is completely unsecured so that would stress me a bit…. I don’t really like to depend on DNS but NDB uses DNS only when connecting, so the spof is not…

Comment: Funniest bug ever

…’s exactly the type of scenario I’m thinking of. NDB can’t find the data anymore, but maybe something else… tools got started ;-) What if there’s a bug in NDB such that the disk data files get corrupt on every…. Disclaimer: I have not investigated the on-disk format of NDB at all.

Comment: SimCity outages, traffic control and Thread Pool for MySQL

… 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…

Comment: Debugging problems with row based replication

…. For your info * MySQL Master: MySQL Cluster 5.1.56-ndb-7.1.17-cluster-gpl-log * MySQL Master: binlog_format = MIXED * MySQL Slave: MySQL 5.1.56-ndb-7.1.17-cluster-gpl * MySQL Slave: SET GLOBAL SLAVE…