NDB cluster

NDB cluster (also known as NDB) is an in-memory storage engine offering high availability and data persistence features.

The NDB cluster storage engine can be configured with a range of failover and load-balancing options, but it is easiest to start with the storage engine at the cluster level. NDB Cluster uses the NDB storage engine that contains a complete set of data, which is dependent only on other datasets available within the cluster.

The Cluster portion of the NDB Cluster is configured independently of the MySQL servers. In an NDB Cluster, each part of the cluster is considered to be a node.

The following diagram will help you understand which store engine you need to use for your requirement:

Each store engine has its own advantage and usability:

• Search Engine: NDBCluster
• Transactions data: InnoDB
• Session data: MyISAM or NDBCluster
• Localized calculations: Memory
• Dictionary: MyISAM

Now you have a better idea about various storage engines along with different use cases, which will help you choose based on your needs. Let's now have a look at Data manipulation statements used to fetch, save, and update data.