MySQL Database Service & NDB Cluster

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

In this blog, we will discuss, how to setup MySQL NDB Cluster replication through backup and restore method . This is bit tricky but interesting. The scenario here is, say user have a standalone cluster up and running, later there is a need to have a replication setup with an another empty cluster without shutting down the existing running cluster i.e. zero downtime. Then this backup and restore method will come in handy. Let’s create two MySQL NDB Cluster 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 Replication schema diagram: CLUSTER 'A'                                          CLUSTER 'B' MySQL (test01)        ...

In this blog, we will discuss about bidirectional replication between two NDB clusters. With this topology, user can do transaction simultaneously from both the clusters on the same database objects. Let’s create two MySQL NDB Cluster with the following environment, Here, both will be termed as ‘source’ cluster as well as ‘replica’ cluster as we will do replication from both the sides. MySQL NDB Cluster version (Latest GA version) 1 Management node 4 Data nodes 2 MySQLDs Configuration slots for up to 4 additional API nodes Replication schema diagram:                     |----------- S1 ---------->>----------S3--------------|                          |                                              ...