Mysql Master Slave Replication
MySQL Master Slave Replication MASTER SIDE ============================== ========================= == # vim /etc/my.cnf (add below ) ============================== ========================= == server-id = 1 log_bin = /var/lib/ mysql / mysql -bin.log binlog_do_db = DB_NAME (if you need all databases then no need this parameter) ============================== ============================== ======================= # service mysqld restart ============================== ============================== ======================= LOGIN IN MASTER DATABASE ============================== ============================== ======================= # mysql -u root -pXXXXXXX mysql > create database DB_NAME; mysql > use mysql ; mysql > GRANT REPLICATION SLAVE ON *.* TO 'UserName'@'%' IDENTIFIED BY 'Password'; mysql > FLUSH PRIVILEGES; ============================== ===============