Neil
Neil

Reputation: 63

How to periodically copy from one database to another inside a single RDS instance?

Can someone point me to the correct direction or terminology? I've been searching about it but I can't find any relevant info. It may be the keywords or terms I'm using.

I have a one RDS instance with two MySQL databases. I'd like to copy data from some tables in Database A to Database B, a couple of times a day.

Is this possible? If it is, can you point me to some documentation?

Upvotes: 1

Views: 1087

Answers (1)

Lucas Azevedo
Lucas Azevedo

Reputation: 1095

You can use AWS Lambda Scheduled Events to access your RDS instance and copy the tables from your Database A to Database B.

Upvotes: 2

Related Questions