linkedin/databus

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.