REPLICATION

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

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.

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

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

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