Home  >  Article  >  Database  >  MySQL5.6同步复制新特性详解

MySQL5.6同步复制新特性详解

WBOY
WBOYOriginal
2016-06-07 17:40:17761browse

继5.5半同步复制后,5.6又对其进行了优化与改进,其中有两个地方较为重要:1、对运维人员来说应该是一件大喜的事情,在主从切换后,在传统的方式里,你需要找到b

log-bin = mysql-bin

binlog_format = row

log_slave_updates

gtid-mode = ON

disable-gtid-unsafe-statements = ON

注:MySQL5.6.10以后,香港服务器,disable-gtid-unsafe-statements参数 变更为enforce-gtid-consistency = ON



本文出自 “贺春旸的技术专栏” 博客,服务器空间,请务必保留此出处

,香港空间
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn