Amaon Aurora
Use Cases and Deployment Scope
test
Pros
- test
Cons
- test
Return on Investment
- test
Usability
Other Software Used
MySQL
What is Amazon Aurora?
Amazon Aurora is a global-scale relational database service built for the cloud with full MySQL and PostgreSQL compatibility.
Categories & Use Cases
Media
Top Performing Features
Database scalability
Ease of scaling compute or memory resources and storage up or down
Category average: 9
Automated backups
Automated backup enabling point-in-time data recovery
Category average: 8.2
Automatic host deployment
Compute instance replacement in the event of hardware failure
Category average: 7.4
Areas for Improvement
Database security provisions
Provision for database encryption, network isolation, and identity access management
Category average: 8.8
Monitoring and metrics
Built-in monitoring of multiple operational metrics
Category average: 6.7
Automatic software patching
Patches applied to database automatically
Category average: 8.6
Easy to use, configure and maintain
Use Cases and Deployment Scope
We currently use Amazon Aurora across all of our clients and have recently migrated over to the V2 type. This is a great product offered by AWS as it solves a lot of the maintenance problems we would otherwise have to address, and it offers high performance and easy to configure and change parameters.
Pros
- Easy to maintain
- Easy to configure
- Can change instance types quickly
- Offers great DR options
Cons
- Sometimes too many options of instance types, versions, engines, etc. so can get confusing
Return on Investment
- Setup costs low
- Maintenance costs low
- Easy to setup DR
- Easy to adjust instance type based on usage
- Ability to add reserved instance to keep costs down
Usability
Alternatives Considered
Azure Database
Other Software Used
Amazon Relational Database Service (RDS), Amazon ElastiCache, Azure Database, AWS Database Migration Service
A powerful RDBMS
Use Cases and Deployment Scope
A perfect and powerful database management system, I received this application from one of my colleagues, after changing from many DBs like one them is MongoDB.
It has a powerful life of taking a huge amounts of data, as for long I have been working with data, I wanted a powerful and well working database system for working efficiently and effectively with my data works, well this application has a cool and powerful chain system for making relationships with various data. I loved it.
Pros
- Powerful data handling
- Migration facility
- Cost effective application
Cons
- GUI
- Interaction
Return on Investment
- Positive: Cost effectiveness
- Positive: large data storage
- Positive: High security features
- Negative: Lacking interactiveness
- Negative: Lags when high input is placed.
Alternatives Considered
MongoDB and RavenDB
Other Software Used
RavenDB, MongoDB
Amazon Aurora - what an excellent solution for Database problems
Use Cases and Deployment Scope
As any company that have to use a database to store information not only for the business data but also for different applications, we decided to use Aurora MySQL to ease the administration and be safe that AWS will handle all patching, updates, backups and maintenance of the database.
Pros
- No need to provision storage nor IOPS for the disks
- Automatics continuos backups with the possibility to point-in-time restore in new database or backtrack to a point in time in the same database
- Increase availability by using Read Replicas and also distributing read capacity using them for queries
Cons
- If using Aurora Serverles v2 one thing missing is the possibility to reduce it to 0 ACU
Return on Investment
- We have had zero issues on our site related to database availability since using Aurora
- The avilability of our site has been 100% during the last year
- No more database administration hassell
Other Software Used
Amazon Elastic File System (EFS), Amazon EC2 Auto Scaling, Amazon Elastic Compute Cloud (EC2)
Unveiling Amazon Aurora: Empowering High-Performance Data Management in the Cloud
Use Cases and Deployment Scope
We use Aurora MySQL for the database of Magento 2. This handles the load very fine and is has 100% uptime with low resilience and no packet loss. Moreover we use Aurora for scalability from the Read replicas used for read transactions and scaling the database. The restore in time feature also allows us if we need to restore the database for specific time of the day.
Pros
- 100% Uptime with no packet losses
- Scalability with read replicas
- fully managed database
- Restore Point in Time
- Handel more load than mysql
- Parallel Queries supported
Cons
- Improve Response time
- Add write replica for scaling
- database caching
Return on Investment
- positive - very fast website thus increasing google ranks
- positive - efficient database
- negetive - high cost
Alternatives Considered
Azure SQL Database and Google Cloud SQL
Other Software Used
Azure SQL Database, Google Cloud SQL, Oracle Cloud Infrastructure
