AWS Database Services
Amazon Web Services provides you wide range of fully managed Database services to choose the best one that suits your requirement. Ranging from Relational, SQL, OLTP, OLA P, and many other usage-specific databases.
In this article, we will have a detailed discussion on each of these services.
AWS Database services are broadly classified based on the Database types they are:
- Relational.
- No-SQL (Key-Value).
- In-memory.
- Document.
- Wide Column.
- Graph.
- Time series.
- Ledger.
Relational Database - A relational database is a collection of data items with pre-defined relationships between them. These items are organized as a set of tables with columns and rows. Tables are used to hold information about the objects to be represented in the database.
Use cases of this Database are Traditional applications, ERP, CRM, e-commerce.
AWS has Amazon Aurora, Amazon RDS, and Amazon Redshift as their Relational Database Services.
Amazon Aroura - Amazon Aroura is a fully managed, cost-efficient, and intelligent relational database service that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.
Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost.
Amazon RDS - Amazon RDS is mainly focused on automating your time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security, and compatibility they need. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon RDS.
Amazon RDS is easy to administer, Highly scalable, Available and durable, Fast, Secure, and inexpensive.
Amazon RDS database engines are available on Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.
Amazon Redshift - Redshift is the best Database service for your Analysing usage. With Redshift, you can query and combine exabytes of structured and semi-structured data across your data warehouse, operational database, and data lake using standard SQL. Redshift allows you to save the results to S3 Data lake so that you can do additional analytics from other analytics services like Amazon EMR, Amazon Athena, and Amazon SageMaker.
Amazon Redshift has up to 3x better price-performance than other cloud data warehouses, and the price-performance advantage improves as your data warehouse grows from gigabytes to exabytes.
Use cases are Business intelligence, Operational analytics on events, Data as a service, and Predictive analytics.
No-SQL - Amazon DynamoDB
It is a Key-value No-SQL database that delivers single-digit millisecond performance at any scale.
It is a fully managed, multi-region, multi-active, durable database with built-in security, backup and restores, and in-memory caching for internet-scale applications. DynamoDB can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second.
This has benefits such as Performance at scale, servers to manage, and Enterprise ready.
Amazon ElastiCache for Memcached
It is a Memcached-compatible in-memory key-value store service that can be used as a cache or a data store. It delivers the performance, ease of use, and simplicity of Memcached. ElastiCache for Memcached is fully managed, scalable, and secure - making it an ideal candidate for use cases where frequently accessed data must be in-memory. It is a popular choice for use cases such as Web, Mobile Apps, Gaming, Ad-Tech, and E-Commerce.
Elasticache gives an extreme performance, secure and hardened, Memcached-compatible, easily scalable, fully managed and auto discoverable.
Look out for the use cases of AWS Database below.
In our upcoming articles, we will have a detailed study on how to set up the required Database and use it in your organization.
— — — — — — — — — — — — — — — — — — — — — — — — — — -
Follow my page to keep updated with new AWS Services and releases.
@ yogendrahj.medium.com
LEARN and BE CURIOUS!!!!!
Happy Learning,
Yogendra
