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