createCloudMysqlRecoveryInstance
    • PDF

    createCloudMysqlRecoveryInstance

    • PDF

    기사 요약

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

    Cloud DB for MySQL 인스턴스에 Recovery 서버 인스턴스를 생성합니다. 백업 파일 또는 특정 시점으로 복원합니다.

    요청

    요청 파라미터

    파라미터타입필수 여부설명제약 사항
    regionCodeStringNCloud DB for MySQL 인스턴스가 존재하는 리전 코드
    - getRegionList 액션을 통해서 획득 가능
    - default: getRegionList 조회 결과의 첫 번째 리전
    -
    cloudMysqlInstanceNoStringYCloud DB for MySQL 인스턴스 번호
    - getCloudMysqlInstanceList 액션을 통해서 획득 가능
    -
    subnetNoStringNSubnet 번호
    - getCloudMysqlTargetSubnetList 액션을 통해서 획득 가능
    - Public 도메인은 Public Subnet에 생성된 DB 서버에서만 이용 신청 가능
    - Cloud DB for MySQL Recovery 서버 인스턴스 생성 이후에 Subnet 이전 불가능
    -
    fileNameStringN백업 파일 이름
    - fileName을 입력하면 recoveryTime의 입력은 받지 않으며 fileName, recoveryTime 중 하나는 반드시 입력되어야 함
    - 백업 파일 복원 시 백업이 완료된 시간으로 복원
    - fileName은 getCloudMysqlBackupDetailList 액션을 통해서 획득 가능
    -
    recoveryTimeStringN시점 복원 시간
    - recoveryTime을 입력하면 fileName의 입력은 받지 않으며 fileName, recoveryTime 중 하나는 반드시 입력되어야 함
    - 입력 가능한 시간은 getCloudMysqlRecoveryTime 액션을 통해서 획득 가능
    yyyy-MM-dd HH:mm
    cloudMysqlRecoveryServerNameStringYCloud DB for MySQL Recovery 서버 인스턴스 이름
    - 호스트명 중복 방지를 위해 임의의 text가 추가로 포함되어 만들어짐
    - 영어 소문자, 숫자, 붙임표( - )로만 구성
    - 첫 글자는 영문자, 마지막 글자는 영문자 또는 숫자만 가능
    - min: 3
    - max: 20
    responseFormatTypeStringN응답 결과의 포맷 타입
    - options: xml | json
    - default: xml
    -

    응답

    응답 바디

    응답 바디는 CloudMysqlInstanceList를 참고해 주십시오.

    예시

    요청 예시

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

    GET {API_URL}/createCloudMysqlRecoveryInstance
    ?regionCode=KR
    &cloudMysqlInstanceNo=****890
    &subnetNo=****91
    &fileName=20210722
    &cloudMysqlRecoveryServerName=test-recovery
    

    응답 예시

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

    응답 결과 포맷 타입(responseFormatType)이 json 일 때

    {
      "createCloudMysqlRecoveryInstanceResponse": {
        "requestId": "ec3580e6-2cc8-487b-bc61-f4ff52ffebc0",
        "returnCode": 0,
        "returnMessage": "success",
        "totalRows": 1,
        "cloudMysqlInstanceList": {
          "cloudMysqlInstance": {
            "cloudMysqlInstanceNo": "****890",
            "cloudMysqlServiceName": "test-****",
            "cloudMysqlInstanceStatusName": "pending",
            "cloudMysqlInstanceStatus": {
              "code": "CREAT",
              "codeName": "CLOUD DATABASE(VPC) Created State"
            },
            "cloudMysqlInstanceOperation": {
              "code": "NULL",
              "codeName": "CLOUD DATABASE(VPC) Null OP"
            },
            "cloudMysqlImageProductCode": "SW.VDBAS.DBAAS.LNX64.CNTOS.0708.MYSQL.5732.B050",
            "engineVersion": "MYSQL5.7.32",
            "license": {
              "code": "GPL",
              "codeName": "General Public License"
            },
            "cloudMysqlPort": 13306,
            "isHa": true,
            "isMultiZone": true,
            "isBackup": true,
            "backupFileRetentionPeriod": 10,
            "backupTime": "02:00",
            "generationCode": "G2",
            "createDate": "2021-05-27T18:00:00+0900",
            "accessControlGroupNoList": [
              "****58"
            ],
            "cloudMysqlConfigList": [
                "autocommit=ON",
                "default-time-zone=+09:00",
                "wait_timeout=28800"
            ],
            "cloudMysqlServerInstanceList": {
              "cloudMysqlServerInstance": [
                {
                  "cloudMysqlServerInstanceNo": "****891",
                  "cloudMysqlServerName": "test-****-001-e04",
                  "cloudMysqlServerRole": {
                    "code": "M",
                    "codeName": "Master"
                  },
                  "cloudMysqlServerInstanceStatusName": "deleting",
                  "cloudMysqlServerInstanceStatus": {
                    "code": "RUN",
                    "codeName": "CLOUD DATABASE(VPC) Server Running State"
                  },
                  "cloudMysqlServerInstanceOperation": {
                    "code": "NOOP",
                    "codeName": "CLOUD DATABASE(VPC) Server Null OP"
                  },
                  "cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
                  "regionCode": "KR",
                  "zoneCode": "KR-1",
                  "vpcNo": "****83",
                  "subnetNo": "****91",
                  "isPublicSubnet": true,
                  "publicDomain": "db-****.vpc-pub-cdb.ntruss.com",
                  "privateDomain": "db-****.vpc-cdb.ntruss.com",
                  "privateIp": "***.***.***.***",
                  "dataStorageType": {
                    "code": "SSD",
                    "codeName": "SSD"
                  },
                  "isStorageEncryption": true,
                  "dataStorageSize": 10737418240,
                  "usedDataStorageSize": 2791728640,
                  "cpuCount": 2,
                  "memorySize": 8589934592,
                  "uptime": "2021-05-27T18:10:00+0900",
                  "createDate": "2021-05-27T18:00:00+0900"
                },
                {
                  "cloudMysqlServerInstanceNo": "****897",
                  "cloudMysqlServerName": "test-****-002-e05",
                  "cloudMysqlServerRole": {
                    "code": "H",
                    "codeName": "Standby Master"
                  },
                  "cloudMysqlServerInstanceStatusName": "deleting",
                  "cloudMysqlServerInstanceStatus": {
                    "code": "RUN",
                    "codeName": "CLOUD DATABASE(VPC) Server Running State"
                  },
                  "cloudMysqlServerInstanceOperation": {
                    "code": "NOOP",
                    "codeName": "CLOUD DATABASE(VPC) Server Null OP"
                  },
                  "cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
                  "regionCode": "KR",
                  "zoneCode": "KR-2",
                  "vpcNo": "****83",
                  "subnetNo": "****93",
                  "isPublicSubnet": true,
                  "privateDomain": "db-****.vpc-cdb.ntruss.com",
                  "privateIp": "***.***.***.***",
                  "dataStorageType": {
                    "code": "SSD",
                    "codeName": "SSD"
                  },
                  "isStorageEncryption": true,
                  "dataStorageSize": 10737418240,
                  "usedDataStorageSize": 2791728640,
                  "cpuCount": 2,
                  "memorySize": 8589934592,
                  "uptime": "2021-05-27T18:10:00+0900",
                  "createDate": "2021-05-27T18:00:00+0900"
                },
                {
                  "cloudMysqlServerName": "test-recovery-001-exr",
                  "cloudMysqlServerRole": {
                    "code": "R",
                    "codeName": "Recovery"
                  },
                  "cloudMysqlServerInstanceStatusName": "pending",
                  "cloudMysqlServerInstanceStatus": {
                    "code": "PEND",
                    "codeName": "CLOUD DATABASE(VPC) Server Pending State"
                  },
                  "cloudMysqlServerInstanceOperation": {
                    "code": "NOOP",
                    "codeName": "CLOUD DATABASE(VPC) Server Null OP"
                  },
                  "cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
                  "regionCode": "KR",
                  "zoneCode": "KR-1",
                  "vpcNo": "****83",
                  "subnetNo": "****91",
                  "isPublicSubnet": true,
                  "privateDomain": "db-****.vpc-cdb.ntruss.com",
                  "privateIp": "***.***.***.***",
                  "dataStorageType": {
                    "code": "SSD",
                    "codeName": "SSD"
                  },
                  "isStorageEncryption": true,
                  "dataStorageSize": 10737418240,
                  "usedDataStorageSize": 2791728640,
                  "cpuCount": 2,
                  "memorySize": 8589934592,
                  "uptime": "2021-07-22T18:10:00+0900",
                  "createDate": "2021-07-22T18:00:00+0900"
                }
              ]
            }
          }
        }
      }
    }
    

    응답 결과 포맷 타입(responseFormatType)이 xml 일 때

    <createCloudMysqlRecoveryInstanceResponse>
        <requestId>ec3580e6-2cc8-487b-bc61-f4ff52ffebc0</requestId>
        <returnCode>0</returnCode>
        <returnMessage>success</returnMessage>
        <totalRows>1</totalRows>
        <cloudMysqlInstanceList>
            <cloudMysqlInstance>
                <cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
                <cloudMysqlServiceName>test-****</cloudMysqlServiceName>
                <cloudMysqlInstanceStatusName>pending</cloudMysqlInstanceStatusName>
                <cloudMysqlInstanceStatus>
                    <code>CREAT</code>
                    <codeName>CLOUD DATABASE(VPC) Created State</codeName>
                </cloudMysqlInstanceStatus>
                <cloudMysqlInstanceOperation>
                    <code>NULL</code>
                    <codeName>CLOUD DATABASE(VPC) Null OP</codeName>
                </cloudMysqlInstanceOperation>
                <cloudMysqlImageProductCode>SW.VDBAS.DBAAS.LNX64.CNTOS.0708.MYSQL.5732.B050</cloudMysqlImageProductCode>
                <engineVersion>MYSQL5.7.32</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>2021-05-27T18:00:00+0900</createDate>
                <accessControlGroupNoList>
                    <accessControlGroupNo>****58</accessControlGroupNo>
                </accessControlGroupNoList>
                <cloudMysqlConfigList>
                    <cloudMysqlConfig>autocommit=ON</cloudMysqlConfig>
                    <cloudMysqlConfig>default-time-zone=+09:00</cloudMysqlConfig>
                    <cloudMysqlConfig>wait_timeout=28800</cloudMysqlConfig>
                </cloudMysqlConfigList>
                <cloudMysqlServerInstanceList>
                    <cloudMysqlServerInstance>
                        <cloudMysqlServerInstanceNo>****891</cloudMysqlServerInstanceNo>
                        <cloudMysqlServerName>test-****-001-e04</cloudMysqlServerName>
                        <cloudMysqlServerRole>
                            <code>M</code>
                            <codeName>Master</codeName>
                        </cloudMysqlServerRole>
                        <cloudMysqlServerInstanceStatusName>deleting</cloudMysqlServerInstanceStatusName>
                        <cloudMysqlServerInstanceStatus>
                            <code>RUN</code>
                            <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
                        </cloudMysqlServerInstanceStatus>
                        <cloudMysqlServerInstanceOperation>
                            <code>NOOP</code>
                            <codeName>CLOUD DATABASE(VPC) Server Null 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>
                        <publicDomain>db-****.vpc-pub-cdb.ntruss.com</publicDomain>
                        <privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
                        <privateIp>***.***.***.***</privateIp>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>2791728640</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>8589934592</memorySize>
                        <uptime>2021-05-27T18:10:00+0900</uptime>
                        <createDate>2021-05-27T18:00:00+0900</createDate>
                    </cloudMysqlServerInstance>
                    <cloudMysqlServerInstance>
                        <cloudMysqlServerInstanceNo>****897</cloudMysqlServerInstanceNo>
                        <cloudMysqlServerName>test-****-002-e05</cloudMysqlServerName>
                        <cloudMysqlServerRole>
                            <code>H</code>
                            <codeName>Standby Master</codeName>
                        </cloudMysqlServerRole>
                        <cloudMysqlServerInstanceStatusName>deleting</cloudMysqlServerInstanceStatusName>
                        <cloudMysqlServerInstanceStatus>
                            <code>RUN</code>
                            <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
                        </cloudMysqlServerInstanceStatus>
                        <cloudMysqlServerInstanceOperation>
                            <code>NOOP</code>
                            <codeName>CLOUD DATABASE(VPC) Server Null 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>
                        <privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
                        <privateIp>***.***.***.***</privateIp>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>2791728640</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>8589934592</memorySize>
                        <uptime>2021-05-27T18:10:00+0900</uptime>
                        <createDate>2021-05-27T18:00:00+0900</createDate>
                    </cloudMysqlServerInstance>
                    <cloudMysqlServerInstance>
                        <cloudMysqlServerName>test-recovery-001-exr</cloudMysqlServerName>
                        <cloudMysqlServerRole>
                            <code>R</code>
                            <codeName>Recovery</codeName>
                        </cloudMysqlServerRole>
                        <cloudMysqlServerInstanceStatusName>pending</cloudMysqlServerInstanceStatusName>
                        <cloudMysqlServerInstanceStatus>
                            <code>PEND</code>
                            <codeName>CLOUD DATABASE(VPC) Server Pending State</codeName>
                        </cloudMysqlServerInstanceStatus>
                        <cloudMysqlServerInstanceOperation>
                            <code>NOOP</code>
                            <codeName>CLOUD DATABASE(VPC) Server Null 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>
                        <privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
                        <privateIp>***.***.***.***</privateIp>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>2791728640</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>8589934592</memorySize>
                        <uptime>2021-07-22T18:10:00+0900</uptime>
                        <createDate>2021-07-22T18:00:00+0900</createDate>
                    </cloudMysqlServerInstance>
                </cloudMysqlServerInstanceList>
            </cloudMysqlInstance>
        </cloudMysqlInstanceList>
    </createCloudMysqlRecoveryInstanceResponse>
    

    이 문서가 도움이 되었습니까?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.