The "Price and Availability" section doesn't seem to mention anything about the price?!
Free!
AWS Database Migration Service
61–67 of 67 posts
Re: AWS Database Migration Service
#62Earlier quoted context omitted.
I don't see why not. Replication is just a command stream over a network. You can secure it over the daabsse's built in TLS support or over VPN. The only question is bandwidth and latency between your DC and AWS's.
I believe AWS stop you from connecting to anything outside your RDS subnet.
Then get you outside DB server via a VPN.
Re: AWS Database Migration Service
#63Re: AWS Database Migration Service
#64Earlier quoted context omitted.
Funny this showed up on here. I just spent the last 4-5 days playing with DMS. My company has been using AWS for a while, but management wanted a "backup" backup off Amazon "JUST IN CASE". Due to amazon blocking replication credentials for MYSQL servers we had to basically dump over scp to our off amazon server and run the update on that machine via a script. We tried a number of different options but none were relia…
Thanks for all the info. Is your On Amazon DB on RDS? We use Postgres so it might be that we couldn't do the same. Presently I run the DB on EC2 instance(s) but one day I'm sure I'll switch to RDS. Just trying to understand what an exit strategy might look like in the future.
Yes we are running a mySQL 5.6 Database on RDS.
If the Database you want to migrate/replicate from is running on Amazon you should be able to make it a replication source.
I saw nothing that stated the database HAD to be on RDS. You use the servers address to setup the endpoints. And provide a database username and password to connect with so it should be doable.
Re: AWS Database Migration Service
#65The "Price and Availability" section doesn't seem to mention anything about the price?!
"Because you only pay for the compute resources used during the migration process, a terabyte-sized database can be migrated for as little as $3."
The above is quoted from an email I received from them regarding the service this afternoon.
Note: using continuous replication and adding logging Dashboards to your links will also increase the cost. I seem to recall seeing the dashboards are $3 a piece after the first 3 or something silly like that and then data costs on top of that. My cost so far don't match that though.
I'm guess-estimating my DMS cost are going to be about $30 if the $6.48 I've spent in the last 7 days during setup and configuration time averages out.
Re: AWS Database Migration Service
#66Earlier quoted context omitted.
I believe AWS stop you from connecting to anything outside your RDS subnet.
Then get you outside DB server via a VPN.
Unless something has changed, that's the problem. When I last looked RDS was a sandboxed environment. You can't ssh to it or connect it to a VPN.
Re: AWS Database Migration Service
#67Earlier quoted context omitted.
Then get you outside DB server via a VPN.
Unless something has changed, that's the problem. When I last looked RDS was a sandboxed environment. You can't ssh to it or connect it to a VPN.
You don't need to get the RDS box on a VPN. Instead, you get your server in your data center into the AWS VPC via the AWS Gateway VPN thing. From there you tell your data center server that it's master is the RDS box and you should be all good (assuming you can do the usual song and dance with the full DB dump and replication coordinates).