AWS RDS 인증서 갱신 시 재시동이 필요한 DB 엔진을 알아보자!

2024.06.06

안녕하세요! 클래스메소드 금상원 입니다. 이번 블로그에서는 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 엔진을 사용하고 계신 분들은 다운타임 과 같은 문제들을 검토하는데에 도움이 되었으면 좋겠습니다.

참고자료