编辑mysql配置文件
vi /etc/mysql/mysql.cof.d/mysql.cnf
#服务器唯一标识
server-id = 1
#启动MySQL二进制日志
log_bin = /var/log/mysql/mysql-bin.log指定记录二进制日志的数据库
binlog_do_db = marhal指定不记录二进制日志的数据库
binlog_ignore_db = mysql
service mysql restart
登录主服务器创建从服务器用到的账户和权限
mysql -uroot -p>
mysql> create user backup_user;
Query OK, 0 rows affected (0.03 sec)mysql>grant replication slave on *.* to 'backup_user' @'192.168.0.%' identified by '123456';
#backup_user 指的是主服务器备份用户名 123456 指的是主服务器备份用户名密码,192.168.0.%通配符,表示0-255的ip都可访问主服务器,正式环境配置指定从服务器ip
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql>show master status;
192.168.0.126从数据库配置
server-id = 2
log_bin = /var/log/mysql/mysql-bin.log
binlog_format = mixed
binlog_do_db = marhal
binlog_ignore_db = mysql
service mysql restart
mysql -uroot -p
>change master to
master_host='192.168.0.118',
master_port=3306,
master_user='backup_user',
master_password='123456',
master_log_file='mysql-bin.000004', //上面截图的File字段值
master_log_pos=154; //上面截图的Position字段值
>start slave;
#查看slave信息
>show slave status\G;
配置成功;
测试;
主服务器执行mysql命令
查看从数据库的表状态
结束。