一 安装 mysql

1. 安装

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server

2. 初始化

mysqld --initialize

3. 启动

systemctl start mysqld
systemctl status mysqld

4. 验证安装

mysqladmin --version

5. 登录

默认情况下 MySQL 服务器的登录密码为空

mysql
mysql> SHOW DATABASES;

二 mysql 主从配置

Master

1. 更改配置文件

/etc/my.cnf /etc/mysql/my.cnf

[mysqld]
server-id = 101         #id
log-bin   = mysql-bin   #bin log日志文件名

2. 重启mysql

systemctl restart mysqld

3. 创建用于数据同步的用户账号

创建用户，ip是此用户所在主机ip
mysql >  create user ‘tom’@’10.24.2.99’ identified by ‘tompd’;  

赋予权限
mysql >  grant replication slave on *.* to ‘tom’@’10.24.2.99’; 

刷新权限     
mysql >  flush privileges;                                                           

4. 查看master状态，查看二进制文件名和位置

mysql >  show master status;

Slave

1. 更改配置文件

/etc/my.cnf /etc/mysql/my.cnf

[mysqld]
server-id = 102         #id

2. 重启mysql

systemctl restart mysqld

3. 配置主从同步

mysql >  change master to master_host=’10.24.2.100’,master_port=3306,master_user=‘tom’,
	 ->  master_password=‘tompd’,master_log_file=‘mysql-bin.000001’,master_log_pos=506;

4. 启动slave同步进程

mysql >  start slave;

5. 查看slave状态

mysql >  show slave status;