Amazon Relational Database Services- (Amazon RDS)

 

Amazon Relational Database Services 

AWS Relational Database Service is a fully-managed SQL database cloud service that allows to create and operate relational databases. Using RDS you can access your files and database anywhere in a cost-effective and highly scalable way offers a variety of database services which can be launched in minutes with just a few clicks.

AWS database service includes the following services:

1.   Amazon Relational Database Service: It supports five commonly used database engines.  (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating 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.

 2.   Amazon Aurora: It is a MySQL-Compatible relational database with five times performance. It is a relational database, and closed source database engine. It is compatible with MySQL and delivers five times throughput of MySQL on the same hardware. It is also compatible with PostgreSQL and delivers three times throughput of PostgreSQL on the same hardware. Amazon RDS with Aurora manages the time-consuming administrative tasks such as software installation, patching, and backups. The main features of Aurora are fault-tolerant, distributed, a self-healing storage system that auto-scales up to 64 TB per database instance. It provides high-performance, availability, point-in-time recovery, continuous backed up to S3, and replication across three availability zones.

Use cases- SaaS, Gaming, Enterprise Applications etc.

 3.   Amazon DynamoDB: It is a fast and flexible NoSQL database service. DynamoDB is a NoSQL, highly-available, low latency, scalable database that supports both key-value and document store data models. It follows a serverless approach, meaning that it is offered as a service, so the infrastructure is fully managed by AWS and works out-of-the-box with little configuration. This frees the user from managing instances, applying security patches and other infrastructure-related tasks. In addition, pricing can be very reasonable as it follows a pay-per-use model instead of charging for pre-provisioned computing resources.

Unlike most relational databases and also some NoSQL ones like MongoDB, DynamoDB lacks of the concept of instance. This means that the user works on tables directly. Moreover, tables are schema less meaning that the objects stored in a table are not required to have the same attributes, providing more flexibility to the user.

DynamoDB shines when providing high performance for large workloads as it handles read and write throughput independently. Because of this, it is aimed at analytical operations but it can still work as a cheap, quick, low configuration solution for simple CRUD applications.

Use cases- develop platform for large scale gaming, media metadata, consistent shopping experience etc.

4.   Amazon Redshift: It is a petabyte-scale data warehouse service. Amazon Redshift is a fast and fully managed data warehouse service in the cloud. Amazon affirms that the Redshift data warehouse delivers ten times faster performance than other data warehouses utilizing Machine Learning techniques. The Redshift data warehouse can be scaled up to a petabyte or more as per the requirements.

Following are some of the benefits of using Amazon Redshift:

ü  Parallel queries across multiple nodes can be performed

ü  Automatically backed up to Amazon S3

ü  Cost-effective over other data warehouse solutions

ü  Built-in security as Amazon Redshift provides end-to-end encryption and enables users to configure firewall rules

Use cases- Log analysis, Traditional data warehousing, Business applications,

5.   Amazon Elasticache: It is an in-memory cache service with support for Memcached and Redis. Elasticache is a web service used to deploy, operate, and scale an in-memory cache in the cloud. It improves the performance of web applications by allowing you to retrieve information from fast, managed in-memory cache instead of relying entirely on slower disk-based databases.

For example, if you are running an online business, customers continuously asking for the information of a particular product. Instead of front-end going and always asking information for a product, you can cache the data using Elasticache.

Ø  Types of Elasticache:

1.   Mamcache:

·         Memcached is a Memcached-compatible in-memory key-value store service which will be used as a cache.

• It is an easy-to-use, high performance, in-memory data store.
• It can be used as a cache or session store.
• It is mainly used in real-time applications such as Web, Mobile Apps, Gaming, Ad-Tech, and E-Commerce.

Use Cases: Web, Mobile application, gaming etc.

 

2. Redis (Remote Dictionary Server):

• Redis stands for Remote Dictionary Server.
• It is a fast, open-source, and in-memory key-value data store.
• Its response time is in a millisecond, and also serves the millions of requests per second for real-time applications such as Gaming, AdTech, Financial services, Health care, and IoT.
• It is used for caching, session management, gaming, leaderboards, real-time analytics, geospatial, etc.

Use Cases: session management, gaming, leaderboard, real-time analysis etc.

 

Ø  Features of Amazon RDS:

a.  Scalable − Amazon RDS allows to scale the relational database by using AWS Management Console or RDS-specific API. We can increase or decrease your RDS requirements within minutes.

b.   Host replacement − Sometimes these situations occur when the hardware of Amazon RDS fails. There is no need to worry, it will be automatically replaced by Amazon.

c.  Inexpensive − Using Amazon RDS, we pay only for the resources we consume. There is no up-front and long-term commitment.

d. Secure − Amazon RDS provides complete control over the network to access their database and their associated services.

e.   Automatic backups − Amazon RDS backs up everything in the database including transaction logs up to last five minutes and also manages automatic backup timings.

f.  Software patching − automatically gets all the latest patches for the database software. We can also specify when the software should be patched using DB Engine Version Management.