From Development to Deployment: Choosing the Right Database Strategy

# Check for a default VPC
VPC_ID=$(aws ec2 describe-vpcs --filters "Name=isDefault,Values=true" --query "Vpcs[0].VpcId" --output text)
echo "Default VPC ID: $VPC_ID"

# Create security group for RDS database
RDS_SECURITY_GROUP_NAME="rds-db-sg"
RDS_SECURITY_GROUP_ID=$(aws ec2 create-security-group \
    --group-name $RDS_SECURITY_GROUP_NAME \
    --description "Security group for RDS database access" \
    --vpc-id $VPC_ID \
    --query "GroupId" --output text)
echo "Created RDS security group: $RDS_SECURITY_GROUP_ID"

# Create security group for EC2 bastion host
EC2_SECURITY_GROUP_NAME="ec2-bastion-sg"
EC2_SECURITY_GROUP_ID=$(aws ec2 create-security-group \
    --group-name $EC2_SECURITY_GROUP_NAME \
    --description "Security group for EC2 bastion host" \
    --vpc-id $VPC_ID \
    --query "GroupId" --output text)
echo "Created EC2 security group: $EC2_SECURITY_GROUP_ID"

DB_INSTANCE_ID="mydb-tutorial"
aws rds create-db-instance \
    --db-instance-identifier $DB_INSTANCE_ID \
    --db-instance-class db.t3.micro \
    --engine mysql \
    --master-username adminuser \
    --manage-master-user-password \
    --allocated-storage 20 \
    --vpc-security-group-ids $RDS_SECURITY_GROUP_ID \
    --db-subnet-group-name $DB_SUBNET_GROUP_NAME \
    --backup-retention-period 7 \
    --no-publicly-accessible \
    --no-multi-az
echo "DB instance creation initiated: $DB_INSTANCE_ID"

# Create user data script to install MySQL client
USER_DATA=$(cat << 'EOF'
#!/bin/bash
yum update -y
yum install mysql -y
echo "MySQL client installation completed" > /tmp/mysql-install.log
EOF
)

# Launch the EC2 instance
INSTANCE_ID=$(aws ec2 run-instances \
    --image-id $AMI_ID \
    --count 1 \
    --instance-type t2.micro \
    --key-name $KEY_NAME \
    --security-group-ids $EC2_SECURITY_GROUP_ID \
    --subnet-id $SUBNET_ID \
    --associate-public-ip-address \
    --user-data "$USER_DATA" \
    --tag-specifications 'ResourceType=instance,Tags=[{Key=Name,Value=RDS-Bastion-Host}]' \
    --query "Instances[0].InstanceId" \
    --output text)
echo "Launched EC2 bastion host: $INSTANCE_ID"


-- Create a test database
CREATE DATABASE testdb;

-- Use the test database
USE testdb;

-- Create a test table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert some test data
INSERT INTO users (name, email) VALUES
    ('Alice Johnson', 'alice@example.com'),
    ('Bob Smith', 'bob@example.com'),
    ('Carol Davis', 'carol@example.com');

-- Query the data
SELECT * FROM users;

-- Show table structure
DESCRIBE users;

-- Exit MySQL
EXIT;