|
本帖最后由 mazy 于 2024-8-19 15:31 编辑 主从状态正常   未同步主库数据，Exec_Master_Log_Pos和Read_Master_Log_Pos位置明显变化 Master_Log_File: binlog.000015 Read_Master_Log_Pos: 231359544 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 317 Relay_Master_Log_File: binlog.000015 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: 231359544 但binlog未变化 show master status \G *************************** 1. row *************************** File: binlog.000001 Position: 154 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set (0.00 sec) binlog日志文件和relay-bin日志文件的大小、时间无变化（是配置主从的时间，不是当前时间，实时是有数据进来的） 4.0K -rw-r----- 1 greatsql greatsql 154 8月 15 06:22 binlog.000001 4.0K -rw-r----- 1 greatsql greatsql 29 8月 15 06:22 binlog.index 4.0K -rw-r----- 1 greatsql greatsql 201 8月 15 06:26 relay-bin.000001 4.0K -rw-r----- 1 greatsql greatsql 317 8月 15 06:26 relay-bin.000002 4.0K -rw-r----- 1 greatsql greatsql 64 8月 15 06:26 relay-bin.index 日志无报错 2024-08-15T06:26:20.348645+08:00 3175814 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3046, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= , master_log_file='binlog.000015', master_log_pos= 700441, master_bind=''. 2024-08-15T06:26:26.815396+08:00 3243299 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2024-08-15T06:26:26.820835+08:00 3243299 [Note] Slave I/O thread for channel '': connected to master 'repl@10.174.28.61:3046',replication started in log 'binlog.000015' at position 700441 2024-08-15T06:26:26.858976+08:00 3243300 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.000015' at position 700441, relay log '/data/GreatSQL/relay-bin.000001' position: 4 2024-08-15T06:26:42.773778+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4217ms. The settings might not be optimal. (flushed=87, during the time.) 2024-08-15T06:26:49.624998+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4756ms. The settings might not be optimal. (flushed=38, during the time.) 2024-08-15T06:30:45.383147+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5706ms. The settings might not be optimal. (flushed=2, during the time.) |
|
|
yejr
2024-8-15 09:20:21
| |
|
|
mazy
2024-8-16 11:31:34
| |
|
|
mazy
2024-8-16 11:33:43
| |
|
|
yejr
2024-8-16 14:50:36
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
