mysql 搭建一主一从
1.前期准备
找两台机子,安装mysql
2.搭建一主一从
2.1 修改node01的/etc/my.cnf文件
[mysqld]
#mysql服务唯一id,不同的mysql服务必须拥有全局唯一的id
server-id=1
#启动二进制日期
log-bin=mysql-bin
#设置不要复制的数据库
binlog-ignore-db=mysql
binlog-ignore-db=information-schema
#设置需要复制的数据库
binlog-do-db=msb
#设置binlog的格式
binlog_format=statement
2.2 修改node02的/etc/my.cnf文件
[mysqld]
#服务器唯一id
server-id=2
#启动中继日志
relay-log=mysql-relay
2.3 重启node01和node02的mysql
service mysql restart
2.4 在node01上创建账号,并授权slave
grant replication slave on *.* to 'root'@'%' identified by '123456';
2.5 node01上查看状态
show master status;
2.6 node02上配置需要复制的主机
CHANGE MASTER TO MASTER_HOST='192.168.85.111',MASTER_USER='root',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=154;
start slave;
show slave status\G;
检查slave_IO_Running和Slave_SQL_Running是否为Yes
3.验证
3.1 node01创建schema和table
create database msb;
use msb;
create table test(id int,name varchar(20));
insert into test values(1,"aa");
3.2 node02上验证
show databases;
use msb;
show tables;
select * from test;