sudo yum install -y mariadb105
Shell
복사
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);
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 < init.sql
Shell
복사
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
Shell
복사
RDS Max Connection
show variables like '%max_connections%';
SQL
복사