MySQL Forums
Forum List  »  NDB clusters

Re: High CPU Usage with ndbd in VMWare
Posted by: Chris Telinde
Date: January 25, 2016 09:34AM

I believe the issue here was related to a couple of things, including a configuration issue with FreeRadius which was causing it to hit the database in much higher succession than it should have been, and limited resources allocated to the ndb storage engine for the read/write volume the cluster was experiencing. A resolution would have been to increase the data nodes in the cluster from 2 to 4 to scale out the heavy reads/writes being done on the database.

The addition of data nodes online was attempted while in production, but during the redistribution of data to the new data nodes using "ALTER ONLINE TABLE ... REORGANIZE PARTITION", this made the performance even worse on the database and we had to revert back to our old DB solution for the time being.

Options: ReplyQuote


Subject
Views
Written By
Posted
2493
December 30, 2015 10:28AM
Re: High CPU Usage with ndbd in VMWare
938
January 25, 2016 09:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.