Consult everybody, set up a set of mysql master-slave, main library build table, insert data, the main Position in the library is not growth, result in the past, from the library also sync what is this? Bosses glad to forget all of you!


Mysql> Show master status \ G
* * * * * * * * * * * * * * * * * * * * * * * * * * * 1 row * * * * * * * * * * * * * * * * * * * * * * * * * * *
File: mysql - bin. 000005
Position: 590
Binlog_Do_DB: btbzb_zmhk, test
Binlog_Ignore_DB: mysql, information_schema performance_schema
Executed_Gtid_Set:
1 row in the set (0.00 SEC)

Mysql>
Mysql> Insert into test. The employee (name, phone) values (' zm, 18888888888);
Query OK, 1 row affected (0.06 SEC)

Mysql> Insert into test. The employee (name, phone) values (' zm, 18888888888);
Query OK, 1 row affected (0.04 SEC)

Mysql> Insert into test. The employee (name, phone) values (' zm, 18888888888);
Query OK, 1 row affected (0.09 SEC)

Mysql> Insert into test. The employee (name, phone) values (' zm, 18888888888);
Query OK, 1 row affected (0.02 SEC)

Mysql> Insert into test. The employee (name, phone) values (' zm, 18888888888);
Query OK, 1 row affected (0.03 SEC)

Mysql> Show master status \ G
* * * * * * * * * * * * * * * * * * * * * * * * * * * 1 row * * * * * * * * * * * * * * * * * * * * * * * * * * *
File: mysql - bin. 000005
Position: 590
Binlog_Do_DB: btbzb_zmhk, test
Binlog_Ignore_DB: mysql, information_schema performance_schema
Executed_Gtid_Set:
1 row in the set (0.00 SEC)

Mysql>

CodePudding user response:

From the library state is normal, the following
Mysql> Show slave status \ G
* * * * * * * * * * * * * * * * * * * * * * * * * * * 1 row * * * * * * * * * * * * * * * * * * * * * * * * * * *
Slave_IO_State: Waiting for the master to send event
Master_Host: 192.168.16.144
Master_User: repl
Master_Port: 3306

60 Connect_Retry:Master_Log_File: mysql - bin. 000005
Read_Master_Log_Pos: 590
Relay_Log_File: relay - log - bin. 000002
Relay_Log_Pos: 320
Relay_Master_Log_File: mysql - bin. 000005
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 590
Relay_Log_Space: 525
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 144
Fe dc9 Master_UUID: 03756-83-11 b44f32217 e8-8572-107
Master_Info_File://WWW server/data/master info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; Waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in the set (0.00 SEC)

CodePudding user response:

Replicate_Do_DB:
Replicate_Wild_Do_Table:
Is empty, change the configuration file, set the library

CodePudding user response:

refer to the second floor qq_37496900 response:

Replicate_Do_DB:
Replicate_Wild_Do_Table:
Is empty, change the configuration file, set the library

Master database configuration, and changed from the library this parameter should be also need to add?

CodePudding user response:

The main library without, is that you didn't open log_bin, look at what the results of this query is
Show variables like '% log_bin';

CodePudding user response:

reference 4 floor ZJCXC response:

main library without, is you didn't open log_bin, look at what the results of this query is
Show variables like '% log_bin';

master database must be opened, yesterday the binlog - do - db later commented out the parameters, the significant increased, but don't understand why

Mysql> Show variables like '% log_bin';
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
Value | | Variable_name |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
ON | log_bin | |
ON | sql_log_bin | |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
2 rows in the set (0.01 SEC)

CodePudding user response:

That estimate is you have a problem to
This parameter decided to record those libraries binlog, if the configuration is wrong, that there is no configuration library nature is not to record the binlog
If all libraries to synchronize, usually do not set this, the default is all library records (have a need to consider the system library by setting Binlog_Ignore_DB filter)
Do set the general family is not prepared, so that the system of library has in the past, so keep on both sides are exactly the same, the main library hang high sex with directly from the library

CodePudding user response:

https://blog.csdn.net/fsdf8sad7/article/details/88844412