MySQL master-slave replication, mysql master-slave
Original article published on cu:
Reference:
This article involves the principle of MySQL master-slave
a global account
> Use admin
switched to DB admin
> Db.adduser ("Root", "Zhuima")
warning:the ' addUser ' shell Helper is DE Precated. Please use ' CreateUser ' instead
successfully added User: {"user": "Root", "roles": ["Root"]}
2. Create an account named Repl under the Master/slave Local database and set the same password
> Use local
switched to DB local
> Db.adduser ("Repl", "Zhui
Rotten mud: mysql5.5 master-slave synchronous replication configuration, mysql5.5 master-slave
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
In the previous article "mud: learning the principles of mysql database
Build a MYSQL master-slave replication structure and a mysql master-slave replication Structure
1. Select two servers as the master and backup databases respectively.
2. log on to the s
The data synchronization function of mysql not only provides load balancing for database queries to a certain extent, but also provides great help for database redundancy, backup, recovery, and load balancing. The data synchronization function can be implemented through master-slave replication, while master-
Label:synchronous, asynchronous, semi-synchronous replication comparison:Synchronous replication: Master commits the transaction until the transaction is committed at all slave, and the client is returned, and the transaction is completed. Disadvantage: There can be a significant delay in completing a transaction.Async
primary server and updates made to tables on the server. Second, MySQL support the type of replication is the binary log format:
Statement-based replication: An SQL statement executed on the primary server that executes the same statement from the server. MySQL defaults to statement-based replication for high efficiency
Row-based
to tables on the server.Second, MySQL support the type of replication is the binary log format:
Statement-based replication: An SQL statement executed on the primary server that executes the same statement from the server. MySQL defaults to statement-based replication for high efficiency
Row-based replication
Tags: server database binary SQL statement master
What is master-slave replication:By copying data from one of the MySQL hosts to a different host, one server acts as the primary server (master) while one or more other servers act as slave servers (
Rotten mud: Learn the principle of mysql database master-slave synchronous replication, mysql master-slave
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
This article is partly reproduced on the Internet.
MySQL
Some time ago, the company's projects were too busy to write a blog. Today, I want to write an article. I have explained the basic operations of apsaradb for redis in the previous section. Now I will continue to explain the advanced sections of apsaradb for redis, including master-slave replication and read/write splitting.
1. What is
Tags: perform mysql configuration, etc height ret port configuration of its databaseMySQL database itself provides the master-slave replication function can easily achieve multiple automatic data backup, to achieve the expansion of the database. Multiple data backup can not only enhance the security of data, but also can further improve the load performance of da
slave: 192.168.80.136
MASTER:
1. Create an account and grant the following permissions:Mysql> grant replication slave, replication client on *. * To 'bak' @ '192. 168.80.136 'identified by '20140901 ';2. log on to the master data
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.