mysql-live-select icon indicating copy to clipboard operation
mysql-live-select copied to clipboard

Published 20 hours ago • verified publisher icon numtel

Bin Log on RDS with MySQL 5.6

Open narangrishab opened this issue 9 years ago • 3 comments

@numtel What's the procedure to enable binlog on MySQL 5.6 + running on a RDS. There's no my.cnf file on RDS.

Basically my bin log files are located at Uploading Screen Shot 2015-09-04 at 3.11.15 pm.png…

narangrishab avatar Sep 03 '15 14:09 narangrishab

I wish I could find a answer for this as well... I'm trying to make this module to work using a remote database on AWS RDS... I did all the changes pointed on doc... on my AWS instance I found the my.conf file located at /etc/my.conf... Restarted my instance and still not able to work...

I was able to make it run on my local and I was very hopeful I could make it work on my AWS instance... no lucky so far...

griiettner avatar Aug 19 '16 04:08 griiettner

Ok... I just found out that it is not possible to set or edit the binlog on RDS... we just don;t have access to it... this one the down side of having RDS as server for MySQL

You can read more here http://dba.stackexchange.com/questions/34525/amazon-rds-for-mysql-vs-installing-mysql-on-an-amazon-ec2-instance

griiettner avatar Aug 19 '16 15:08 griiettner

I have just found out that you need to enable backup for your RDS instance else binlog is automatically turned off

The-Edge-Malaysia avatar Dec 15 '16 09:12 The-Edge-Malaysia