Likelihood to Recommend
Amazon RDS is well suited if you need a highly-available, cloud-hosted, scalable database for websites or web applications. It can grow to serve as many queries as you need (at a cost) and is easy to configure. That being said, RDS can get expensive quickly depending on your use. If you're hosting a simple website or blog, it would be cheaper to stand up a database inside the EC2 instance powering the application. If you're not working with a lot of data, RDS can potentially be overkill for your needs.
I always suggest Sequel Pro for accessing databases. It's free, secure and easy to use. Because it's an application that lives on your machine and possesses the ability to connect to databases over SSH it means we don't have to expose web-based database management applications or expose the database port publicly on the server. The only time Sequel Pro is not an option is if the database is not MySQL or an equivalent
- RDS provides high availability databases without having to manage your own servers.
- Amazon Aurora in particular is a breakthrough database technology, and in particular with the PostgreSQL engine provides advanced features at a fraction of the cost of an Oracle implementation, with better features that have been designed from the ground up to support the cloud.
- Aurora also allows supports large clusters of database servers easily, with super fast replication (~20 ms), and flexibility to allow changing resources provisioned based on workload.
- Easy to understand interface
- Very versatile; it is powerful to both the beginner, and the expert
- It makes it easy to navigate across various databases on different servers
Engineer in EngineeringComputer Software Company, 501-1000 employees
- Cross-Region replication is supported for most platforms and engines, but is not available across the board yet. Where it is available it provides an excellent solution for disaster recovery.
- Wish it could handle more database types. As of now it can't connect to disparate datasources.
- Wish it could autoformat.
- Error messages aren't typically verbose enough to really debug a query without resorting to EXPLAIN queries.
Automated snap-shotting every 24 hours is, again something that I could just set up in minutes with a few clicks, though we also backup on cron jobs to elsewhere, and, because of our industry we have a HUGE "forensic logs" that initially live in the database but get archived off every seven days. (We literally log every single API call between our front-end and our application servers, and the data structures that the APIs return.
Sequel Pro has a fully functional free version which is fast and unlimited. None of the others let you get to your data as quickly and directly as Sequel Pro does. With the exception of the default tools provided by MySQL, Sequel Pro is probably the client that remains most up to date to the latest editions of every MySQL server that is released.
Return on Investment
- Using AWS in general, and especially RDS, has made it extremely easy to gain the trust of enterprise-level clients who have significant security and privacy concerns.
- The scalability and rapid upgrade process of RDS has freed my business from a lot of growing pains.
- Thanks in part to RDS, our hosting costs account for under 1% of operating costs.
- 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?