In Aurora RDS Replication bin_log always OFF

0

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

질문됨 2달 전135회 조회
2개 답변
0

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

profile pictureAWS
전문가
답변함 2달 전
0

Hi Raunak G,

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

SHOW VARIABLES LIKE 'binlog_format'; binlog_format = ROW

답변함 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인