Posts

Security Configuration For MySQL NDB Cluster Replication

Image
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

Scale Out Your MySQL NDB Cluster In Few Easy Steps ...

Image
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

MySQL NDB Cluster Replication Topologies (Part – IV)

Image
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)                         MySQL (test05)      (source)                                                   (replica) test01: MySQL server host na