MySQL Forums
Forum List  »  Replication

Re: Mysql 5.7 replication (A -> B -> C) not working
Posted by: gowthamakanthan gopal
Date: June 29, 2021 12:36AM

I've taken a dump from master(server c) and restored it in server d. I can see the data, i want to double confirm the replication is working.

On Master (Server C):

mysql> SHOW BINARY LOGS;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 177 |
| mysql-bin.000002 | 329 |
| mysql-bin.000003 | 437 |
| mysql-bin.000004 | 646 |
| mysql-bin.000005 | 177 |
| mysql-bin.000006 | 588 |
+------------------+-----------+
6 rows in set (0.00 sec)

mysql>

On Slave (server D):
mysql> SHOW BINARY LOGS;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 116025299 |
+------------------+-----------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql 5.7 replication (A -> B -> C) not working
227
June 29, 2021 12:36AM


Sorry, you can't reply to this topic. It has been closed.

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.