…volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because … lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC…the similarities end. Q: What kind of replication issues can you get with storage solutions like GlusterFS?…
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…_buffer_pool_populate option. That solves most of the swapping issues but… I recently ended up in a situation where, after… swapping episodically for a few minutes, enough to cause serious issues to the pacemaker setup the server is one of the…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…fit but reality is a bit trickier. The main issue we faced is that IPs are dynamic in … Just change the IP in the cluster config and perform an rolling restart! no? In fact this will …lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB_MGMD] Id=2 Hostname=mgmn2 [NDBD…
Comment: Choosing innodb_buffer_pool_size
March 30, 2010 By 39 Comments
… info, perhaps you could offer some advise for an innodb performance issue i am having. I’ve just inherited a WebRT Ticketing… i’ve worked mainly with smaller clustered DB’s with NDB so an InnoDB db of this size is new territory… than the memory on the system. Any thoughts to increase performance/decrease disk I/O or redesign idea ? Regards Ronald
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…reduce the downtime. I agree that for good performance, data needs to be in memory but… … clients having serious corruption issues with replication. I must admit that those issues were nearly all …them would have covered by Heartbeat/DRBD or NDB Cluster. @Todd: Replication are two different ways …
Comment: Finding your MySQL High-Availability solution – The questions
October 18, 2009 By 36 Comments
… reason) are less than ideal for NDB. 2.3 DDL in NDB has had historic issues with replicating correctly via internal Replication. 2.4 I think it worth pointing out NDB is… hit every API node. 2.10 Join performance can be less than ideal with NDB. This is just off the top of…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
…Strange…??) 2. We are using mysql ndb cluster version Distrib 5.1.56-ndb-7.1.19 (to maintain … setup but I think that this might impact performance..) 5. (Did not mention this before as this … from the same machine.. (Do not understand the issue.. This was another reason to switch to InnoDb) Lastly…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… MySQL conference. Galera is not really 100% fully synchronous (like NDB) as one would expect from how they describe it. It… one node (the master) – Client issues commit – Transaction is replicated to other nodes (the slaves) – Slaves perform some verification to guarantee that…, but result in high number of rollbacks with Galera. The issue here is that if I have 2 transactions that try…
Comment: Filtered MySQL Replication
November 9, 2007 By 8 Comments
… to understand. I think you mean “alleviates” the issues. My personal opinion is row-level replication will … really surprised when they see how it really performs for their specific scenarios! I think people may …of how people think “I’ll just set up NDB cluster, a cluster will solve all my problems”…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… with all the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers… and alerting system to quickly react to replication issue and you need a rather small write load… failing over to a slave means no degraded performance associated with caches warm up. Finally, it is…
