안녕하세요! 클래스메소드 금상원 입니다. 이번 블로그에서는 AWS RDS의 인증서 버전을 갱신 시 재시동이 필요한 DB 엔진이 무엇인지 알아보는 방법에 대해 소개하도록 하겠습니다.
개요
기존에 AWS RDS의 인증서 버전을「rds-ca-2019」을 사용 중인 분들께서는 인증서의 유효기간이 2024년8월22일에 만료되기 때문에 인증서 갱신이 필요합니다.
하지만 갱신 시 AWS RDS 를 재시동 해야 하는 DB 엔진버전이 있기 때문에 다운타임을 대비하기 위해 미리 알아보는 방법을 알아보겠습니다.
재시동이 필요한 DB 엔진버전 알아보기
aws rds describe-db-engine-versions \
--query "DBEngineVersions[?SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
위의 명령어를 입력하면 재시동이 필요한 DB 엔진이 나타납니다.
2024년06월06일 검색결과 재시동이 필요한 DB 엔진은 아래의「재시동이 필요한 DB 엔진 확인해 보기」를 클릭하여 확인해 주세요.
확인 방법으로는「command+f」나「ctrl+f」를 이용하여 DB 엔진 명을 검색해서 찾으시면 편리 합니다.
재시동이 필요한 DB 엔진 확인해 보기
[
[
"aurora-mysql",
"5.7.mysql_aurora.2.11.4",
"Aurora MySQL"
],
[
"docdb",
"3.6.0",
"Amazon DocumentDB (with MongoDB compatibility)"
],
[
"docdb",
"4.0.0",
"Amazon DocumentDB (with MongoDB compatibility)"
],
[
"docdb",
"5.0.0",
"Amazon DocumentDB (with MongoDB compatibility)"
],
[
"custom-sqlserver-ee",
"15.00.4073.23.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"15.00.4249.2.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"15.00.4261.1.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"15.00.4312.2.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"15.00.4322.2.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"15.00.4345.5.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-ee",
"16.00.4085.2.v1",
"Microsoft SQL Server Enterprise Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4073.23.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4249.2.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4261.1.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4312.2.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4322.2.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"15.00.4345.5.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-se",
"16.00.4085.2.v1",
"Microsoft SQL Server Standard Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4073.23.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4249.2.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4261.1.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4312.2.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4322.2.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"15.00.4345.5.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"custom-sqlserver-web",
"16.00.4085.2.v1",
"Microsoft SQL Server Web Edition for custom RDS"
],
[
"db2-ae",
"11.5.9.0.sb00000000.r1",
"Db2 Advanced Edition"
],
[
"db2-ae",
"11.5.9.0.sb00039210.r1",
"Db2 Advanced Edition"
],
[
"db2-ae",
"11.5.9.0.sb00039340.r1",
"Db2 Advanced Edition"
],
[
"db2-ae",
"11.5.9.0.sb00040222.r1",
"Db2 Advanced Edition"
],
[
"db2-ae",
"11.5.9.0.sb00040226.r1",
"Db2 Advanced Edition"
],
[
"db2-se",
"11.5.9.0.sb00000000.r1",
"Db2 Standard Edition"
],
[
"db2-se",
"11.5.9.0.sb00039210.r1",
"Db2 Standard Edition"
],
[
"db2-se",
"11.5.9.0.sb00039340.r1",
"Db2 Standard Edition"
],
[
"db2-se",
"11.5.9.0.sb00040222.r1",
"Db2 Standard Edition"
],
[
"db2-se",
"11.5.9.0.sb00040226.r1",
"Db2 Standard Edition"
],
[
"neptune",
"1.1.0.0",
"neptune"
],
[
"neptune",
"1.1.1.0",
"neptune"
],
[
"neptune",
"1.2.0.0",
"neptune"
],
[
"neptune",
"1.2.0.1",
"neptune"
],
[
"neptune",
"1.2.0.2",
"neptune"
],
[
"neptune",
"1.2.1.0",
"neptune"
],
[
"neptune",
"1.2.1.1",
"neptune"
],
[
"neptune",
"1.3.0.0",
"neptune"
],
[
"neptune",
"1.3.1.0",
"neptune"
],
[
"aurora-postgresql",
"13.12",
"Aurora (PostgreSQL)"
],
[
"mysql",
"5.7.44",
"MySQL Community Edition"
],
[
"mysql",
"5.7.44-rds.20240408",
"MySQL Community Edition"
],
[
"sqlserver-ee",
"13.00.6300.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"13.00.6419.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"13.00.6430.49.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"13.00.6435.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3281.6.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3294.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3356.20.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3381.3.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3401.7.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3421.10.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3451.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3460.9.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"14.00.3465.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4043.16.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4073.23.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4153.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4198.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4236.7.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4312.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4316.3.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4322.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4335.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4345.5.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4355.3.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"15.00.4365.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4085.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4095.4.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4105.2.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4115.5.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4120.1.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ee",
"16.00.4125.3.v1",
"Microsoft SQL Server Enterprise Edition"
],
[
"sqlserver-ex",
"13.00.6300.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"13.00.6419.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"13.00.6430.49.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"13.00.6435.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3281.6.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3294.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3356.20.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3381.3.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3401.7.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3421.10.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3451.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3460.9.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"14.00.3465.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4043.16.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4073.23.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4153.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4198.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4236.7.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4312.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4316.3.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4322.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4335.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4345.5.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4355.3.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"15.00.4365.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4085.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4095.4.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4105.2.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4115.5.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4120.1.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-ex",
"16.00.4125.3.v1",
"Microsoft SQL Server Express Edition"
],
[
"sqlserver-se",
"13.00.6300.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"13.00.6419.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"13.00.6430.49.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"13.00.6435.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3281.6.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3294.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3356.20.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3381.3.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3401.7.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3421.10.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3451.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3460.9.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"14.00.3465.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4043.16.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4073.23.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4153.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4198.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4236.7.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4312.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4316.3.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4322.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4335.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4345.5.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4355.3.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"15.00.4365.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4085.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4095.4.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4105.2.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4115.5.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4120.1.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-se",
"16.00.4125.3.v1",
"Microsoft SQL Server Standard Edition"
],
[
"sqlserver-web",
"13.00.6300.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"13.00.6419.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"13.00.6430.49.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"13.00.6435.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3281.6.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3294.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3356.20.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3381.3.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3401.7.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3421.10.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3451.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3460.9.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"14.00.3465.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4043.16.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4073.23.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4153.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4198.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4236.7.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4312.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4316.3.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4322.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4335.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4345.5.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4355.3.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"15.00.4365.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4085.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4095.4.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4105.2.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4115.5.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4120.1.v1",
"Microsoft SQL Server Web Edition"
],
[
"sqlserver-web",
"16.00.4125.3.v1",
"Microsoft SQL Server Web Edition"
]
]
(추가로)특정 DB 엔진만 검색하고 싶은 경우
특정 엔진만 검색하여 확인하고 싶으신 분들은아래의 명령어를 이용해 주세요.
아래의 명령어 에서「엔진명」부분에 찾으시는 DB 엔진명을 입력해 주세요.
aws rds describe-db-engine-versions \
--query "DBEngineVersions[?Engine==\`엔진명\`&&SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
예) aurora-mysql DB 엔진명으로 검색하는 경우
aws rds describe-db-engine-versions \
--query "DBEngineVersions[?Engine==\`aurora-mysql\`&&SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
실행결과
[
[
"aurora-mysql",
"5.7.mysql_aurora.2.11.4",
"Aurora MySQL"
]
]
마무리
이번 블로그를 통해 AWS RDS의 인증서 갱신 시 재시동이 필요한 DB 엔진이 무엇인지 알아보는 방법에 대해 알아보았습니다.
혹시 재시동이 필요한 DB 엔진을 사용하고 계신 분들은 다운타임 과 같은 문제들을 검토하는데에 도움이 되었으면 좋겠습니다.