docs
api
Cloud Database(UDB)
CreateUDBInstanceByRecovery

Restore the newly created db to a specified point in time in the specified db. - CreateUDBInstanceByRecovery

Overview

Create db, restore the newly created db to a specified point in time in the specified db

Definition

Public Parameters

Parameter NameTypeDescription InformationRequired
ActionstringCorresponding API command name, the current API is CreateUDBInstanceByRecovery.Yes
PublicKeystringThe user's public key can be obtained from Console (opens in a new tab)Yes
SignaturestringUser signature generated based on public key and API command, see Signature AlgorithmYes

Request Parameters

Parameter NameTypeDescription InformationRequired
RegionstringRegion. See List of Regions and Availability ZonesYes
ZonestringAvailability Zone. See Availability Zone ListNo
ProjectIdstringProject ID. If not filled in, the default project is used, sub-accounts must be filled in. Please refer to the GetProjectList interface.No
NamestringInstance name, at least 6 charactersYes
SrcDBIdstringSource Instance's IdYes
RecoveryTimeintTimestamp to restore to a certain point in time (UTC time format, default unit is seconds)Yes
ChargeTypestringYearly, Monthly, Dynamic, Trial, Default: DynamicNo
QuantityintPurchase duration, default value 1No
UseSSDbooleanSpecify whether to use SSD, the default is to use the master library configurationNo
UDBCIdstringId of the ZoneNo
SubnetIdstringSubnet IDNo
VPCIdstringID of VPCNo
EnableIpV6booleanWhether to create resources using ipv6, the default is false, or not filled in, creating ipv6 is trueNo
TablesstringSpecify the tables to be restored. If this field is specified, only the data of the specified tables will be rolled back. The format is (database name.table name). Specify multiple tables separated by commas, eg: [udb.test, mysql_school.my_student]No
AdminPasswordstringAdministrator password (valid when rolling back specified database table to a new instance)No
SpecificationTypeintThe type of instance computing specification, 0 or no transmission means purchasing by memory method, 1 means purchasing by optional memory-cpu ratio method, need to fill in MachineType.No
MachineTypestringSpecification Type ID, valid when SpecificationType is 1No
CouponIdstringID of the voucher usedNo

Response Field

Field NameTypeDescription InformationRequired
RetCodeintReturn status code. If it is 0, it means successful return. If it is not 0, it means failure.Yes
ActionstringOperation command name.Yes
MessagestringReturns an error message, providing detailed description when RetCode is non-zero.No
DBIdstringdb instance idNo

Example

Request Example

https://api.surfercloud.com/?Action=CreateUDBInstanceByRecovery
&Region=cn-bj2
&ChargeType=Month   
&Name=udb-xxxxxxx
&SrcDBId=udb-xxxxx
&RecoveryTime=1432806384
&UseSSD=true
&SubnetId=SfBAwgaR
&VPCId=axmBjGuC
&EnableIpV6=true
&Tables=QLdHhoGF
&AdminPassword=CFJHxCUW
&AdminPassword=PFisJMZz
&AdminPassword=SPffecnI
&SpecificationType=yRERufjK
&MachineType=YWsemVcG

Response Example

{
  "Action": "CreateUDBInstanceByRecoveryResponse",
  "DBId": "udb-xxxxx",
  "RetCode": 0
}
  • Company
  • ContactUs
  • Blog
Copyright © 2024 SurferCloud All Rights Reserved