Re: Mysql 5.7 replication (A -> B -> C) not working

[gowthamakanthan gopal]

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)