The role of Master and subordinate:
1. Can be used as a backup method
2. Used to achieve the separation of read and write, ease the pressure of a database
MySQL master-slave backup principle:
MySQL's master-slave replication is at least two
---The outline of this articleFirst, what is GtidSecond, the application scenarioThree, multi-threaded replication instructionsIv. Process of realizationFive, multi-source replication principleVi. the process of realization---------------------------
First, master-slave replication problems and solutionsSecond, Galera ClusterThird, MySQL 5.6 Multi-threaded replication, GTIDMySQL Replication:Master ha or multi-master node modelMmm:multi Master MySQLMha:master HAMonitoring of the master node
1.2 Different types of replicationNow that you have completely understood the limitations of physics and theory, you can start learning different types of replication.1.2.1 Synchronous and asynchronous replicationThe first distinction we can make is
Mysql replication is asynchronous. Therefore, after receiving a user's request, the result is returned to the user. And store the information in the memory, and then record it into the binary file. This will
Mysql replication is asynchronous.
Official Document: Https://mariadb.com/kb/en/mariadb/parallel-replicationStarting with version 10.0.5, MARIADB began to support parallel replicationMariaDB10.0 can perform queries and copy operations in parallel from the server, this article will
One-way replication environment from ORACLE to mysql using goldengate: I use the VBOX virtual machine, a host that has installed the ORACLE database and GOLDENDGATE. The other one only installs the ORACLE database. Configure the database environment,
Management MySQL master and slave has more than 2 years, managed more than 200 sets of MySQL master and slave, almost related to each version of the master and slave, this blog is summarized, part of it is from the network, most of it is based on
Oracle uses goldengate to perform one-way replication for Oracle and mysql. Oracle uses one-way replication for Oracle and mysql respectively. Blog. csdn. netq947817003articledetails13294937 II. Add the corresponding content to the ORACLE master
The following articles mainly discuss MySQL Replication optimization, we all know that MySQL The actual discussion of Replication is still the majority, and a lot of content is very practical, so I will summarize it and hope it will bring you some
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.