DBaaS Unleashed: Exploring DyanamoDB & RDS in the AWS

Database As A Service:
Database as a service (DBaaS) is a cloud computing managed service offering that provides access to a database without requiring the setup of physical hardware, the installation of software, or the need to configure the database. Most maintenance and administrative tasks are handled by the service provider, freeing up users to quickly benefit from using the database. DBaaS uses The DBaaS model is ideal for small to medium-sized businesses that do not have well-staffed IT departments. Offloading the service and maintenance of the database to the DBaaS provider enables small to medium-sized businesses to implement applications and systems that they otherwise could not afford to build and support on-premises. Workloads involving data with stringent regulatory requirements may not be suitable for a DBaaS model. Furthermore, mission-critical applications that require optimal performance and 99.999% of uptime may be better suited for on-premises implementation. This is not to say that mission-critical workloads cannot run on cloud services, but much of the DBaaS adoption to date has been for less crucial applications, such as development and pilot programs.

Detailed Implementation Steps: DynamoDB

Step 1: Select Database in AWS Services

1. Log in to the AWS Management Console.
2. Navigate to Services in the top menu.
3. Under the Database category, select DynamoDB.
   • DynamoDB is a fully managed NoSQL database service designed for high availability and scalability.

---

Step 2: Go to DynamoDB Dashboard

1. Once inside DynamoDB, you'll see the dashboard where you can manage tables, monitor usage, and configure settings.
2. Familiarize yourself with the key sections, such as Tables, Metrics, and Global Tables, for future use.

---

Step 3: Create a Table

1. Click "Create Table" to open the table creation wizard.
2. Provide a Table Name (e.g., MyFirstTable). This must be unique within your AWS account.
3. Define the Primary Key:
   • Partition Key: The unique identifier for each item (e.g., UserID).
   • Sort Key (Optional): Used to sort items with the same Partition Key (e.g., OrderDate).
4. Configure additional settings (optional):
   • Provisioned Throughput: Choose between "On-Demand" or "Provisioned" based on expected traffic.
   • Encryption: Enable encryption at rest for enhanced security.
   • Global Secondary Indexes (GSIs) or Local Secondary Indexes (LSIs) can be added for optimized querying.
5. Click "Create Table" to initiate table creation. It may take a few moments for the table to be ready.

---

Step 4: Confirm Table Creation

1. Once the table is created, it will appear in the Tables list.
2. Click on the table name to view its details, including schema, items, metrics, and indexes.

---

Step 5: Add Items to the Table

1. Navigate to the Items tab within your table.
2. Under Actions, click Create Item.

---

Step 6: Enter Item Data

1. The Create Item interface will open.
2. Enter values for the Partition Key and Sort Key (if applicable).
   • Example: UserID = "12345", OrderDate = "2024-01-01".
3. Add additional attributes as key-value pairs, such as:
   • Name = "John Doe"
   • Email = "[e-mail]"
   • OrderAmount = 150.25
4. Once all required attributes are added, click Save.

---

Step 7: View and Explore Items

1. Go back to the Items tab.
2. You’ll see a list of all items in the table.

---

Step 8: Query and Filter Data

1. In the Explore Items section, use the Scan operation to retrieve all items in the table.
2. Apply filters to refine your results:
   • Example: Filter items where OrderAmount > 100.
3. Use the Query operation for more precise lookups, especially if your table has a Sort Key.

---

Step 9: Monitor Table Metrics

1. Go to the Metrics tab to view performance data, such as read/write capacity usage, throttling events, and storage utilization.
2. Adjust provisioned throughput if necessary to optimize performance.

---

Step 10: Delete the Table

1. Navigate to the DynamoDB dashboard and select the table you created.
2. Under Actions, choose Delete Table.
3. Confirm the deletion in the pop-up dialog.
   • Note: Deleting a table is irreversible and removes all associated data.

---

Detailed Implementation Steps: RDS

Step 11: Navigate to AWS RDS

1. Log in to your AWS Management Console.
2. Click on Services in the top menu bar.
3. Under the Database section, select RDS.
   • RDS (Relational Database Service) is a fully managed service that allows you to easily set up, operate, and scale a relational database in the cloud. It supports multiple database engines, including MySQL, PostgreSQL, Oracle, SQL Server, and Amazon Aurora.

---

Step 12: Create a Database in RDS

1. Once inside the RDS dashboard, click on "Databases" in the left navigation panel.
2. Click on the "Create database" button to start the database creation process.

Step 13: Configure Database Settings

1. Select the Database Engine: Choose the database engine you wish to use (e.g., MySQL, PostgreSQL, MariaDB, etc.).
   • Example: Select MySQL for a relational database setup.

1. Choose a Template: You can choose between:
   • Production: For highly available and scalable environments.
   • Dev/Test: For lower cost, non-production environments.
   • Free Tier: If you're eligible, this option provides limited free usage (1 GB of storage, 20 GB backup).

1. Settings:
   • DB Instance Identifier: Choose a unique name for the instance (e.g., mydatabaseinstance).
   • Master Username: Choose a username for the database administrator (e.g., admin).
   • Master Password: Enter a strong password and confirm it.

1. DB Instance Class: Select the instance size (e.g., db.t3.micro for smaller, cost-effective setups or larger instance sizes for production workloads).
2. Storage:
   • Storage Type: Choose between General Purpose (SSD) or Provisioned IOPS (SSD) for higher performance.
   • Allocated Storage: Set the size for your database storage (e.g., 20 GB).
3. VPC and Network Configuration: Choose the VPC (Virtual Private Cloud) in which the RDS instance will run.
   • Ensure you select the correct subnet group and security group. This will define the network and access permissions for the database.
4. Backup and Maintenance:
   • Set the Backup Retention Period (how long backups are kept).
   • Configure Automated Backups, Multi-AZ Deployment, and Maintenance window if needed.
5. Click on Create Database to start the database creation process.
   • Note: The process may take a few minutes to complete.

---

Step 14: Access the Database Instance

1. After the database instance is created, click on the Database name (e.g., mydatabaseinstance) in the Databases tab to view its details.
2. You can see important information such as:
   • Endpoint: The address you will use to connect to the database.
   • VPC Security Group: The security group that controls access.
   • DB Parameter Group: Configuration settings that define behavior of the database.
3. From this page, you can monitor performance, set up additional options, and access the database instance’s logs.

---

Step 15: Delete the Database Instance

1. To delete the database instance, go to the Databases page in the RDS dashboard.
2. Select the database instance you want to delete (e.g., mydatabaseinstance).
3. From the Actions dropdown menu, select Delete.
   • A confirmation window will appear asking if you’re sure about deleting the instance.
4. You will be prompted to:
   • Create a final snapshot (optional). You can choose to create a snapshot before deletion if you wish to back up the database’s current state.
   • Retain automated backups: You can also choose whether to keep automated backups after deletion.
5. Click Delete to start the deletion process.
   • The deletion of the instance may take some time, depending on the instance size and configuration.

---

Final Notes:

• VPC Settings: Be cautious about the VPC (Virtual Private Cloud) settings as this dictates which resources can access your RDS instance. If your VPC is misconfigured, it may block the connection to your database.
• Backups: Before deleting any instance, ensure that you have backed up any important data, as deleting the database is irreversible if you don’t retain backups.
• Monitoring: After creation, use the CloudWatch monitoring tool to keep track of database performance (CPU usage, memory consumption, etc.).