Install Mysql Replcation

groupadd mysql
useradd -g mysql mysql
cd /usr/local
gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
cd mysql
scripts/mysql_install_db --user=mysql
chown -R root  .
chown -R mysql data
chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

./bin/mysqladmin -u root password 'XXXXXXX"
./bin/mysqladmin -u root -h vipms01.104.com.tw password 'XXXXXX'



MASTER:
./bin/mysqladmin create dbmail -u root -p
mysql -u root -p
GRANT ALL ON dbmail.* to dbmail@localhost identified by 'XXXXXXXX';
GRANT ALL ON dbmail.* to dbmail@10.0.2.73 identified by 'XXXXXXXX';
mysql -u dbmail dbmail -p < sql/mysql/create_tables_innoDB.mysql

mysql -u root -p

GRANG ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'XXXXXXXX'
GRANT FILE ON *.* TO dbmail@172.16.31.11 IDENTIFIED BY 'XXXXXXXX'
GRANT FILE,SELECT,REPLICATION SLAVE ON  *.* TO dbmail@172.16.31.11 IDENTIFIED BY 'XXXXXXXX';
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;


UNLOCK TABLES;

mysqldump -u root --password=1qaz2wsx -a dbmail > /tmp/vipmsdb.sql
mysqladmin -u root --password=1qaz2wsx flush-hosts

mysql -u root dbmail -p < dump_file.sql


Master# vi /etc/my.cnf


在[mysqld]添加或修改以下的


[mysqld]
log-bin                              
server-id=1
sql-bin-update-same
binlog-do-db= reptest


Master# /var/eyou/mysql/bin/mysqladmin –u root –p shutdown
Master# /var/eyou/mysql/bin/safe_mysqld --user=mysql &


#chang slave my.cnf
2、Slave

修改my.cnf，增加如下几行：

server-id = 2

master-host = 172.16.31.111

master-user = dbmail

master-password = XXXXXXXX

master-port = 3306

set-variable=replicate-ignore-db=mysql

set-variable=replicate-do-db=dbmail

restart services

    $mysqld_safe &
mysql>change master to master_Host='172.16.31.111',master_user='dbmail',master_password='XXXXXXXX',master_log_file='mysql-bin.000074',master_log_pos=98;

    mysql>start slave;