We have a setup of master -> replication -> replication the dbs are: mysql 5.7 -> 5.6 -> 5.7
on the replication 5.6 we have the following my.cnf:
[mysqld]
default-storage-engine=InnoDB
innodb_file_per_table=1
performance-schema=0
max_connections=4096
group_concat_max_len=8196
innodb_flush_log_at_trx_commit=0
query_cache_limit=128M
query_cache_size=128M
max_allowed_packet=268435456
open_files_limit=29000
#log_timestamps = SYSTEM
slow-query-log=1
#log = /var/log/mysql_query.log
server-id = 2
log-bin
replicate-do-db = db_main
log-slave-updates
slave-skip-errors = all
however the bin-log on the server is not being updated. The relay-log IS being update. server-id on the master 5.7 is 1 and on the last 5.7 slave is 3. all servers have log-slave-updates and upon checking with mysqladmin var|grep update we see log_slave_updates ON.
What are we missing?
Thanks!