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