MySQL Forums
Forum List  »  Replication

Re: Mysql master not replicate data to slave
Posted by: Piseth Ben
Date: December 02, 2020 07:13PM

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.56.25
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000002
Read_Master_Log_Pos: 1945
Relay_Log_File: mysqld-relay-bin.000066
Relay_Log_Pos: 251
Relay_Master_Log_File: mysql-bin.000002
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: testdb,mydb
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: 1945
Relay_Log_Space: 552
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:
1 row in set (0.00 sec)


mysql> SHOW TABLES FROM performance_schema LIKE 'replication%';
ERROR 1049 (42000): Unknown database 'performance_schema'

mysql> select * from replication_connection_status\G
ERROR 1146 (42S02): Table 'mydb.replication_connection_status' doesn't exist

mysql> select * from replication_applier_status_by_worker\G
ERROR 1146 (42S02): Table 'mydb.replication_applier_status_by_worker' doesn't exist

I only show slave status, the other commands got error.
Maybe it not support with my db version.

Can you help me please?

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql master not replicate data to slave
56
December 02, 2020 07:13PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.