MySQ安装使用，主次设置

安装依赖

yum search libaio  # 检索相关信息
yum install libaio # 安装依赖包

mysql是否安装

yum list installed | grep mysql

mysql卸载

yum -y remove mysql-libs.x86_64

mysql yum下载

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

修改启动项目

yum-config-manager --disable mysql56-community
yum-config-manager --enable mysql57-community-dmr

安装 MySQL

yum install mysql-community-server

查看mysql安装位置

whereis mysql

启动mysql

systemctl start  mysqld

关闭mysql

systemctl stop  mysqld

查看密码

grep 'temporary password' /var/log/mysqld.log

mysql修改密码远程连接

SET PASSWORD = PASSWORD('#20as3SElksds0ew98'); 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '#20as3SElksds0ew98' WITH GRANT OPTION;

主从复制

打开端口

firewall-cmd –add-port=3306/tcp 
firewall-cmd –permanent –add-port=3306/tcp
firewall-cmd –reload success

修改主服务器—-vim /etc/my.cnf最后面加上 unb系统/etc/mysql/mysql.conf.d/mysqld.cnf

log-bin=mysql-bin #slave会基于此log-bin来做replication 
server-id=1 #master的标示 
innodb_flush_log_at_trx_commit=1 
sync_binlog=1

修改从服务器—-vim /etc/my.cnf最后面加上

server-id=2 #slave的标示 
server-id=3 #slave的标示
有几个就在几个上面配置

主服务器增加账号

主服务查看信息

show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000002 |      673 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+

配置从服务器

stop slave; 
change master to master_user='root',master_password='#20as3SElksds0ew98',master_host='192.168.232.140',master_port=3306,master_log_file='mysql-bin.000002',master_log_pos=673
start slave;

查看主从复制

SHOW SLAVE STATUS\G