TrustRadius
Amazon Aurora is a MySQL compatible relational database system from Amazon Web Services.Amazon AWSGreat performance and easy transition from MySQL2018-04-20T16:00:45.537ZWe 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.,The MySQL compatibility meant we didn't have to change anything in our system which used to run on a MySQL database. It was a very simple configuration change to point at the new instance once set up
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,10,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,Amazon RDS, Amazon Relational Database Service and MySQL,AWS Lambda, AWS OpsWorks, Amazon API Gateway, Amazon CloudFront, Amazon Elastic Compute Cloud (EC2), Amazon ElastiCacheAndrew RainesAmazon Aurora - A Boost on Standard MySQL2017-10-26T15:54:27.488ZCloud services are the trend. No infrastructure costs and no worries. Cloud databases are also the trend, as they can be easily scalable and upgraded.
As a senior consultant I recently configured an Amazon Aurora database to serve as the back-end of an organization software. This software included a main server providing services for mobile applications and also as a back-office web application to manage transaction information. These services relied on the Amazon Aurora database to collect and save information. Customer needed a database accessible from everywhere, with high availability, fast, always up to date and scalable as it was expected the business to grow as well as its storage needs. The Amazon Aurora turned out to be a stable solution with high performance when compared with in-house solutions like MySQL.,Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases,The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.,8,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.,MySQL, PostgreSQL, MariaDB and Microsoft SQL Server,MySQL, PostgreSQL, Microsoft SQL ServerVasco MendesUsing Amazon Aurora to better your software and development team!2017-05-02T15:33:38.867ZAmazon Aurora is used by my organization as the backend for our software. Previously, we hosted our own mysql servers which inevitably due to lack of resources ran behind on updates and thus performed more poorly than it should. Moving to Amazon Aurora has improved performance for a database that was poorly designed at the start and was operating on a slowly outdated MySQL version. Moving to Amazon Aurora not only improved performance, but allows my company to continue with fewer resources but yet have the advantage of a database that is more stable and stays up to date with the latest features. Since moving to Amazon Aurora, we also have fewer replication errors since Aurora does this flawlessly.,Automated maintenance for upgrades is by far the most superior feature of Amazon Aurora. Never be behind on upgrades again!
Performance improvements for poorly structured schema due to enhancements added by Amazon.
Replication works flawlessly due to added security measures added into Amazon Aurora which prevents admin users from "accidentally" breaking the slave instance.
Amazon Aurora is hosted on Amazon's RDBMS which also includes quick and easy setup of new database instances.,I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.,7,The main positive for my team is the time that has been freed up from the tasks of managing updates and fixing replication issues.
A negative for myself as a database administrator is removal of features that were available in Mysql. Examples include 1) the use of the storage engines other than InnoDB (such as the Federated Storage Engine), 2) certain administrative privileges such as ability to export to csv file and easy ability to kill processes. I seem to also forget they removed the built-in kill ability and you must use their own provided kill functionality.,MySQL, PostgreSQL and Microsoft SQL Server,JIRA Software, HipChatVerified User
Unspecified
Amazon Aurora
41 Ratings
