linux centos6.4 mysql主从同步配置

装好mysql后 进行主从mysql 的/etc/my.cnf 配置

主的my.cnf

主my.cnf
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

datadir=/mysqldata/mysql
socket=/mysqldata/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_file_per_table=1
server-id=1
log-bin=mysql-bin


# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

从的my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id  = 2
relay-log = relay-bin
innodb_file_per_table = 1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

配置完后启动mysqld服务

service mysqld start

运行mysql： mysql -u root -p

主机：

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'repl';

show master status;

会出现 master_log_file  ， master_log_pos的地址

从机mysql 执行的命令

change master to
master_host='192.168.0.198(主机)',master_user='repl',master_password='repl',master_log_file='mysql-bin.000003',master_log_pos=321;

start slave

stop slave

show slave status \G

然后可以测试。。。。。

如果一直连接不上记得关闭防火墙操作

关闭防火墙

service iptables stop

禁止防火墙开机启动

chkconfig iptables off

当同步某条sql出错时在从机的mysql上命令上执行

set global sql_slave_skip_counter=1

跳过错误；