简介 ：
采用脚本直接配置，请事先安装好MYSQL，附件中脚本包里有4个文件分别为mysqlsa.py(主程序）、mysqldb(数据库模块）、master（参数）、slave（参数）
程序文件下载地址：http://down.51cto.com/data/229410
Sever info:
Master:192.168.1.3
Slave:192.168.1.4
脚本使用教程：
Master:192.168.1.3
1、解压TAR包
[root@SQL1 down]# tar -zxf mysql-master-slave.tar.gz
2、进入目录设置权限
[root@SQL1 down]# cd mysql-master-slave
[root@SQL1 mysql-master-slave]# chmod 777 mysqlsa.py
3、打开master文件，设置你需要同步的库
[root@SQL1 mysql-master-slave]# vi master
log-bin=/var/log/mysql/mysql-bin
binlog-ignore-db=mysql,test
binlog-do-db=wgdb
log-bin=/var/log/mysql/updatelog
4、运行脚本程序（这里注意如果你的MYSQL默认安装路经不是‘/usr/local/mysql'在此脚本程序的10~11行把成“export LD_LIBRARY_PATH=your path '你自己路经地址，否则有可能程序里面MySQLdb模块报错
[root@SQL1 mysql-master-slave]# ./mysqlsa.py
----------------------------------------------------------------------
1)Installation MySQL Master
2)Installation MySQL Slave
Q)Quit Installation
----------------------------------------------------------------------
Plase,Enter your option:
1：配置安装MYSQL主库
2：配置安装MYSQL从库
Q：退出
5、我们选择“1”配置MYSQL主库
[root@SQL1 mysql-master-slave]# ./mysqlsa.py
----------------------------------------------------------------------
1)Installation MySQL Master
2)Installation MySQL Slave
Q)Quit Installation
----------------------------------------------------------------------
Plase,Enter your option:1
6、提示要求输入SLAVE服务器IP，这步是创建访问帐号用的，我们输入SLAVE的IP：192.168.1.4，注意：千万别输错，不然SLAVE访问就会出错
Plase,Enter your option:1
Please,input your slave server ip:192.168.1.4
7、OK,执行完成以后程序不会给你任何提示！我们直接安Q退出，查看/etc/my.cnf的57行下面内容是否成功写入
54 # required unique id between 1 and 2^32 - 1
55 # defaults to 1 if master-host is not set
56 # but will not function as a master if omitted
57 server-id = 1
58 log-bin=/var/log/mysql/mysql-bin
59 binlog-ignore-db=mysql,test
60 binlog-do-db=wgdb
61 log-bin=/var/log/mysql/updatelog
8、重启MYSQL
[root@SQL1 down]# service mysqld restart
Slave:192.168.1.4
1、解压TAR包
[root@SQL2 down]# tar -zxf mysql-master-slave.tar.gz
2、进入目录设置权限
[root@SQL2 down]# cd mysql-master-slave
[root@SQL2 mysql-master-slave]#
3、打开slave文件，设置你需要同步的库和master的IP
master-host = 192.168.1.3
master-user = replication
master-password = *.asDICf.1KD
master-port = 3306
master-connect-retry = 60
replicate-ignore-db = mysql,test
replicate-do-db = wgdb
relay-log=/var/log/mysql/slave-relay-bin
slave-skip-errors=all
4、运行脚本程序（这里注意如果你的MYSQL默认安装路经不是‘/usr/local/mysql'在此脚本程序的10~11行把成“export LD_LIBRARY_PATH=your path '你自己路经地址，否则有可能程序里面MySQLdb模块报错
[root@SQL2 mysql-master-slave]# ./mysqlsa.py
----------------------------------------------------------------------
1)Installation MySQL Master
2)Installation MySQL Slave
Q)Quit Installation
----------------------------------------------------------------------