… we can consider it truly production-ready. I suppose I should state an obvious disclaimer here in that …like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL to determine …say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL …
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…, you need to interleave the allocation of memory for the MySQL process…of the swapping issues but… I recently ended up in a… a lot (~150MB/s) but doing very little physical writes. …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…), the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times…%, you are restricted to NDB Cluster while if it is only 99% you have more options. I recall that the level of…, Specific NDB knowledge, strom MySQL skills and strong Sysadmin skills 7. How deep are your pocket? The last aspect that needs to be…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… Pacemaker that I need are resource location rsc_location and resource ordering rsc_order. Let’s start by the beginning. My NDB cluster…/local/bin/fake_ndb_mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1 ] do /bin/sleep 60 done root@testvirtbox:~# cat /usr/local/bin/fake_ndb_cluster_start…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…NDB cluster to shutdown. This can be solved by using host names instead of IPs in the config.ini file. What needs…mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB… but I…NDB. Consider, for example, that the IP of the new host is 10.55.55.55. The first thing to do…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB cluster and I‘ll probably be doing the same at Percona. I… hours. The more complex solutions have automatic recovery and do not need human intervention. Once again, although they are some…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…doing alter tables. For alter tables, only replication can reduce the downtime. I agree that for good performance, data needs…for GIS I would use PostGIS, I completely agree. 2.5 I have done many NDB engagements and… I… here, do you use SSL between your application servers and your MySQL servers? 2….
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…need to be repaired if it crashes. Still I find behavior somewhat similar – you’re not expected to run MySQL…master rather than multiple. This is because doing master with asynchronous replication requires conflict … look at how failover happens – same with NDB (native API) it is handled on driver …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… in Innodb and distributed nature of NDB makes it more complicated when …of complications and performance overhead. MySQL has to do several fsync() calls per …much more complicated to test. And I believe multi-storage engine use …as MySQL allows you using multiple storage engines in the query you need …
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
…line up of Tutorials on Percona Live, London. I hand picked number of them after seeing …how to do a lot with less hardware and time/staff needed. Florian Haas with his talk MySQL High…will run NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology…
