upgradeCloudMysqlDbEngineVersion

Prev Next
This content is currently unavailable in English. You are viewing the default (Korean) version.

VPC 환경에서 이용 가능합니다.

Cloud DB for MySQL 인스턴스의 DB 엔진 버전을 업그레이드합니다.

요청

요청 형식을 설명합니다. 요청 형식은 다음과 같습니다.

메서드 URI
GET, POST /upgradeCloudMysqlDbEngineVersion

요청 헤더

Cloud DB for MySQL (VPC) API에서 공통으로 사용하는 헤더에 대한 자세한 내용은 Cloud DB for MySQL (VPC) 요청 헤더를 참조해 주십시오.

요청 파라미터

파라미터에 대한 설명은 다음과 같습니다.

필드 타입 필수 여부 설명
regionCode String Optional 리전 코드
  • DB 엔진 버전을 업그레이드할 Cloud DB for MySQL 인스턴스의 리전 코드
  • getRegionList를 통해 확인
  • getRegionList 조회 결과의 첫 번째 리전(기본값)
cloudMysqlInstanceNo String Required Cloud DB for MySQL 인스턴스 번호
cloudMysqlImageProductCode String Required Cloud DB for MySQL 이미지 상품 코드
engineVersionCode String Conditional 엔진 버전 코드
  • 업그레이드할 DB 엔진의 버전 코드
  • getCloudMysqlImageProductList를 통해 확인
  • 미입력 시 현재 제공 중인 최신 버전으로 생성
isMajorVersionUpgrade Boolean Optional 메이저 버전 업그레이드 여부
  • true | false (기본값)
    • true: 메이저 버전 업그레이드를 수행 (예: MySQL 5.7.40 → 8.0.32)
    • false: 마이너 버전 업그레이드만 수행 (예: MySQL 8.0.34 → 8.0.40)
responseFormatType String Optional 응답 결과의 형식
  • xml (기본값) | json

요청 예시

요청 예시는 다음과 같습니다.

curl --location --request GET 'https://ncloud.apigw.ntruss.com/vmysql/v2/upgradeCloudMysqlDbEngineVersion
?regionCode=KR
&cloudMysqlInstanceNo=****890
&cloudMysqlImageProductCode=SW.VMYSL.OS.LNX64.ROCKY.0810.MYSQL.B050
&engineVersionCode=MYSQL8.0.40
&isMajorVersionUpgrade=false
--header 'x-ncp-apigw-timestamp: {Timestamp}'
--header 'x-ncp-iam-access-key: {Access Key}'
--header 'x-ncp-apigw-signature-v2: {API Gateway Signature}'

응답

응답 형식을 설명합니다.

응답 상태 코드

네이버 클라우드 플랫폼에서 공통으로 사용하는 응답 상태 코드에 대한 자세한 내용은 Ncloud API 응답 상태 코드를 참조해 주십시오.

응답 예시

응답 예시는 다음과 같습니다.

  • responseFormatType=json인 경우

    {
      "upgradeCloudMysqlDbEngineVersionResponse": {
        "requestId": "eb46ade8-****-****-****-133bcbc382c1",
        "returnCode": "0",
        "returnMessage": "success",
        "totalRows": 1,
        "cloudMysqlInstanceList": [
          {
            "cloudMysqlInstanceNo": "****890",
            "cloudMysqlServiceName": "test-****",
            "cloudMysqlInstanceStatusName": "upgrading",
            "cloudMysqlInstanceStatus": {
              "code": "CREAT",
              "codeName": "CLOUD DATABASE(VPC) Created State"
            },
            "cloudMysqlInstanceOperation": {
              "code": "UPGD",
              "codeName": "CLOUD DATABASE(VPC) Upgrade OP"
            },
            "cloudMysqlImageProductCode": "SW.VMYSL.OS.LNX64.ROCKY.0810.MYSQL.B050",
            "engineVersion": "MYSQL8.0.40",
            "license": {
              "code": "GPL",
              "codeName": "General Public License"
            },
            "cloudMysqlPort": 13306,
            "isHa": true,
            "isMultiZone": true,
            "isBackup": true,
            "backupFileRetentionPeriod": 10,
            "backupTime": "02:00",
            "generationCode": "G2",
            "createDate": "2024-05-23T11:25:09+0900",
            "accessControlGroupNoList": [],
            "cloudMysqlConfigList": [],
            "cloudMysqlServerInstanceList": [
              {
                "cloudMysqlServerName": "test-****-001-e04",
                "cloudMysqlServerRole": {
                  "code": "M",
                  "codeName": "Master"
                },
                "cloudMysqlServerInstanceStatusName": "settingUp",
                "cloudMysqlServerInstanceStatus": {
                  "code": "RUN",
                  "codeName": "CLOUD DATABASE(VPC) Server Running State"
                },
                "cloudMysqlServerInstanceOperation": {
                  "code": "SETUP",
                  "codeName": "CLOUD DATABASE(VPC) Server Setup OP"
                },
                "cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.SSD.B050.G002",
                "regionCode": "KR",
                "zoneCode": "KR-1",
                "vpcNo": "****83",
                "subnetNo": "****91",
                "isPublicSubnet": true,
                "dataStorageType": {
                  "code": "SSD",
                  "codeName": "SSD"
                },
                "isStorageEncryption": true,
                "dataStorageSize": 10737418240,
                "cpuCount": 2,
                "memorySize": 8589934592,
                "createDate": "2024-05-23T11:25:09+0900"
              },
              {
                "cloudMysqlServerName": "test-****-002-e05",
                "cloudMysqlServerRole": {
                  "code": "H",
                  "codeName": "Standby Master"
                },
                "cloudMysqlServerInstanceStatusName": "settingUp",
                "cloudMysqlServerInstanceStatus": {
                  "code": "RUN",
                  "codeName": "CLOUD DATABASE(VPC) Server Running State"
                },
                "cloudMysqlServerInstanceOperation": {
                  "code": "SETUP",
                  "codeName": "CLOUD DATABASE(VPC) Server Setup OP"
                },
                "cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.SSD.B050.G002",
                "regionCode": "KR",
                "zoneCode": "KR-2",
                "vpcNo": "****83",
                "subnetNo": "****93",
                "isPublicSubnet": true,
                "dataStorageType": {
                  "code": "SSD",
                  "codeName": "SSD"
                },
                "isStorageEncryption": true,
                "dataStorageSize": 10737418240,
                "cpuCount": 2,
                "memorySize": 8589934592,
                "createDate": "2024-05-23T11:25:09+0900"
              }
            ]
          }
        ]
      }
    }
    
  • responseFormatType=xml인 경우 (기본값)

    <?xml version="1.0" encoding="UTF-8"?>
    <upgradeCloudMysqlDbEngineVersionResponse>
      <requestId>eb46ade8-****-****-****-133bcbc382c1</requestId>
      <returnCode>0</returnCode>
      <returnMessage>success</returnMessage>
      <totalRows>1</totalRows>
      <cloudMysqlInstanceList>
        <cloudMysqlInstance>
          <cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
          <cloudMysqlServiceName>test-****</cloudMysqlServiceName>
          <cloudMysqlInstanceStatusName>upgrading</cloudMysqlInstanceStatusName>
          <cloudMysqlInstanceStatus>
            <code>CREAT</code>
            <codeName>CLOUD DATABASE(VPC) Created State</codeName>
          </cloudMysqlInstanceStatus>
          <cloudMysqlInstanceOperation>
            <code>UPGD</code>
            <codeName>CLOUD DATABASE(VPC) Upgrade OP</codeName>
          </cloudMysqlInstanceOperation>
          <cloudMysqlImageProductCode>SW.VMYSL.OS.LNX64.ROCKY.0810.MYSQL.B050</cloudMysqlImageProductCode>
          <engineVersion>MYSQL8.0.40</engineVersion>
          <license>
            <code>GPL</code>
            <codeName>General Public License</codeName>
          </license>
          <cloudMysqlPort>13306</cloudMysqlPort>
          <isHa>true</isHa>
          <isMultiZone>true</isMultiZone>
          <isBackup>true</isBackup>
          <backupFileRetentionPeriod>10</backupFileRetentionPeriod>
          <backupTime>02:00</backupTime>
          <generationCode>G2</generationCode>
          <createDate>2024-05-23T11:25:09+0900</createDate>
          <accessControlGroupNoList />
          <cloudMysqlConfigList />
          <cloudMysqlServerInstanceList>
            <cloudMysqlServerInstance>
              <cloudMysqlServerName>test-****-001-e04</cloudMysqlServerName>
              <cloudMysqlServerRole>
                <code>M</code>
                <codeName>Master</codeName>
              </cloudMysqlServerRole>
              <cloudMysqlServerInstanceStatusName>settingUp</cloudMysqlServerInstanceStatusName>
              <cloudMysqlServerInstanceStatus>
                <code>RUN</code>
                <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
              </cloudMysqlServerInstanceStatus>
              <cloudMysqlServerInstanceOperation>
                <code>SETUP</code>
                <codeName>CLOUD DATABASE(VPC) Server Setup OP</codeName>
              </cloudMysqlServerInstanceOperation>
              <cloudMysqlProductCode>SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002</cloudMysqlProductCode>
              <regionCode>KR</regionCode>
              <zoneCode>KR-1</zoneCode>
              <vpcNo>****83</vpcNo>
              <subnetNo>****91</subnetNo>
              <isPublicSubnet>true</isPublicSubnet>
              <dataStorageType>
                <code>SSD</code>
                <codeName>SSD</codeName>
              </dataStorageType>
              <isStorageEncryption>true</isStorageEncryption>
              <dataStorageSize>10737418240</dataStorageSize>
              <cpuCount>2</cpuCount>
              <memorySize>8589934592</memorySize>
              <createDate>2024-05-23T11:25:09+0900</createDate>
            </cloudMysqlServerInstance>
            <cloudMysqlServerInstance>
              <cloudMysqlServerName>test-****-002-e05</cloudMysqlServerName>
              <cloudMysqlServerRole>
                <code>H</code>
                <codeName>Standby Master</codeName>
              </cloudMysqlServerRole>
              <cloudMysqlServerInstanceStatusName>settingUp</cloudMysqlServerInstanceStatusName>
              <cloudMysqlServerInstanceStatus>
                <code>RUN</code>
                <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
              </cloudMysqlServerInstanceStatus>
              <cloudMysqlServerInstanceOperation>
                <code>SETUP</code>
                <codeName>CLOUD DATABASE(VPC) Server Setup OP</codeName>
              </cloudMysqlServerInstanceOperation>
              <cloudMysqlProductCode>SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002</cloudMysqlProductCode>
              <regionCode>KR</regionCode>
              <zoneCode>KR-2</zoneCode>
              <vpcNo>****83</vpcNo>
              <subnetNo>****93</subnetNo>
              <isPublicSubnet>true</isPublicSubnet>
              <dataStorageType>
                <code>SSD</code>
                <codeName>SSD</codeName>
              </dataStorageType>
              <isStorageEncryption>true</isStorageEncryption>
              <dataStorageSize>10737418240</dataStorageSize>
              <cpuCount>2</cpuCount>
              <memorySize>8589934592</memorySize>
              <createDate>2024-05-23T11:25:09+0900</createDate>
            </cloudMysqlServerInstance>
          </cloudMysqlServerInstanceList>
        </cloudMysqlInstance>
      </cloudMysqlInstanceList>
    </upgradeCloudMysqlDbEngineVersionResponse>