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
Mysql Logical Backup using mysqlpump – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlpump – Export, Click here to read more. mysql utility is used to import mysqlpump dump files so import commands are the same like we used in mysqldump. In the previous blog, we
