Insoftservice inso
asked on
Mysql Server backup from RDS to remote
Hi all,
I wanted to backup few tables from RDS to my remote mysql server on daily basis.
Using Mysqldump on cron would work but issue is that its too huge and updating whole records again is not feasible .
Wanted script or some method to update or add only newly added or updated records on my remote DB Server so that server don't gets loaded or consumes too much time.
OS: ubuntu
db : mysql
I wanted to backup few tables from RDS to my remote mysql server on daily basis.
Using Mysqldump on cron would work but issue is that its too huge and updating whole records again is not feasible .
Wanted script or some method to update or add only newly added or updated records on my remote DB Server so that server don't gets loaded or consumes too much time.
OS: ubuntu
db : mysql
I have found a tool that supposely does this scheduling but it has a price (not too much)...check Automatic Backup Scheduler for MySQL
ASKER
sqlyog can do the same. we are not looking for paid system on our linux server
Creating a slave DB for the target tables is an option, also, Then it's updated almost real-time, and you can manipulate the backups as you see fit on the remote server. This alleviates the need to dump whole data sets on some regular schedule, as all db IO is replicated on your slave.
ASKER
Slave option is not possible. As it runs on real time and it would unnecessary provide load on server. secondly i am not sure if its possible as both Geo-location are different .
I want to run on script which would only fetch certain tables and only updated records only
I want to run on script which would only fetch certain tables and only updated records only
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.