Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?
share|improve this question
add comment

1 Answer

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 !!!

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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