MENU
      createCloudMysqlRecoveryInstance

        createCloudMysqlRecoveryInstance


        기사 요약

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

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

        명령어

        명령어 구문은 다음과 같습니다.

        ncloud vmysql createCloudMysqlRecoveryInstance [regionCode KR] [cloudMysqlInstanceNo] [subnetNo] [fileName] [recoveryTime] [cloudMysqlRecoveryServerName] [output]
        Plain text

        파라미터

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

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

        응답

        응답 데이터 타입

        명령어 호출에 대한 응답 데이터 타입은 다음과 같습니다.

        • CloudMysqlInstanceList 타입
        CloudMysqlInstanceList extends CommonResponse설명
        private Integer totalRows;조회된 목록의 총 개수
        private List<CloudMysqlInstance> cloudMysqlInstanceList = new ArrayList<>();
        • CloudMysqlInstance 타입
        CloudMysqlInstance설명
        private String cloudMysqlInstanceNo;Cloud DB for MySQL 인스턴스 번호
        private String cloudMysqlServiceName;Cloud DB for MySQL 서비스 이름
        private String cloudMysqlInstanceStatusName;Cloud DB for MySQL 인스턴스 상태 이름
        -creating
        -deleted
        -deleting
        -pending
        -recovering
        -reinstalling
        -restarting
        -running
        -settingup
        -shuttingdown
        -stopped
        -upgrading
        -downgrading
        private CommonCode cloudMysqlInstanceStatus;Cloud DB for MySQL 인스턴스 상태 코드
        -INIT (init)
        -CREAT (created)
        -DEL (deleted)
        private CommonCode cloudMysqlInstanceOperation;Cloud DB for MySQL 인스턴스 Operation 코드
        -CREAT (create)
        -DEL (delete)
        -FO (failover)
        -NULL (no)
        -SETUP (setup)
        -UPGD (upgrade)
        -DWGD (downgrade)
        -BKP (backup)
        private String cloudMysqlImageProductCode;Cloud DB for MySQL 이미지 상품 코드
        private String engineVersion;Cloud DB for MySQL 엔진 버전
        private CommonCode license;Cloud DB for MySQL 라이선스
        private Integer cloudMysqlPort;Cloud DB for MySQL 포트
        private Boolean isHa;고가용성 여부
        private Boolean isMultiZone;멀티존 여부
        private Boolean isBackup;백업 여부
        private Integer backupFileRetentionPeriod;백업 파일 보관 기간
        private String backupTime;백업 시간
        private String generationCode;서버 세대 코드
        private Date createDate;생성일자
        private List<String> accessControlGroupNoList;ACG 번호 목록
        private List<String> cloudMysqlConfigList;Cloud DB for MySQL Config 목록
        private List<CloudMysqlServerInstance> cloudMysqlServerInstanceList;Cloud DB for MySQL 서버 인스턴스 목록
        • CloudMysqlServerInstance 타입
        CloudMysqlServerInstance설명
        private String cloudMysqlServerInstanceNo;Cloud DB for MySQL 서버 인스턴스 번호
        private String cloudMysqlServerName;Cloud DB for MySQL 서버 이름
        private CommonCode cloudMysqlServerRole;Cloud DB for MySQL 서버 역할
        private String cloudMysqlServerInstanceStatusName;Cloud DB for MySQL 서버 인스턴스 상태 이름
        -creating
        -deleted
        -deleting
        -downgrading
        -pending
        -recovering
        -reinstalling
        -restarting
        -running
        -settingup
        -shuttingdown
        -stopped
        -upgrading
        -downgrading
        private CommonCode cloudMysqlServerInstanceStatus;Cloud DB for MySQL 서버 인스턴스 상태 코드
        -DEL (deleted)
        -PEND (pending)
        -RUN (running)
        -STOP (stopped)
        -FSTOP (failure stopped)
        private CommonCode cloudMysqlServerInstanceOperation;Cloud DB for MySQL 서버 인스턴스 Operation 코드
        -NOOP (no operation)
        -CREAT (create)
        -START (start)
        -RSTRT (restart)
        -SETUP (setup)
        -STOP (stop)
        -FO (failover)
        -DEL (delete)
        -UPGD (upgrade)
        -DWGD (downgrade)
        -RISTL (서버 reinstall)
        -MIG (migration)
        private String cloudMysqlProductCode;Cloud DB for MySQL 상품 코드
        private String regionCode;리전 코드
        private String zoneCode;ZONE 코드
        private String vpcNo;VPC 번호
        private String subnetNo;Subnet 번호
        private Boolean isPublicSubnet;Public Subnet 여부
        private String publicDomain;공인 도메인명
        private String privateDomain;사설 도메인명
        private String privateIp;내부 IP
        private CommonCode dataStorageType;데이터 스토리지 타입
        private Boolean isStorageEncryption;데이터 스토리지 암호화 여부
        private Long dataStorageSize;데이터 스토리지 사이즈
        private Long usedDataStorageSize;사용중인 데이터 스토리지 사이즈
        private Integer cpuCount;virtual CPU 개수
        private Long memorySize;메모리 사이즈
        private Date uptime;VM Booting 완료시간
        private Date createDate;생성일자

        예시

        호출과 응답 예시를 설명합니다.

        호출 예시

        호출 예시는 다음과 같습니다.

        ncloud vmysql createCloudMysqlRecoveryInstance --regionCode KR --cloudMysqlInstanceNo ****890 --fileName 20210722 --cloudMysqlRecoveryServerName test-recovery --subnetNo ****91
        Plain text

        응답 예시

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

        응답 결과 포맷 타입(output)이 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"
                    }
                  ]
                }
              }
            }
          }
        }
        JSON

        응답 결과 포맷 타입(output)이 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>
        XML

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

        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.