gtid

BackgroundIn the MySQL master and standby environment, the main standby synchronization process is as follows, the main library update generates Binlog, the standby IO line pulls take the main library binlog generate relay log. The standby SQL

query whether the system has MySQL installed , and if so, remove it. Rpm-qa | grep MySQLto remove the installed MySQL:Yum Remove mysql-libs-5.1.66-2.el6_3.x86_64Install the required plugins:Yum Install Perl perl-devel Libaio libaio-develinstallation

For most applications, MySQL is the most critical data storage center. Therefore, we have to deal with the problem of how to make MySQL provide the HA service. When the master For most applications, MySQL is the most critical data storage center.

MySQL5.6 adds a method that does not need to set the log_bin file and log location. Before that, we need to view the master machine information (showmasterstatus), and then set MySQL5.6 adds a method that does not need to set the log_bin file and

MySQL replication (2): binary log, binary log structure and content, mysql binary Generally, only statements that are about to be executed are written into binary logs. However, in some special cases, the additional information of the statement or

MySQL introduced the concept of semi-synchronous in version 5.5, where it also popularized some basic knowledge.One: God horse is semi-synchronous, synchronous, asynchronous.1:mysql copy process is slave to master pull the log back, save to relay

During the business stress testing of a project, the following problems were encountered:The Zabbix monitor message displays the following error:2016.09.28 19:16:11Trigger:mysql error log desc in lines_2Values:mysql error_log:2016-09-28 19:16:10 4723

Why does MySQL have to master replication (read/write separation)?In layman's terms, the performance of a business system degrades if both the read and write of the database are operated on the same database server.In order to improve the

First, preface: Why does MySQL want to master from copy (read-write separation)? in layman's terms, the performance of a business system degrades if both the read and write of the database are operated on the same database server. in order to

* MHA the entire fault (offline) switching process-----------------------------------------------------------------------------------------------------Detects the status of the main library and confirms whether it crashes.-Confirm service crash,

Reprinted from:Http://www.chinaxing.org/articles/Database/2015/10/23/2015-10-22-mysql-5.7.htmlPercona a test, in the case of MySQL5.7 innodb_page_size adjustment to 4k, can be improved than 16k performance of more than 70%;

Mysql Classic ReplicationFirst, the composition of traditional replication:1. master server:The user writes the data.Generate Binlog.2. Slave Server:Receive the Binlog from master.Apply these binlog to reproduce the user action of master.Second, the

Introduction: Myflash is a tool for rolling back DML operations developed and maintained by the company's technical engineering department. The tool completes the rollback operation by parsing the V4 version of Binlog. Relative to the existing

CENTOS7 Installation MySQL5.7 Environment Introduction 1. Introduction of installation package versionThere are three ways to install MySQL: RPM installation, binary package installation, source package installation. This article installs MySQL in

MySQL5.6 master-slave copy (read and write separation) tutorial1. There are two ways to start a master-slave copy of MySQL5.6:Log based (binlog);Based on the Gtid (global transaction identifier).Note: The Gtid method does not support temporary

MySQL5.6 master-slave copy (read-write separation) tutorial 1, MySQL5.6 start the master-slave replication has two ways: Based on log (binlog);Based on the Gtid (global transaction identifier). Note that the Gtid method does not support temporary

First, preface: Why does MySQL want to master from copy (read-write separation)?In layman's terms, the performance of a business system degrades if both the read and write of the database are operated on the same database server.In order to improve

MySQL version: 5.6.36Xtraback Edition: Version 2.4.61. Modify the master node MySQL configuration file and restart MySQLCat/usr/local/mysql/my.cnf[Mysqld]DataDir =/var/lib/mysqlSocket

mysql5.7 new features multi-source replication is practical, easy to summarize the sub-library environment, centralized backup and data statistical analysis.My lab Environment 3 machines, MySQL version: 5.7.1610.10.203.102 from Library10.10.203.93

Parallel replication, mainly to solve the sql_thread in high concurrency environment, there are performance bottlenecks. The idea of mysql5.7 parallel replication is straightforward, and a group commits a transaction that can be replayed in parallel