Mysql master-slave replication, mysql master-slave
Master-slave replication: There are two ways to start master-slave replication from MySQL5.6: Log-based (binlog); GTID-based (global transaction identifier );
1. Log-based master-slave replication
I. Glossary:
1:
Server_uuid: Server ID. When Mysql is started for the first time, a server_uuid is automatically generated and written to the auto. cnf file in the data directory. It is not recommended to be modified.
[Root @ mysql5_6 data] #
I wrote "MySQL5.1 Master/Slave configuration" a long time ago. Now MySQL has released 5.6.10, and many optimizations have been made on the Master/Slave replication function, especially GTID (GlobalTransact
I wrote MySQL 5.1 master-slave
Summary: Masterha_master_switch is integrated as a switch tool in the MHA package,Install: After compiling and installing MHA Manager, binary executable program Masterha_master_switch will be generated in/usr/local/bin/.Use:$masterha_master_switch --
Copying only a subset of the tables in the database can reduce the pressure on the master and slave serversOn the primary serverBINLOG-BIN-DB only the specified database-related modifications are counted in the binary log (in general)
MySQL replication in the industry has called: MySQL synchronization, AB replication and so on. The professional name is called: Copy. Replication is one-way asynchronous replication, copying from one MySQL (Master) to another MySQL (Slave).
1. How to define and generate GtidsUniqueness: In all master and slave libraries are unique, consisting of two tuples?
GTID = source_id:transaction_id
SOURCE_ID mark the main library1.1 Server_uuidHow to get Server_uuidA,
http://blog.itpub.net/28218939/viewspace-1975856/Concurrent Replication ( Parallel Replication ) Series three:MySQL 5.7 and MariaDB parallel replication ContrastMa Pengfei Technology MySQL database engineer
After two mysql/mariadb on the
[MySQL case] HA: GTID_MODE configuration inconsistent 1.1.1. HA: GTID_MODE configuration inconsistent
[Environment description]
Msyql5.6.14
[Error message]
In the initial state, both the Master and Slave enforce-gtid-consistency and gtid-mode
Go to the mysql homepage and cover all the articles about how good mysql 5.6 is. Later, I browsed the 5.6 update description, saying that replication was enhanced, and some people tested to enable replication, which had little impact on performance.
1.1.1. HA: inconsistent GTID_MODE configurations
[Environment description]
Msyql5.6.14
[Error message]
In the initial state, both the Master and Slave enforce-gtid-consistency and gtid-mode are enabled, and both of them are changed to off. In
1.1.1. Ha:gtid_mode Configuration Inconsistencies"Environment description"msyql5.6.14"Error Message"The initial state master and slave both open enforce-gtid-consistency and Gtid-mode, and then the master on both of them changed to off off state,
MySQL parallel replication is already a commonplace. I started to deal with this issue online since 2010. I have been happy to share it for the first two or three years. Now I will mention this topic to avoid the suspicion of "stir-fried
First, MySQL master-slave backup principleFirst, the concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized. Operations on any one database are automatically applied to another database,
Summary: MySQL 5.5 supports single-threaded mode replication, MySQL 5.6 supports library-level parallel replication, and MySQL 5.7 supports transactional-level parallel replication. With this mainline we can analyze the causes and consequences of
Records all operations (DML statements) of the MySQL database that actually make changes, not statements that do not have any data modified, and statements such as Select and show are not recorded.The role of the binary log:1, can complete the
For more information, see mysqldump data export.
1. An error (1064) is reported when mysqldump is used. This is because the version of mysqldump is too low and is inconsistent with the current database version.
Mysqldump: Couldn't execute 'set
Erranttransactions: MajorhurdleforGTID-basedfailoverinMySQL5.6 I have previusly written about thenew replication protocolthat comes with GTIDs in MySQL 5.6. because of this new replication protocol, you can inadvertently create errant transactions
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.