Database Solutions

Switchover in MySQL Replication(Master-Slave) Setup  Performing DR Switch is regular activity for DBA for DR Testing. In this blog , We will show/discuss about how to switchover MySQL Replication (Master-Slave) Setup. Below are the steps followed for the MySQL Replication Switchover: 1) Stop All application servers/application. 2) Check Slave and Master status on the Slave(mysqlslave01) and Master server(mysqmaste01):   Log in to Master server (mysqmaste01): mysql> Flush logs; mysql> SHOW MASTER Status\G *************************** 1. row ***************************              File: mysql-bin.000002          Position: 28624712      Binlog_Do_DB: mysqldb  Binlog_Ignore_DB: Executed_Gtid_Set: 61fa835b-2c75-11e6-987c-005056b7fda8:1-4104 1 row in set (0.00 sec) Log into Slave server (mysqlslave01): Make sure slave running without log-slave-upda...

Configuring MySQL Replication Setup(Master-Slave) Now a days HA(High Availability) and DR(Disaster Recovery) Solutions are mandatory and required for mission critical databases. In  MySQL  world , DR solution are provided using the Replication (Master-Slave), (Master-Master) and a solution for doing switchover and failover if required. In this blog, We will discuss about setting up new  Master-Slave setup. 1) Preparing Master Server (mysqlmaster01) : 1.a) Make changes in my.cnf file. cp -pr /etc/my.cnf /etc/my.cnf_DDMMYYYY Add below line to my.cnf vi /etc/my.cnf log-bin gtid_mode=ON enforce-gtid-consistency relay-log-recovery binlog_format=mixed server-id=1 binlog-do-db=mysqldb   1.b) Restart MYSQL server to make changes effective. service mysqld restart  1.c) Verify binary logs: SHOW MASTER LOGS; Show master Status; ls -lrt /var/log/*bin* 1.d) Create Replication user in Master Server:   mysql> CREATE USER 'repl'@'198.168.0.2' IDENTIFIED BY '**********...