建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
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 #進(jìn)行一些安全配置，根據(jù)選項(xiàng)選擇2. 主從同步配置
添加my.cnf配置參數(shù)
#在主庫(kù)my.cnf [mysqld]中加入
log-bin = mysql-bin
server-id = 1
#從庫(kù)
log-bin = mysql-bin
server-id = 2在主庫(kù)添加復(fù)制賬號(hào)
grant replication slave on *.* to rep@'192.168.0.%' identified by '123456';同步主庫(kù)到從庫(kù)
flush table with read lock; #鎖表
mysql> show master status; #鎖表記錄的位置點(diǎn)
+------------------+----------+--------------+------------------+
| 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可能不對(duì)
接著show master status; 如果發(fā)現(xiàn)位置一樣，則鎖表生效，如果不一樣說(shuō)明鎖表失敗，從庫(kù)也會(huì)文件不同步
unlock tables; 解鎖表mysqldump -uroot -p123456 -A -B -F --master-data=2 -x --events|gzip >/opt/all.sql.gz
show master status; 查看記錄的位置點(diǎn)還原從庫(kù)
gzip -d bak_xxx.sql.gz #解壓備份的文件
mysql -uroot -p123456 配置從庫(kù)
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; #開(kāi)始同步在從庫(kù)使用
show slave status\G 出現(xiàn)如下信息成功
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0 #這個(gè)是從庫(kù)落后主庫(kù)的秒數(shù) 不是很準(zhǔn)3. 半同步復(fù)制配置
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
#主庫(kù)加載插件
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
mysql> set global rpl_semi_sync_master_enabled=on;
#從庫(kù)加載插件
mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
mysql> set global rpl_semi_sync_slave_enabled=on;3.2 加入my.cnf參數(shù)
#主庫(kù)[mysqld]加入下面參數(shù)
rpl_semi_sync_master_enabled = 1
#從庫(kù)[mysqld]加入下面參數(shù)
rpl_semi_sync_slave_enabled = 1 
查看參數(shù)
創(chuàng)新互聯(lián)專注為客戶提供全方位的互聯(lián)網(wǎng)綜合服務(wù)，包含不限于網(wǎng)站設(shè)計(jì)制作、成都網(wǎng)站制作、凌河網(wǎng)絡(luò)推廣、小程序定制開(kāi)發(fā)、凌河網(wǎng)絡(luò)營(yíng)銷、凌河企業(yè)策劃、凌河品牌公關(guān)、搜索引擎seo、人物專訪、企業(yè)宣傳片、企業(yè)代運(yùn)營(yíng)等，從售前售中售后，我們都將竭誠(chéng)為您服務(wù)，您的肯定，是我們最大的嘉獎(jiǎng)；創(chuàng)新互聯(lián)為所有大學(xué)生創(chuàng)業(yè)者提供凌河建站搭建服務(wù)，24小時(shí)服務(wù)熱線：13518219792，官方網(wǎng)址：www.cdcxhl.com
show variables like '%Rpl%';3.3 驗(yàn)證
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 測(cè)試
網(wǎng)頁(yè)題目：mysql5.6安裝及主從半同步配置
分享路徑：http://fisionsoft.com.cn/article/gdssei.html
