Posts

Showing posts from May, 2021

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

MySQL NDB Cluster Replication Topologies (Part – III)

Image
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--------------|                          |                                                                                |      M ----------|                                                                               |-------- R (Cluster 1) |                                                                               |      (Cluster 2)                          |------

MySQL NDB Cluster Replication Topologies (Part – II)

Image
In the previous blog, we were able to setup a MySQL NDB Cluster replication between one source and one replica cluster. In this blog, we will discuss about replication between one source and three replica clusters. Note: With MySQL version (8.0.21), we have started changing the term “master” to “source”, the term “slave” to “replica”. So in this blog we will refer these terms ‘source’ and ‘replica’ wherever applicable. The main advantage of this type of topology is good for giving ‘local’ reads in geographically distant areas as well as increased redundancy in case of issues. Let’s create four MySQL NDB Cluster with the following environment, from which one will be termed as ‘source’ cluster while the rest will be ‘replica’ clusters. MySQL NDB Cluster version (Latest GA version) 1 Management node 4 Data nodes 1 MySQLD Configuration slots for up to 4 additional API nodes Replication schema diagram: M y SQL ( test01 ) - ---->------->------->------> MySQL ( test05 ) ( CLUST