MySQL半同步SLAVE是什么
这篇文章主要介绍“MySQL半同步SLAVE是什么”,在日常操作中,相信很多人在MySQL半同步SLAVE是什么问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”MySQL半同步SLAVE是什么”的疑惑有所帮助!接下来,请跟着小编一起来学习吧!
成都创新互联公司长期为成百上千客户提供的网站建设服务,团队从业经验10年,关注不同地域、不同群体,并针对不同对象提供差异化的产品和服务;打造开放共赢平台,与合作伙伴共同营造健康的互联网生态环境。为鄄城企业提供专业的成都网站设计、网站建设,鄄城网站改版等技术服务。拥有10多年丰富建站经验和众多成功案例,为您定制开发。
Mysql半同步SLAVE,类似于ORACLE安全模式的DATAGUARD(但不完全是);
为什么是半同步呢,因为MYSQL只保证“至少一个”SLAVE接收到日志后返回;
虽然可能不会有太多的人去用这个东西(因为对网络的要求和机器的稳定性很高);但MYSQL还是补全了这一块的功能缺失
A commit performed on the master side blocks before returning to the session
that performed the transaction until at least one slave acknowledges that it has received
and logged the events for the transaction.
Semisynchronous replication is implemented through an optional plugin component.
See Section 17.3.8, “Semisynchronous Replication”.
http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
The slave acknowledges receipt of a transaction's events only after the events have been written to its relay log and flushed to disk.
只有SLAVE接收到日志写入到RELAY-LOG,并刷新到磁盘才算同步成功;
If a timeout occurs without any slave having acknowledged the transaction, the master reverts to asynchronous replication
如果日志传输过程中发生超时现象;那么SLAVE将恢复到异步方式;
Semisynchronous replication must be enabled on both the master and slave sides. If semisynchronous replication is disabled on the master, or enabled on the master but on no slaves, the master uses asynchronous replication
半同步复制方式必须在MASTER和SLAVE同时打开;否则还是采用异步方式;
While the master is blocking (waiting for acknowledgment from a slave after having performed a commit), it does not return to the session that performed the transaction
在SLAVE接受到日志或超时之前,MASTER对SESSION的COMMIT请求不作返回响应;
The rolled-back transaction is logged even though it has no effect for transactional tables because the modifications to the nontransactional tables cannot be rolled back and must be sent to slaves.
滚回操作,即使对事务表没有影响,也同样会被记录到日志里,因为“修改”会非事务表是不可回滚的,所以必须也传输到SLAVE;
对于自动提交的语句; MASTER将被在每个语句结束后BLOCK住;
## 几个系统变量设置
rpl_semi_sync_master_enabled=1 # 打开MASTER支持semisynchronous replication
rpl_semi_sync_slave_enabled=1 # 打开Slave 支持semisynchronous replication
rpl_semi_sync_master_timeout # 等待SLAVE超时时间;1MS,默认10000MS
rpl_semi_sync_master_wait_no_slave # 在超时之前,如果SLAVE都DOWN了,是不是还继续等待直到超时;默认打开 ;
## 几个状态变量
Rpl_semi_sync_master_status # 查看MASTER是否支持semisynchronous replication
Rpl_semi_sync_slave_status # 查看SLAVE 是否支持semisynchronous replication
Rpl_semi_sync_master_clients # 查看后面跟着几个semisynchronous slaves
Rpl_semi_sync_master_yes_tx # 成功传输了多少个事务;
Rpl_semi_sync_master_no_tx # 失败传输了多少个事务;
到此,关于“MySQL半同步SLAVE是什么”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联网站,小编会继续努力为大家带来更多实用的文章!
当前标题:MySQL半同步SLAVE是什么
本文来源:http://pwwzsj.com/article/ijhgdh.html