Shulou(Shulou.com)06/01 Report--

The following mainly brings you a simple understanding of mysql master-slave replication, hoping to simply understand that mysql master-slave replication can bring you practical use, which is also the main purpose of my editing this article. All right, don't talk too much nonsense, let's just read the following.

The principle of master-slave replication. Only one diagram is needed (from the network, declare and thank you)

Amure-"B"

Master slave

1. Change here

Binary log 2. Read the changed binary

3. Then pass through the local relay log

4. Use SQL thread to read and write tables for replication

Parallel serial

My environment is: emphasized here, it should be the same version of the database, but the small inconsistencies have not been tested, the production environment is still consistent and stable, who knows what will happen?

First of all, configure the main CVM, which is available on the Internet, one is id, and the other is to open binary logs. Then check the show master status

Then configure the slave server. Let me talk about the PHPmyadmin of wamp (it is estimated that linux is better).

Create a slave from the CVM where replication is made (interfacing)

First error: unable to read master CVM log

Solution: Oh no, forget to set up a replication user, set up a user on the main cloud server, just give a few permissions, one copy, one view file, another authorization.

,

The second is a helpless mistake, looking for error 1794 for a long time.

This problem is the configuration file problem, generally no matter how you modify it will not work, unless you can close your eyes oblique MySQL configuration, after all, open source. Otherwise, do not modify it on my.ini, copy my.default.ini directly, and add this information (you can copy my.ini in part)

Log_bin=mysql-bin# These are commonly set, remove the # and set as required.# basedir=. # datadir=. # port =. # server_id = .basedir=d:/wamp/bin/mysql/mysql5.6.17log-error=d:/wamp/logs/mysql.logdatadir=d:/wamp/bin/mysql/mysql5.6.17/databinlog_format=mixedserver_id = 15

For the above about the simple understanding of mysql master-slave replication, we do not find it very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.