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
Create MySQL Instance Replica using Clone Command MySQL 8 has recently released clone plugin which makes cloning process very easy and handy to perform. In this blog we will see How to install and perform clone of mysql instance. I will clone complete mysql instance server_id 3 into server_id 4, Please note in server_id 4
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
Mysql Logical Backup using mysqlsh – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlsh – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mysqlsh. Now in this post, we will see How to perform an import of
Mysql Logical Backup using myloader – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mydumper – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mydumper. Now in this post, we will see
