Does databus support AWS RDS?
steamymotel opened this issue · 3 comments
Hi all,
Am Totally newbie on MySQL, I know there is limit on AWS RDS, just don't know the limitation is require by Databus.
Sorry, I haven't used RDS. Does it provide access to the binlog?
On Mon, Jan 19, 2015 at 3:52 AM, steamymotel notifications@github.com
wrote:
Hi all,
Am Totally newbie on MySQL, I know there is limit on AWS RDS, just don't
know the limitation is require by Databus.—
Reply to this email directly or view it on GitHub
#50.
Thanks for the reply. I am new to MySQL. As the RDS infrastructure, the support maybe limited.
From RDS with MySQL 5.6
http://aws.amazon.com/about-aws/whats-new/2013/07/01/amazon-rds-mysql-5-6/
That it allow to access binlog via mysqlbinlog via download or streaming.
mysqlbinlog --read-from-remote-server --host=MySQL56Instance1.cg034hpkmmjt.region.rds.amazonaws.com --port=3306 --user ReplUser --password --raw --result-file=/tmp/ binlog.00098
There is even possible setup replication as described below however, I assume the responsibility of monitoring of Replication is on the user.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
Finally, RDS support of Replication with External MySQL
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html
The detail instruction doing that:
http://www.ruempler.eu/2014/06/15/external-non-mysql-slaves-with-rds-reloaded/
Thanks
Hi @steamymotel, This would be an interesting experiement. We should theoretically work fine, If RDS supports mysql wire protocol. Please do let us know how the experiment went :).
Thanks,
Srini.