MySQL Forums :: NDB clusters :: NDB Cluster how much Harddisk space


Advanced Search

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
NDB Cluster how much Harddisk space 171 Frank Liebelt 02/03/2017 07:37AM
Re: NDB Cluster how much Harddisk space 69 Mikael Ronström 02/09/2017 02:37PM


Sorry, only registered users may post in this forum.

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.