facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
Replication
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 […]