AWS-Day7-Assignment
What is RDS? What are the database engine options available in RDS?
Ans:
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
Database engine options available in RDS:
Choose from seven popular engines — Amazon Aurora with MySQL compatibility, Amazon Aurora with PostgreSQL compatibility, MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server — and deploy on-premises with Amazon RDS on AWS Outposts.
What is multi-AZ RDS?
Ans:
In an Amazon RDS Multi-AZ deployment, Amazon RDS automatically creates a primary database (DB) instance and synchronously replicates the data to an instance in a different AZ. When it detects a failure, Amazon RDS automatically fails over to a standby instance without manual intervention.
What are the types of backups in the RDS database?
Amazon RDS provides two different methods for backing up and restoring your DB instance(s) automated backups and database snapshots (DB Snapshots).
Automated Backups:
The automated backup feature of Amazon RDS enables point-in-time recovery of your DB instance. When automated backups are turned on for your DB Instance, Amazon RDS automatically performs a full daily snapshot of your data (during your preferred backup window) and captures transaction logs (as updates to your DB Instance are made).
Database Snapshots:
DB Snapshots are user-initiated and enable you to back up your DB instance in a known state as frequently as you wish, and then restore to that specific state at any time. DB Snapshots can be created with the AWS Management Console, CreateDBSnapshot API, or create-db-snapshot command and are kept until you explicitly delete them.
Is it possible to stop a RDS instance, how can I do that?
Ans:
Console:
To stop a DB instance
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the navigation pane, choose Databases, and then choose the DB instance that you want to stop.
For Actions, choose Stop temporarily.
In the Stop DB instance temporarily window, select the acknowledgment that the DB instance will restart automatically after 7 days.
(Optional) Select Save the DB instance in a snapshot and enter the snapshot name for Snapshot name. Choose this option if you want to create a snapshot of the DB instance before stopping it.
Choose Stop temporarily to stop the DB instance, or choose Cancel to cancel the operation.
What is meant by parameter groups and Option groups in rds? And what is the use of it?
Ans:
Parameter Groups:
Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.
You manage your database configuration by associating your DB instances and Multi-AZ DB clusters with parameter groups. Amazon RDS defines parameter groups with default settings. You can also define your own parameter groups with customized settings.
Option Groups:
Some DB engines offer additional features that make it easier to manage data and databases, and to provide additional security for your database. Amazon RDS uses option groups to enable and configure these features. An option group can specify features, called options, that are available for a particular Amazon RDS DB instance. Options can have settings that specify how the option works. When you associate a DB instance with an option group, the specified options and option settings are enabled for that DB instance.
What is the difference between SQL and NoSQL databases? Give an example for both types.
Create an RDS MS-SQL instance and connect to the instance using SQL Server Management Studio.
Ans:
We have created our AWS RDS instance. Now we have to connect our local SQL Server database.
Now we can see the RDS instance in our Management Studio**.**
When we go to the Monitoring section of our instance(database-1 -> Monitoring) in AWS Console we can see the connection established was recorded.
Create an Aurora MySQL instance and connect to the instance using SQL workbench.
Create a DynamoDB table and check how the pricing works for DynamoDB.
What are the other Database type options available in AWS other than RDS, and DynamoDB? Describe each of these.
Ans:
Compare AWS database services
What is ElasticCache. Why is it used?
Ans:
Amazon ElastiCache is a web service that makes it easy to deploy and run Memcached or Redis protocol-compliant server nodes in the cloud. Amazon ElastiCache improves the performance of web applications by allowing you to retrieve information from a fast, managed, in-memory system, instead of relying entirely on slower disk-based databases.
Which engines does Amazon ElastiCache support?
Ans:
Amazon ElastiCache supports two major open-source in-memory caching engines: Memcached and Redis.
ElastiCache users typically select between the two caching engines, depending on the design of the corresponding application.
Redis and Memcached are popular, open-source, in-memory data stores. Although they are both easy to use and offer high performance, there are important differences to consider when choosing an engine. Memcached is designed for simplicity while Redis offers a rich set of features that make it effective for a wide range of use cases. Understand your requirements and what each engine offers to decide which solution better meets your needs.
Architecture
Redis uses a single core and shows better performance than Memcached in storing small datasets when measured in terms of cores.
Memcached implements a multi-threaded architecture by utilizing multiple cores. Therefore, for storing larger datasets, Memcached can perform better than Redis.
Create an RDS instance with WordPress.
Design a DynamoDB database for a Mobile App.
Amazon DynamoDB Restaurant Review App.
