Likelihood to Recommend
Amazon Aurora is best suited for creating complex, highly available and commercial databases, in a very straightforward way. The database size should be medium to large because only then will you be able to justify the extra cost incurred for using Amazon Aurora. Another aspect is that if you are already using AWS and most of your applications and services are on the cloud, then it makes sense to use Amazon Aurora since it fits in the Amazon ecosystem really well.
Team Lead in Information TechnologyInformation Technology and Services Company, 10,001+ employees
- Super easy for quick development and investigation
- The interface of exporting tables to SQL can be made better, it's not easy to manually check
- Not suitable for designing your DB
- Connections over SSH to vagrant and Docker hosted DBs
- Auto suggestion can be better
- Performance: We utilize Aurora as a PostgreSQL replacement, and Aurora's throughput is up to 3 times higher.
- Simple Instance Auto-Scaling: We can scale the underlying database engine up or down with no down time.
- Auto-Growing Storage: Rather than having to over-provision, Aurora automatically adds blocks of 10GB to your storage cluster up to multiple terabytes of storage.
Director in EngineeringComputer Software Company, 51-200 employees
- Ability to quickly connect to a variety of databases.
- Ability to see the schema and data within the tables so you don't have to go looking for it.
- Theoretically, the ability to have multiple connections open in multiple tabs at the same time (see problems section for why I say "theoretically").
- Ability to write queries and have them execute locally.
- Quickly see relations between tables and rows in tables.
- Just like AWS DynamoDB which is a not a SQL solution and is truly a global DB, it would be great if AWS Aurora can become a global DB. What that means is that it is multi-region multi-master. That way writes to different regions of AWS would all be in sync and available in replicas on different regions.
Team Lead in EngineeringFinancial Services Company, 10,001+ employees
- Improving the way we create new connections to remote databases
- I couldn't find any way to configure my local server (MySQL), so I need to make changes on server outside the application. I know that there are other tools that integrate it, so you don’t have to leave the workflow
- It could have a feature to integrate our databases or connections (favorites) with other devices, like using Google Drive or Dropbox. It would be really useful!
Amazon Aurora 7.7
Based on 3 answers
The support as a whole cannot be applied to just Aurora, but I must say that the response to our tickets from the AWS side was a bit anemic. Despite that, there is plenty of documentation and forum articles that should make anybody self-serviced. Again, let me stress this out - the product (in either MySQL or Postgres form) was used by many people and thus now well understood, explained and there are plenty of books and other material available. This is not the case that we encountered with NoSQL.
Sequel Pro 6.0
Based on 2 answers
The software has been crashing randomly since 2016, the dev branch has had the fix for a while now but for some reason it has not been merged to stable branch.
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.
Sequel Pro's major competitor is Oracle's MySQL Workbench, a multi-platform MySQL server management software. While MySQL Workbench is more robust and feature complete, it doesn't beat Sequel Pro in terms of simplicity while providing all the power a pro would need.
Return on Investment
- The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
- The database replication and schedule for backup tasks are much easier, so less prone to errors.
- We have never had a database downtime on our applications, which is essential for our customer business.
- Saves time in connecting to server-side MySQL databases because it remembers key info needed to set up the SSH tunnels.
- Makes it easy to do backup and restore of MySQL databases with minimum downtime.
- Provides a quick and easy way to access, review and edit the underlying data in any MySQL database or table using behind any of our company's web applications.
Premium Consulting/Integration Services—
Entry-level set up fee?