Re: High CPU Usage with ndbd in VMWare

[Chris Telinde]

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.