Centos7 MySQL installation master-slave replication configuration

Installation Dependency

yum search libaio # Retrieving related information yum install libaio # Install Dependent Packages

Is mysql installed

yum list installed | grep mysql

mysql uninstall

yum -y remove mysql-libs.x86_64

mysql yum Download

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

Modify Startup Project

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

Install MySQL

yum install mysql-community-server

View mysql installation location

whereis mysql

mysql start

systemctl start mysqld

Close mysql

systemctl stop mysqld

View Password

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

mysql modify password remote connection

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

Master-slave replication

open port

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

Modify Master Server - vim/etc/My.cnfAdd at the end

log-bin=mysql-bin #slaveWill be based on thislog-binTo do replication server-id=1 #masterSign innodb_flush_log_at_trx_commit=1 sync_binlog=1

Modify slave server - vim/etc/My.cnfAdd at the end Flag for server-id=2 #slave Flag for server-id=3 #slave Several are configured on just a few

Primary Server Add Account

Main Service View Information

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

Configure Slave Server

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;