Question

How can I provision a relational database using Amazon RDS?

Answer 1

Here's an example code snippet to provision an Amazon RDS database using Boto3:

import boto3

# Create a new RDS client
rds = boto3.client('rds')

# Provision a new RDS database instance
response = rds.create_db_instance(
    DBInstanceIdentifier='my-db-instance',
    Engine='mysql',  # Specify the database engine
    DBInstanceClass='db.t2.micro',  # Specify the instance type
    MasterUsername='admin',
    MasterUserPassword='password',
    AllocatedStorage=20,  # Specify the storage capacity (in GB)
    MultiAZ=False,  # Specify if Multi-AZ deployment is enabled
    DBName='mydatabase'
)

# Print the endpoint of the newly provisioned database
print("Database Endpoint:", response['DBInstance']['Endpoint']['Address'])