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

Tags:

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 […]

Tags:

in DB Tuning - 27 Aug, 2013
by Zafar Malik - no comments

in Useful Linux Scripts - 27 Aug, 2013
by Zafar Malik - no comments

in Query Optimization - 27 Aug, 2013
by Zafar Malik - no comments

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 […]