1


aws rds describe-db-engine-versions \
  --engine aurora-mysql \
  --query 'DBEngineVersions[*].EngineVersion' \
  --output table \
  --region <your-region>


aws rds describe-db-engine-versions \
  --engine aurora-mysql \
  --query 'DBEngineVersions[*].EngineVersion' \
  --output table \
  --region ap-northeast-2




-----------------------------
| DescribeDBEngineVersions  |
+---------------------------+
|  5.7.mysql_aurora.2.11.1  |
|  5.7.mysql_aurora.2.11.2  |
|  5.7.mysql_aurora.2.11.3  |
|  5.7.mysql_aurora.2.11.4  |
|  5.7.mysql_aurora.2.11.5  |
|  5.7.mysql_aurora.2.11.6  |
|  5.7.mysql_aurora.2.12.0  |
|  5.7.mysql_aurora.2.12.1  |
|  5.7.mysql_aurora.2.12.2  |
|  5.7.mysql_aurora.2.12.3  |
|  5.7.mysql_aurora.2.12.4  |
|  5.7.mysql_aurora.2.12.5  |
|  5.7.mysql_aurora.2.12.6  |
|  8.0.mysql_aurora.3.04.0  |
|  8.0.mysql_aurora.3.04.1  |
|  8.0.mysql_aurora.3.04.2  |
|  8.0.mysql_aurora.3.04.3  |
|  8.0.mysql_aurora.3.04.4  |
|  8.0.mysql_aurora.3.04.6  |
|  8.0.mysql_aurora.3.08.0  |
|  8.0.mysql_aurora.3.08.1  |
|  8.0.mysql_aurora.3.08.2  |
|  8.0.mysql_aurora.3.09.0  |
|  8.0.mysql_aurora.3.10.0  |
|  8.0.mysql_aurora.3.10.1  |
|  8.0.mysql_aurora.3.10.2  |
|  8.0.mysql_aurora.3.10.3  |
|  8.0.mysql_aurora.3.10.4  |
|  8.0.mysql_aurora.3.11.1  |
|  8.0.mysql_aurora.3.12.0  |


추천: 3.04.6 (기존 3.05.2와 기능 유사, LTS) 또는 3.10.4 (최신 LTS)




2

# <AuroraWriter-ID> 확인법

aws rds describe-db-clusters \
  --query 'DBClusters[*].DBClusterMembers[*].[DBInstanceIdentifier,IsClusterWriter]' \
  --output table




<ClusterID>  확인법


aws cloudformation describe-stack-resources \
  --stack-name <스택이름> \
  --query "StackResources[?ResourceType=='AWS::RDS::DBCluster'].[LogicalResourceId,PhysicalResourceId]" \
  --output table




전체 목록 확인

aws cloudformation list-stacks \
  --stack-status-filter CREATE_COMPLETE \
  --query 'StackSummaries[*].[StackName,CreationTime]' \
  --output table





3

aws rds delete-db-instance \
  --db-instance-identifier au13-aurorawriter-ededozkhjaq5 \
  --skip-final-snapshot



aws rds describe-db-clusters --db-cluster-identifier au13-auroracluster-l55g2ozrfvve \
  --query 'DBClusters[0].{Status:Status,Members:DBClusterMembers}'