Overall Satisfaction with Amazon Aurora
We use Amazon Aurora as our primary data store which underlies the bulk of our system operations - primarily via web APIs. Its used beneath a PHP stack as a MySQL compatible cluster in a master-slave configuration. We also have master-only clusters for our development and test environments.
- Much better performance than our previous MySQL database (hosted on AWS RDS) for lower costs due to the way storage is managed
- Storage management is much more simple as it grows and shrinks with you without having to allocate and deallocate storage to the database
- Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
- Moderately reduced database running costs
- Improved performance of database cluster which in turn has had a positive impact on the response times of our API services
Using cloud-based services such as RDS or Aurora take all the hassle out of managing database servers yourself. It also gives you the flexibility to easily spin up and down additional instances and as when required. Where Aurora outshines RDS is in terms of performance - we saw around 2-5x improvement in query read times across the board.