In Aurora RDS Replication bin_log always OFF

Question

I have created a DB Cluster Parameter group.

Create a parameter group:
aws rds create-db-cluster-parameter-group \
    --db-cluster-parameter-group-name repl-clstr-param-group\
    --db-parameter-group-family aurora-mysql5.7 \
    --description "Prod repl cluster parameter group by YA"

Modify binlog_format to ROW:
aws rds modify-db-cluster-parameter-group \
    --db-cluster-parameter-group-name repl-clstr-param-group \
    --parameters "ParameterName=binlog_format,ParameterValue=row,ApplyMethod=pending-reboot"

Then assign this DB cluster parameter group to the database cluster.

aws rds modify-db-cluster \
   	--db-cluster-identifier my-db-cluster \
       --db-cluster-parameter-group-name repl-clstr-param-group --apply-immediately

Then I rebooted cluster, rebooted instances(both writer and reader).

I have tested it initially in a test DB where the replication is working perfectly but the same db cluster parameter group when I assigned and rebooter cluster it did not work for me.

In Production DB
SHOW VARIABLES LIKE 'binlog_format';
binlog_format = ROW

show variables like 'log_bin'; 
log_bin = OFF** (It is ON in the Test DB)**

repl-clstr-param-group(In Sync)

Anything can be done?

BTW: I have followed the following URL to setup Replication. 
https://aws.amazon.com/blogs/database/perform-cross-account-amazon-aurora-mysql-migration-with-minimal-downtime/
As I said, this guideline works perfectly for test database.

And followed the following URL to reboot the clusters after enabling the db cluster parameter group.
https://repost.aws/knowledge-center/enable-binary-logging-aurora

Answer

Hi Yasir,

Did you check "binlog_format" from the MySQL command as in :-

`show variables like '%binlog_format%'`

It must be showing the default value of this variable which is ROW.

What is the "binlog_format" showing in the DB cluster parameter group?

It must be showing as "OFF" if the parameters are in Sync.

[] Configuring Aurora MySQL binary logging - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.MySQL.BinaryFormat.html

Answer

Hi Raunak G,

Yes, I checked it which I mentioned in the post.

SHOW VARIABLES LIKE 'binlog_format'; 
binlog_format = ROW

In Aurora RDS Replication bin_log always OFF

Relevant content