mysql source ignore_MySQL用source命令导入不记入binlog中【原创】

蔚落 2023-01-11 13:01 82阅读 0赞

主库查询

root@localhost:mysql.sock \[(none)\]>show slave status\\G;\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*Slave\_IO\_State: Waitingformaster to send event

Master\_Host:10.72.16.50Master\_User: root

Master\_Port:3306Connect\_Retry:60Master\_Log\_File: mysql-bin.000002Read\_Master\_Log\_Pos:11626109Relay\_Log\_File: mysql-relay-bin-503306.000004Relay\_Log\_Pos:367Relay\_Master\_Log\_File: mysql-bin.000002Slave\_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:0Last\_Error:

Skip\_Counter:0Exec\_Master\_Log\_Pos:11626109Relay\_Log\_Space:628Until\_Condition: None

Until\_Log\_File:

Until\_Log\_Pos:0Master\_SSL\_Allowed: No

Master\_SSL\_CA\_File:

Master\_SSL\_CA\_Path:

Master\_SSL\_Cert:

Master\_SSL\_Cipher:

Master\_SSL\_Key:

Seconds\_Behind\_Master:0Master\_SSL\_Verify\_Server\_Cert: No

Last\_IO\_Errno:0Last\_IO\_Error:

Last\_SQL\_Errno:0Last\_SQL\_Error:

Replicate\_Ignore\_Server\_Ids:

Master\_Server\_Id:503306Master\_UUID: b7fae014-c3af-11e8-89c1-000c29bf3444

Master\_Info\_File: mysql.slave\_master\_info

SQL\_Delay:0SQL\_Remaining\_Delay: NULL

Slave\_SQL\_Running\_State: Slave has read all relay log; waitingfor moreupdates

Master\_Retry\_Count:86400Master\_Bind:

Last\_IO\_Error\_Timestamp:

Last\_SQL\_Error\_Timestamp:

Master\_SSL\_Crl:

Master\_SSL\_Crlpath:

Retrieved\_Gtid\_Set:

Executed\_Gtid\_Set: 22dc7409-2cd5-11e7-888c-000c29bf3444:1-984109,

387faba7-a070-11e8-8674-000c29466957:1-53880,

671bac73-a032-11e8-a493-000c29bf3444:1-10,

909c25b1-7f67-11e8-9b9d-000c29bf3444:1,

a68949d2-a06c-11e8-bba3-000c29bf3444:1,

ee639e4e-358a-11e7-87fa-000c29466957:1-753Auto\_Position:1Replicate\_Rewrite\_DB:

Channel\_Name:503306Master\_TLS\_Version:1 row in set (0.03sec)

从库查询

mysql>show slave status\\G;\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*Slave\_IO\_State: Waitingformaster to send event

Master\_Host:10.72.16.112Master\_User: root

Master\_Port:3306Connect\_Retry:60Master\_Log\_File: mysql-bin.000001Read\_Master\_Log\_Pos:323113389Relay\_Log\_File: relay-bin-1123306.000004Relay\_Log\_Pos:11660372Relay\_Master\_Log\_File: mysql-bin.000001Slave\_IO\_Running: Yes