SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA involvement with AWS Aurora migrated databases


DBA involvement with AWS Aurora migrated databases

Author
Message
Indianrock
Indianrock
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18147 Visits: 2461
We may migrate a small customer database to AWS. ( moving our larger databases off of local sql server installations is way down the road, if ever ) What I'm most interested in is the typical level of involvement of a company DBA . In other words does AWS handle everything ( backups, performance schema changes etc )?

If we did consider migrating a busy 7 TB customer database to AWS, would Aurora be a good choice ( is that too large? ) or would sticking with sql server on AWS be more likely?



RTaylor2208
RTaylor2208
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11586 Visits: 1544
Indianrock - Monday, May 8, 2017 10:54 AM
We may migrate a small customer database to AWS. ( moving our larger databases off of local sql server installations is way down the road, if ever ) What I'm most interested in is the typical level of involvement of a company DBA . In other words does AWS handle everything ( backups, performance schema changes etc )?

If we did consider migrating a busy 7 TB customer database to AWS, would Aurora be a good choice ( is that too large? ) or would sticking with sql server on AWS be more likely?

We have several systems hosted in AWS and utilize both MySQL RDS instances and Aurora RDS instances. In my opinion you still need a DBA, almost daily I am still dealing with security tasks, performance issues, general maintenance, ETL tasks etc on our AWS instances.

There is then also all of the network security conundrums to solve when it comes to implementing VPC's, setting up ACL rules, VPN tunnels, security groups etc. You should really be responsible for scaling your database platform as well which will require monitoring your environment, identifying when to scale up or scale out with replicas.

Our experience with Aurora is that is is much faster than the MySQL RDS option when it comes to small concurrent transactions essentially the usual CRUD type operations. Where it fails is performing queries that aggregate large sets of data this is generally slower than MySQL RDS Instances.

First of all you do know that Aurora is based on MySQL? So you would need to port your DB from SQL server to essentially MySQL, depending on the structure of your database this can be time consuming.

2nd of all, how do you plan to migrate the 7TB of data? That is an awful lot to transfer over the internet, although Amazon have now made it much easier with their database migration service : https://aws.amazon.com/dms/ I wish that had been available when we started out.

Over the last 2.5 years I have learned a lot when it comes to networking which was never a strength working within the AWS environment, and to be honest if you want to work effectively and securely with AWS you will need to learn it too unless you are already familiar.


MCITP SQL 2005, MCSA SQL 2012
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search