sudo yum install -y mariadb105

CREATE DATABASE IF NOT EXISTS dev;

USE dev;
CREATE TABLE IF NOT EXISTS user (
    id               VARCHAR(255)    NOT NULL,   
    username         VARCHAR(255)    NOT NULL,
    email            VARCHAR(255)    NOT NULL,
    status_message   VARCHAR(255)    NOT NULL,
    PRIMARY KEY (id)
);
ALTER TABLE user ADD INDEX idx_email (email);

SECRET_NAME=$(aws secretsmanager list-secrets --query "SecretList[?Name=='apdev-rds-master-password'].Name" --output text)
MYSQL_USER=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text | jq -r ".username")
MYSQL_PASSWORD=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text | jq -r ".password")
MYSQL_HOST=$(aws rds describe-db-instances --query "DBInstances[?DBInstanceIdentifier=='apdev-rds-instance'].Endpoint.Address" --output text)
mysql -h $MYSQL_HOST -u $MYSQL_USER -P 3307 -p$MYSQL_PASSWORD < init.sql

SECRET_NAME=$(aws secretsmanager list-secrets --query "SecretList[?Name=='apdev-rds-master-password'].Name" --output text)
MYSQL_USER=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text | jq -r ".username")
MYSQL_PASSWORD=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text | jq -r ".password")
MYSQL_HOST=$(aws rds describe-db-instances --query "DBInstances[?DBInstanceIdentifier=='apdev-rds-instance'].Endpoint.Address" --output text)

mysql -h $MYSQL_HOST -u $MYSQL_USER -P 3307 -p$MYSQL_PASSWORD -D dev < load_user.dump

• RDS Max Connection

show variables like '%max_connections%';