Home  >  Article  >  Database  >  mysql5.623 GTID主从复制+半同步复制安装与配置

mysql5.623 GTID主从复制+半同步复制安装与配置

WBOY
WBOYOriginal
2016-06-07 16:08:161289browse

一、GTID简介什么是GTIDGTID(GlobalTransactionID)是对于一个已提交事务的编号,并且是一个全局唯一的编号。GTID实际上是由UUID+TID组成的。其中UUID是一个MySQL

wKiom1U0meaS6SXLAAL6lQlz5gg529.jpg

wKiom1U0mfGgZfQJAADVgw5TEZI873.jpg

主库查看半同步复制

wKioL1U0nHeADXQuAAFQYIFbUSE789.jpg

从库查看半同步复制

wKiom1U0mynAmHcVAAD9TZ7rmwE168.jpg

wKioL1U0nJDwQ7lpAACZYJN_OPs582.jpg

上图说明半同步复制成功

 

 

本文出自 “飛鴻沓膤” 博客,请务必保留此出处

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