facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
Replication
in Replication - 17 Mar, 2016
by Zafar Malik - no comments

Here we will setup Mysql Fabric with auto failover at DB level with 5 servers (1 Fabric Manager or Arbiter + 3 SQL Nodes + 1 Application server): So Below are required server details: 192.168.18.1 : fabric manager : mysql 5.6.29 + fabric + connector required. 192.168.18.2 : Mysql Master : mysql 5.6.29 192.168.18.3 : Mysql slave1 […]

in Replication Trouble Shooting - 20 Sep, 2013
by Zafar Malik - no comments

Problem: Our Replication was going behind on a particular time even there was not much (un-usual) updation or load on server. To know that exact issue when I tried to know slave status at that particular time and executed “show slave status” command on server. I could not get the results and it took too […]

in Fresh Replication - 11 Sep, 2013
by Zafar Malik - no comments

Six Easy Steps for Replication Setup for mysql version lower than 5.5: Special: Assuming Master and Slave both are fresh servers and Mysql Version lower than 5.5: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT […]

in Fresh Replication - 11 Sep, 2013
by Zafar Malik - no comments

Easy Steps for Single Database Replication Setup on running stand alone server with Mysql Version lower than 5.5: Special: Assuming Mysql Version is lower than 5.5: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* […]

in Fresh Replication - 11 Sep, 2013
by Zafar Malik - no comments

Easy Steps for Single Database Replication Setup on running stand alone server: Special: Assuming Mysql Version is 5.5 or higher: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’slave_ip’ IDENTIFIED BY ‘rep_pass’; […]

in Fresh Replication - 29 Aug, 2013
by Zafar Malik - no comments

Easy Steps for Replication Setup on running stand alone server  with mysql version 5.5 or higher: Special: Assuming Mysql Version is 5.5 or higher: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO […]

in Fresh Replication - 26 Aug, 2013
by Zafar Malik - 3 comments

Six Easy Steps for Replication Setup  for mysql version 5.5 or higher: Special: Assuming Master and Slave both are fresh servers and Mysql Version is 5.5 or higher: Step1: create users- rights on slave : GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘rep_user’@’localhost’ IDENTIFIED BY ‘rep_pass’; rightgs on master : GRANT REPLICATION SLAVE, REPLICATION […]