MySQL logs a binlog log error from the library example

Last night Learning video "l11-16-configure MySQL to record Binlog and its production application W" from the library, the beginning of the section is jammed.

In the configuration file/data/3307/my.cnf of the database, after opening the parameter "Log-bin =/data/3307/mysql-bin" and adding the "log-slave-updates" parameter, restart the database service.

Test creation of 1 new Libraries "CREATE database oldgirl02;" After that, even if the newly generated Logbin log file is filtered, there is no result.

[Email protected] 3307]# mysqlbinlog--no-defaults mysql-bin.000010|grep Database

　　The other log file "relay-bin.000071" has just created the database statement!

Why?

The parameters of the configuration file are checked repeatedly (no problem), why is this?

Here again, there is a case of inconsistent video with Oldboy.

This week's official start-up work plan didn't go well, which made me uneasy. After completing the "principle and operation of master-slave synchronization", the nerves that stretched for a long time suddenly wanted to loosen up. And, after beginning to watch the drama "Obstetrician", it was really loose.

Tense learning once relaxed, it seems that the motivation of learning is not enough.

When it comes to problems, the heart is only irritable, and then just want to jump over ...

Night 10 o'clock more bathing, and began to reflect on the "Han clothes House" why even the opportunity to interview do not give?

Apart from the fact that they may have their own stereotypes, perhaps their own skills, there is still a shortage of it. After all, it is now I also think: Han Clothing house in the province, to the site rankings, the number of visits is definitely ranked in the first few.

No matter what kind of enterprise you can enter in the end, the solution to every problem in the learning process is a part of your own growth and a fortune of 1 gold coins.

Then, while washing their own body, while thinking about ways. After washing the method, is to Oldboy QQ group questions, to the major technical forum post.

However, if you post or ask questions in the group, you should also organize your language.

I log in to the terminal in the virtual machine and log in to 3 terminals and log in to 2 instances respectively. When I try to check the sync status "show slave Status\g", I find that the status is an error. Furthermore, to test the 3 databases created in the main library, none of the libraries exist-that is, no synchronization is successful.

Reading the wrong message code is "1008", the error message of the English is not complex, but also the same meaning: "The database does not exist, delete the database failed."

I then deleted the database in the error message (in fact, it was not in the library or the main library).

Then execute the statement "stop slave;" and "Start slave;" (equivalent to restarting the service), the View sync status is back to normal. View the database from the library, also basically the same as the main library.

Finally check the Binlog log, there is no problem.

[Email protected] 3307]# mysqlbinlog--no-defaults mysql-bin.000010|grep databaseset @ @session. collation_database= Default/*!*/;create Database Oldgirl02

When did you create the database that was not deleted from the library? Was it created during the test in the previous course and was not deleted in time? I can't remember, not a bit.

Because the process of solving is in the virtual machine inside the operation, very troublesome. I would have to give a verbal description, I hope I can read it later.

Description

　　After 1 days, here is the execution of "stop slave;" After deleting the database, or deleting the database and then executing the "stop slave;" Statement, I also do not remember the accuracy.

This article is from the "Dark-matter" blog, make sure to keep this source http://gagarin.blog.51cto.com/1056957/1534008