best design approach for NDB

Follow

rooz gar

• December 05, 2021 09:30

i have 4 bare metal to setup the clusting for mysql

each one have 512 gig ram and 3 tb ssd hard disk

for the NDB i need 2 management server some data node and some mysql server

i can create vms on bare metal but i dont know how much ram is required for monitoring , management data node and mysql server

for example if i have to put one data node and one mysql server on each bare metal what is the best dividing of 512 gig of ram and 3 tb of hard?!

0

• Official comment

  

  Ashraf Sharif

  • December 21, 2021 02:36

  Hi,

  A simple rule of thumb is to allocate the majority of the resources to the data nodes, and the number of data nodes must have always come in pairs (2, 4, 6, 8 data nodes). In a fraction of 10, I can give a simple estimation to allocate 5/10 hardware resources to data nodes, 3/10 to MySQL nodes and 2/10 to management nodes. 

  The best practice for resource dimensioning commonly requires us to understand your application requirements, budget, anticipated workloads, capacity planning, assessment, etc. We do offer consulting jobs and if you are interested, feel free to reach out to our sales team at sales[at]severalnines.com.

  Regards,
  Ashraf

  Comment actions Permalink
• 

  rooz gar

  • February 23, 2022 07:16

  Thank you for the complete answer

  now i installed ndb and every thing is working good

  is there a best practice to cpu/ram/hard assignment to nodes?

  i think mysql nodes need more ram/cpu but data nodes need more hard disk space

  do you have any advice to how to divid the resources?

  0

  Comment actions Permalink

Please sign in to leave a comment.