mysql 主从复制

+主库

create database test1;

vi /etc/my.cnf #追加如下
server-id=1
log-bin=master-bin
binlog-format=row
binlog-do-db=test1

mysql -uroot -p123456

# 设置从库登录账号
set global validate_password_policy=0;
set global validate_password_length=1;
grant replication slave on *.* to 'root'@'%' identified by '123456';
flush privileges;

sevice mysqld restart

show master status\G #查看主库binlog状态

+从库

create database test1; # 主从复制不会创建数据库，需要手动创建数据库

vi /etc/my.cnf #追加如下
server_id=2
log_bin=master-bin
binlog-format=row

service mysqld restart;

mysql -uroot -p123456

#设置主库连接参数
change master to
master_host='192.168.0.105',
master_user='root',
master_password='123456',
master_port=3306,
master_log_file='master-bin.000001',
master_log_pos=154;

start slave;

show slave status\G

# linux 安装文件

1 rpm
rpm -qa |grep vsftpd # 查看文件信息
 rpm -ivh xx.rpm

2 tar
 tar -zxvf ****.tar.gz

3 .bin
chmod +x ******.bin # 授予权限
./******.bin