MySQL Database Service & NDB Cluster

In this blog, we will discuss about how to setup MySQL NDB Cluster replication in a more secure way with the help of binary log and relay log encryption and a secure connection. These measures protect binary log dat in transit and at rest. Let’s create two MySQL NDB Clusters with the following environment, Here, one will be termed as ‘source’ cluster and the other one will be termed as ‘replica’ cluster. MySQL NDB Cluster version (Latest GA version) 1 Management node 4 Data nodes 1 MySQLDs Configuration slots for up to 4 additional API nodes Step 1: Start both of the Clusters Let’s start both the source cluster and replica cluster but do not start the MySQLD servers from both the clusters as we want to modify their configuration first. Start the second cluster (replica): Now both the clusters are up and running. Step 2: Configure for secure connections MySQL supports encrypted connections between clients and the MySQL server using the TLS (Transport Layer Security) protocol. TLS is als...

In this blog, we will discuss about how to scale out MySQL NDB Cluster in few easy steps. The use cases could be, when user business applications demand massive expansion and the existing cluster may not able to handle the request in that case a cluster scaling is needed. This is an online procedure i.e. zero cluster downtime so that user’s business won’t affect while this scaling process is going on. In the below demo, we will see, how to scale from a 4 nodes cluster to 8 nodes cluster while transactions are going on. Let’s create a MySQL NDB Cluster with the following environment. MySQL NDB Cluster version (Latest GA version) 1 Management node 4 Data nodes 1 MySQLDs Configuration slots for up to 4 additional API nodes Step 1: Let's start the Cluster Let’s start a 4 nodes cluster. Step 2: Let’s create database, table and some operations on it Let’s create a database ‘test1’, table ‘t1’ and insert rows into table ‘t1’ continuously. I am using a tool to insert rows, can also be done...