0 Comments

How to Setup MySQL Master-Master Replication (Circular Replication) 5 (1)

How to Setup MySQL Master-Master Replication (Circular Replication) Master-Master Replication (Circular Replication) also known as ring topology in MySQL, this setup requires two or more MySQL servers which act as a master. All masters receive writes and generate binlogs. Below points should be considered while doing the master-master setup. You need to set an auto-increment […]

 531 Total Views,  3 Views Today

0 Comments

MySQL Multi-Source Replication – GTID Based Sources 0 (0)

MySQL Multi-Source Replication – GTID Based Sources In this blog post, we will see How to setup MySQL Multi-Source Replication – GTID Based Sources. For this demonstration, we will be using the below configuration. We have already set up 2 mysql instance in test-machine01 server running on port 3306 (Server_ID : 1) & 3307 (Server_ID […]

 373 Total Views,  1 Views Today

0 Comments

MySql Semisynchronous Replication 0 (0)

MySql Semisynchronous Replication In the previous blog, we saw How to create MySql GTID-based Master Slave Replication – Single DB, Click here to read more. We will use the same configuration to convert it from asynchronous to semisynchronous. MySQL replication by default is asynchronous. MySQL 8.0 supports an interface to semisynchronous replication that is implemented by plugins. Step 1. […]

 314 Total Views,  3 Views Today

0 Comments

MySQL Master Slave Switchover 0 (0)

MySQL Master Slave Switchover In the previous blog, we saw How to create MySql GTID-based Master Slave Replication – Single DB Click here to read more. We will use the same configuration to perform Switchover between Master & Slave. Current Configuration. Host name IP Role Server ID Installation Link test-machine01 192.168.114.170 Master 1 Click Here test-machine012 […]

 599 Total Views,  2 Views Today

0 Comments

MySql GTID-Based Master Slave Replication – Single Database 0 (0)

MySql GTID-Based Master Slave Replication – Single Database In previous blog we saw How to create MySql File-based Master Slave Replication – All Database Click here to read more. GTID Replication:  In this post, we will see How to create MySql GTID-based Master Slave Replication – Single DB. The newer method based on global transaction […]

 309 Total Views,  3 Views Today

0 Comments

Drop MySql Replication Slave Configuration 0 (0)

Drop MySql Replication Slave Configuration In a previous blog, we had created File Based Master Slave Replication Click here to read more. In this post, we will remove the same master slave configuration. Below are detailed steps: Login to mysql slave instance and use command show slave status \G to get the current configuration. Run […]

 348 Total Views,  5 Views Today

0 Comments

MySql File-based Master Slave Replication – All Database 0 (0)

MySql File-based Master Slave Replication – All Database Replication enables data from one MySQL database server to be copied to one or more MySQL database servers. Replication is asynchronous by default, replicas do not need to be connected permanently to receive updates from a source. Depending on the configuration, you can replicate all databases, selected […]

 730 Total Views,  2 Views Today