简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

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

WBOY
Release： 2016-06-07 17:40:17
Original
760 people have browsed it

继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



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

，香港空间
Related labels：
mysql5.6同步复制 mysql5.6 replicat
source：php.cn
Previous article： OCP知识点讲解 之 队列、资源与锁 Next article： Oracle日期显示问题以及trunc方法的使用
Statement of this Website
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
Latest Articles by Author
Latest Issues
My WPF application won't start on another PC, but the application without MySql does, what could be the problem? This is my first time using a database. I've created an application using XAMPP via mySqll...
From 2024-04-03 11:16:00
0
1
396
Connecting the Node.Js Express backend to the React frontend I want to merge two projects: one for React frontend and another for NodeJsExpress backend...
From 2024-04-01 10:46:08
0
1
311
Force WordPress to generate post slug from title only on specific custom post types I'm using the code below to force WordPress to generate the post slug from the post title,...
From 2024-03-31 18:58:26
0
1
275
My app doesn't apply copied CSS to index.css in React So I'm following a tutorial on Youtube about reactJS, the youtuber told me to import the C...
From 2024-03-30 09:02:20
0
1
389
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！