两台linux虚拟主机mysql
Linux版本CentOS7.四、MySQL 5.7linux
ip:192.168.3.100、192.168.3.108sql
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmbash
[root@BrianZhu /]# yum -y install mysql57-community-release-el7-10.noarch.rpm
服务器
[root@BrianZhu /]# yum -y install mysql-community-server
socket
[root@BrianZhu /]# systemctl start mysqld.service
ide
[root@BrianZhu /]# systemctl status mysqld.service
测试
此时MySQL已经开始正常运行,不过要想进入MySQL还得先找出此时root用户的密码,经过以下命令能够在日志文件中找出密码:spa
[root@BrianZhu /]# grep "password" /var/log/mysqld.log
日志
这时候咱们要把密码规则改一下,执行下面sql就能够了:
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
1、配置master
master配置:
cat /etc/my.cnf
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-bin=mysql-bin
server_id=226
bind-address=0.0.0.0
受权帐户
GRANT REPLICATION SLAVE ON *.* to 'tom'@'%' identified by '123456';
第二步:
查看192.168.3.100MySQL服务器二进制文件名与位置
mysql>SHOW MASTER STATUS;
二 、salve 配置
cat /etc/my.cnf
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-bin=mysql-bin
server_id=220
在salve 执行以下语句:
change master to master_host='192.168.3.100',master_user='tom',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=1904;
mysql>START SLAVE; #开启复制
mysql>SHOW SLAVE STATUS\G #查看主从复制是否配置成功
当看到Slave_IO_Running: YES、Slave_SQL_Running: YES才代表状态正常
3、测试主从复制是否成功
192.168.3.100主MySQL操做(master):
mysql>create database aa;
mysql>use aa;
mysql>create table tab1(id int auto_increment,name varchar(10),primary key(id));
mysql>show databases;
mysql>show tables;
192.168.3.104从MySQL操做:
mysql>show databases;
mysql>show tables;
上面两个结果图可得知,两主机达到了数据同步。主从复制的配置就是如此的简单