If you want to run a relational database on AWS, you first need to select how you want to run it: the unmanaged way or the managed way.The paradigm of managed versus unmanaged services is similar to the Shared Responsibility Model. The Shared Responsibility Model distinguishes between AWS\u2019s and the customer\u2019s security responsibility over a service. Similarly, managed versus unmanaged can be understood as a tradeoff between convenience and control.<\/span><\/span><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/main><\/div><\/div><\/div><\/section><\/div><\/div><\/div><\/div><\/p>\n\n\n\n If you host a database on Amazon EC2, AWS takes care of implementing and maintaining the physical infrastructure and hardware and installing the operating system of the EC2 instance. However, you\u2019re still responsible for managing the EC2 instance, managing the database on that host, optimizing queries, and managing customer data.<\/p>\n\n\n\n These services provide the setup of both the EC2 instance and the database, and they provide systems for high availability, scalability, patching, and backups. However, you\u2019re still responsible for database tuning, query optimization, and of course, ensuring that your customer data is secure.<\/p>\n\n\n\n Amazon RDS enables you to create and manage relational databases in the cloud without the operational burden of traditional database management. <\/p>\n\n\n\n Amazon RDS supports most of the popular relational database management systems, ranging from commercial options, open source options, and even an AWS-specific option. Here are the supported Amazon RDS engines.<\/p>\n\n\n\n A DB instance can contain multiple databases with the same engine, and each database can contain multiple tables. Underneath the DB instance is an EC2 instance. However, this instance is managed through the Amazon RDS console instead of the Amazon EC2 console. <\/span><\/span>When you create your DB instance, you choose the instance type and size. Amazon RDS supports three instance families.<\/p>\n\n\n\n The DB instance you choose affects how much processing power and memory it has. Not all of the options are available to you, depending on the engine that you choose. You can find more information about the DB instance types in the resources section of this unit. Much like a regular EC2 instance, the DB instance uses Amazon Elastic Block Store (EBS) volumes as its storage layer. You can choose between three types of EBS volume storage.<\/p>\n\n\n\n When you create a DB instance, you select the Amazon Virtual Private Cloud (VPC) that your databases will live in. Then, you select the subnets that you want the DB instances to be placed in. The subnets you add should be private so they don\u2019t have a route to the internet gateway. This ensures your DB instance, and the data inside of it, can only be reached by the backend. Network ACLs and security groups allow you to dictate the flow of traffic. If you want to restrict what actions and resources your employees can access, you can use IAM policies.<\/p>\n\n\n\n Automatic Backups<\/strong><\/p>\n\n\n\n Automated backups are turned on by default. This backs up your entire DB instance, and your transaction logs. When you create your DB instance, you set a backup window that is the period of time that automatic backups occur. You can retain your automated backups between 0 and 35 days.<\/p>\n\n\n\n Manual Snapshots<\/strong><\/p>\n\n\n\n If you want to keep your automated backups longer than 35 days, use manual snapshots. Manual snapshots are similar to taking EBS snapshots, except you manage them in the RDS console. These are backups that you can initiate at any time, that exist until you delete them.<\/p>\n\n\n\n Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. DynamoDB lets you offload the administrative burdens of operating and scaling a distributed database so that you don’t have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.<\/p>\n\n\n\n DynamoDB automatically spreads the data and traffic for your tables over a sufficient number of servers to handle your throughput and storage requirements, while maintaining consistent and fast performance. All of your data is stored on solid-state disks (SSDs) and is automatically replicated across multiple Availability Zones in an AWS Region, providing built-in high availability and data durability.<\/p>\n\n\n\n In DynamoDB, tables, items, and attributes are the core components that you work with. A table<\/em> is a collection of items<\/em>, and each item is a collection of attributes<\/em>. DynamoDB uses primary keys to uniquely identify each item in a table and secondary indexes to provide more querying flexibility.<\/p>\n\n\n\n The following are the basic DynamoDB components:<\/p>\n\n\n\n AWS has a variety of different database options for different use cases. Use the table below to get a quick look at the AWS database portfolio.<\/p>\n\n\n\nUnmanaged Databases<\/h2>\n\n\n\n
![\"\"\/](\"https:\/\/d3c33hcgiwev3.cloudfront.net\/imageAssetProxy.v1\/OonHLsR5RQif5MJkTfbIMw_0aa67d834275415d80ddd2de009c5ef1_image.png?expiry=1687910400000&hmac=_Dcpg-OPa__r-5G75khYzPr4h0aFP0xP_cNdC562eQw\")
<\/figure>\n\n\n\nManaged Database<\/h2>\n\n\n\n
![\"\"\/](\"https:\/\/d3c33hcgiwev3.cloudfront.net\/imageAssetProxy.v1\/aSMN48saSWKSPaVJaQ7pow_922b2935f3dd441cb37409c4562a64f1_image.png?expiry=1687910400000&hmac=H47ZAMylh--2XMSEovEPBDQHhMY-iV2D97qWEhBCwgM\")
<\/figure>\n\n\n\nAmazon RDS<\/h2>\n\n\n\n
\n
DB Instances<\/h3>\n\n\n\n
\n
\n
Secure Amazon RDs<\/h3>\n\n\n\n
Access to the DB instance can be further restricted by using network access control lists (ACLs) and security groups. With these firewalls, you can control, at a granular level, what type of traffic you want to allow into your database. Using these controls provide layers of security for your infrastructure.<\/p>\n\n\n\nBack Up of your Data<\/h3>\n\n\n\n
Amazon DynamoDB<\/h2>\n\n\n\n
Core Components of Amazon DynamoDB<\/h3>\n\n\n\n
\n
Overview of AWS Database Services<\/h2>\n\n\n\n