2

I want to setup a MySQL cluster.

  • The amount of data is more than double the amount of RAM.
  • I have 3 Data Nodes each with 8GB RAM.

QUESTIONS

  • What is a good rule for the DataMemory and DiskPageBufferMemory parameters?
  • Are 3GB DiskPageBufferMemory and 2GB DataMemory good values?
|improve this question
2

DISCLAIMER : Not SCMCDBA Certified

If you plan to hold data in memory, you need to

  • increase RAM on all data nodes to 16GB
  • increase the DataMemory to 6GB
  • increase the number of SQL nodes to 3 (Makes SQLNodes to DataNodes 1:1)

If you cannot make these changes, then you should offload data to local storage

Here is one of the best answers from Frazer Clement : MySQL Cluster RAM requirement

He states in his answer

When configuring DataMemory and IndexMemory, it is best to limit yourself to somewhat less than the physical memory in each system. Some physical memory should be reserved for the OS and other processes.

There are three MySQL Cluster Gurus in this forum

Checks out their answers !!!

|improve this answer
  • What relation has amount of data and number of SQL nodes? – Mindaugas Riauba Dec 27 '13 at 12:07
  • If SQL nodes and Data nodes are separate, then there is no relation. I would still raise the amount of RAM and assign bigger buffers is you do not plan to store any data to disk on the Data nodes. – RolandoMySQLDBA Dec 27 '13 at 14:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.