MySQL Forums
Forum List  »  NDB clusters

Re: NDB Cluster how much Harddisk space
Posted by: Mikael Ronström
Date: February 09, 2017 02:37PM

Data nodes store most data in memory. Then we need the 1 TB SSD to store
something like this:
2 checkpoints of the data in DataMemory
REDO logs (usually around the size of DataMemory or a bit more)

In most cases one also stores a backup of the data.

In addition one could use Disk data columns and then this also will be stored
on the 1 TB SSD.

Finally the data nodes store metadata about the tables and log information
which is normally not so large compared to the rest of the data stored
on disk.

The MySQL Servers only stores FRM files and some local logs and metadata
information on disk. MySQL Servers also use a fair amount of memory for
various temporary buffers of all sorts.

So not that much disk needed on MySQL Servers. Obviously if you use
MySQL Replication in the MySQL Server also then you need to store
the binlogs and relay logs on disk.

Options: ReplyQuote


Subject
Views
Written By
Posted
373
February 03, 2017 07:37AM
Re: NDB Cluster how much Harddisk space
206
February 09, 2017 02:37PM


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.