重庆分公司
重庆分公司，新征程启航
为企业提供网站建设、域名注册、服务器等服务
mysql5.6安装及主从半同步配置
1.安装MySQL5.6
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server -y
rpm -qa|grep mysql
mysql-community-libs-5.6.40-2.el7.x86_64
mysql-community-server-5.6.40-2.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-client-5.6.40-2.el7.x86_64
mysql-community-common-5.6.40-2.el7.x86_64
#到此安装成功systemctl start mysqld
systemctl enable mysqld
mysql_secure_installation #进行一些安全配置，根据选项选择2. 主从同步配置
添加my.cnf配置参数
#在主库my.cnf [mysqld]中加入
log-bin = mysql-bin
server-id = 1
#从库
log-bin = mysql-bin
server-id = 2在主库添加复制账号
grant replication slave on *.* to rep@'192.168.0.%' identified by '123456';同步主库到从库
flush table with read lock; #锁表
mysql> show master status; #锁表记录的位置点
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000002 | 253 | | |
+------------------+----------+--------------+------------------+
mysqldump -uroot -p123456 --events -A -B |gzip >/opt/bak_$(date +%F).sql.gz #比较土的办法加-F 切割binlog可能不对
接着show master status; 如果发现位置一样，则锁表生效，如果不一样说明锁表失败，从库也会文件不同步
unlock tables; 解锁表mysqldump -uroot -p123456 -A -B -F --master-data=2 -x --events|gzip >/opt/all.sql.gz
show master status; 查看记录的位置点还原从库
gzip -d bak_xxx.sql.gz #解压备份的文件
mysql -uroot -p123456 配置从库
mysql -uroot -p123456 -S /data/3307/mysql.sock<< EOF
CHANGE MASTER TO
MASTER_HOST='10.0.0.52',
MASTER_PORT=3306,
MASTER_USER='rep',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=253;
EOF
start slave; #开始同步在从库使用
show slave status\G 出现如下信息成功
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0 #这个是从库落后主库的秒数 不是很准3. 半同步复制配置
3.1 安装插件
#这是半同步所需的插件
ll -h /usr/lib64/mysql/plugin/semisync_*
-rwxr-xr-x. 1 root root 509K Feb 26 21:27 /usr/lib64/mysql/plugin/semisync_master.so
-rwxr-xr-x. 1 root root 273K Feb 26 21:27 /usr/lib64/mysql/plugin/semisync_slave.so
#主库加载插件
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
mysql> set global rpl_semi_sync_master_enabled=on;
#从库加载插件
mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
mysql> set global rpl_semi_sync_slave_enabled=on;3.2 加入my.cnf参数
#主库[mysqld]加入下面参数
rpl_semi_sync_master_enabled = 1
#从库[mysqld]加入下面参数
rpl_semi_sync_slave_enabled = 1 
查看参数
创新互联专注为客户提供全方位的互联网综合服务，包含不限于网站设计制作、成都网站制作、凌河网络推广、小程序定制开发、凌河网络营销、凌河企业策划、凌河品牌公关、搜索引擎seo、人物专访、企业宣传片、企业代运营等，从售前售中售后，我们都将竭诚为您服务，您的肯定，是我们最大的嘉奖；创新互联为所有大学生创业者提供凌河建站搭建服务，24小时服务热线：13518219792，官方网址：www.cdcxhl.com
show variables like '%Rpl%';3.3 验证
show global status like 'rpl_semi%';
+--------------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------------+-------+
| Rpl_semi_sync_master_clients | 1 |
| Rpl_semi_sync_master_net_avg_wait_time | 0 |
| Rpl_semi_sync_master_net_wait_time | 0 |
| Rpl_semi_sync_master_net_waits | 0 |
| Rpl_semi_sync_master_no_times | 0 |
| Rpl_semi_sync_master_no_tx | 0 |
| Rpl_semi_sync_master_status | ON |
| Rpl_semi_sync_master_timefunc_failures | 0 |
| Rpl_semi_sync_master_tx_avg_wait_time | 0 |
| Rpl_semi_sync_master_tx_wait_time | 0 |
| Rpl_semi_sync_master_tx_waits | 0 |
| Rpl_semi_sync_master_wait_pos_backtraverse | 0 |
| Rpl_semi_sync_master_wait_sessions | 0 |
| Rpl_semi_sync_master_yes_tx | 0 |
+--------------------------------------------+-------+
mysql> show global status like 'rpl_semi%';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| Rpl_semi_sync_slave_status | ON |
+----------------------------+-------+
4 测试
分享标题：mysql5.6安装及主从半同步配置
标题路径：http://cqcxhl.com/article/gdssei.html