前提:
主数据库:172.16.9.11:3307
备数据库:172.16.9.12:3307
集群IP: 172.16.9.13
一:实现主从复制
1.修改主数据库my.cnf配置文件(mysqld配置切记房在client上面)
[mysqld]
basedir = /usr/local/mysql3307
datadir = /usr/local/mysql3307/data
socket = /usr/local/mysql3307/tmp/mysql.sock
port = 3307general_log_file=/usr/local/mysql3307/mysql-log/mysql.log
general_log=1
slow_query_log=on
slow-query-log-file=/usr/local/mysql3307/mysql-log/mysql-slow.log
long_query_time=1
lower_case_table_names=1server-id=1
log-bin=/usr/local/mysql3307/logbin/mysql_master
log-slave-updates=on
expire_logs_days = 10replicate-ignore-db=information_schema
replicate-ignore-db=mysql
replicate-ignore-db=performance_schema
replicate-ignore-db=sysreplicate_wild_ignore_table=information_schema.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=performance_schema.%
replicate_wild_ignore_table=sys.%[client]
socket = /usr/local/mysql3307/tmp/mysql.sock
default-character-set=utf8[mysqld_safe]
log-error=/usr/local/mysql3307/mysql-log/error.log
pid-file=/usr/local/mysql3307/mysql.pid
2.修改从数据库my.cnf配置文件(mysqld配置切记放在client上面)
[mysqld]
basedir = /usr/local/mysql3307
datadir = /usr/local/mysql3307/data
socket = /usr/local/mysql3307/tmp/mysql.sock
port = 3307general_log_file=/usr/local/mysql3307/mysql-log/mysql.log
general_log=1
slow_query_log=on
slow-query-log-file=/usr/local/mysql3307/mysql-log/mysql-slow.log
long_query_time=1
lower_case_table_names=1server-id=1
log-bin=/usr/local/mysql3307/logbin/mysql_master
log-slave-updates=on
expire_logs_days = 10replicate-ignore-db=information_schema
replicate-ignore-db=mysql
replicate-ignore-db=performance_schema
replicate-ignore-db=sysreplicate_wild_ignore_table=information_schema.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=performance_schema.%
replicate_wild_ignore_table=sys.%[client]
socket = /usr/lo