gtid

After 5.5 semi-synchronous replication, 5.6 has optimized and improved it. Two of them are important: 1. It should be a big pleasure for O & M personnel, after the master-slave switchover, you need to find After 5.5 semi-synchronous replication, 5.6

New Features of MySQL 5.7 and new features of MySQL 1. IntroductionIn the MySQL circle, we can feel everyone's expectations and enthusiasm for MySQL 5.7. It seems that everyone can't wait to understand, learn, and use MySQL 5.7. So, we can't help

There are two main components in MHA, one is the Manager node component. Similar to a supervisor.The node nodes component is installed on the database node, one of which acts as master.MHA requires an automatic switchover of the master node in the

First, install the MySQL related package Mysql-5.7.17-1.el6.x86_64.rpm-bundle.tarYou only need to download the unpacked package:mysql-community-client-5.7.17-1.el6.x86_64.rpmmysql-community-common-5.7.17-1.el6.x86_64.rpmmysql-community-libs-

In enterprises, the high availability of databases has always been the top priority of enterprises, many small and medium-sized enterprises are using MySQL master-slave scheme, a master and many from, read and write separation, but single-master

PXC Introduction:The Galera product is a galera cluster way to improve the high availability clustering solution for MySQL. Galera cluster is a MySQL cluster with integrated Galera plugins. Galera replication is a MySQL data synchronization scheme

In enterprises, the high availability of databases has always been the top priority of enterprises, many small and medium-sized enterprises are using MySQL master-slave scheme, a master and many from, read and write separation, but single-master

A few days ago, the user wrote to help achieve such a framework: only two machines, the need to implement one of the crash after another can take over the service of this machine, and two machines in normal service, both machines can be used. The

Software:Host a ip:192.168.1.201Host B ip:192.168.1.202Operating system: Centos6.5-x86MySQL version: mysql-5.7.12-linux-glibc2.5-x86_64.tar.gzInstall dependency package: Yum Install libaio-devel glibc perl–yClose SELinux and

For children who use SQL or NoSQL, replication is a topic that can be avoided, and through replication, it is a great way to keep your data safe. After all, everyone knows, do not put eggs in a basket, in the same vein, do not put the data on a

Database configuration, it is necessary to open the binary log, if the start is not open and then want to open, you must restart.Log-point-based replicationBackup Database Tools-------------------------------------------------------------------------

Today to experience MySQL's auto-failover function, here is a tool MySQL Utilities, it is very powerful. This tool provides the following features:(1) Management tools (clone, copy, compare, diff, Export, import)(2) Copy tool (installation,

I. Description of the Environment1. CentOS 6.62.mysql 5.6.253. Gtid-based replicationIi. Description of the exceptionMistakenly inserts a data from the node as the master node, the same data is inserted in the primary, from the node insert, causing

MySQL has many kinds of replication, at least conceptually, traditional master-slave replication, semi-synchronous replication, Gtid replication, multithreaded replication, and group replication (MGR).I look a lot, a variety of replication, in fact,

"Contrast characteristics"Created November 27, 20161. Performance improvement2. Security improvements 1) SSL is turned on by default 2) no longer explicitly display user passwords 3) changes in Sql_mode3. Upgrade of the InnoDB storage engine 1) Do

After the 5.5 semi-synchronous replication, MySQL5.6 has optimized and improved it. Two of them are more important: it should be a big pleasure for O & M personnel. After the 5.5 semi-synchronous replication, MySQL 5.6 has optimized and improved it.

This set of solutions is also one of the solutions tested some time ago. This solution is relatively easy to deploy and maintain. In simple terms, keepalived is a mechanism specifically designed to provide high-availability features for lvs. It can

Mysql-utilities tool experience I mainly experienced several REPLICATION tools. Let's talk about my environment: MASTER: 192.168.1.20.slave: 192.168.1.132, and 192.168.1.20.all three databases have external users with ALL permissions. The

Use the mysql-utilities tool to experience bitsCN.com Mysql-utilities tool experience I mainly tried several REPLICATION tools. Let's talk about my environment: MASTER: 192.168.1.131 SLAVE: 192.168.1.132, 192.168.1.133 ALL three databases have ALL

Galeramysql cluster memo Mysql Cluster BitsCN.com FeaturesMySQL/Galera is a multi-master synchronization cluster, but it only uses the MySQL/InnoDB engine and has the following features:Synchronous replicationTopology of multiple master