附录

计费相关

Billing

状态 类型 描述
paymentTiming String 付费方式。
预付费:Prepaid,后付费:Postpaid
reservation Reservation 保留信息,支付方式为后支付时不需要设置,预支付时必须设置

Reservation

状态 类型 描述
reservationLength int 时长,[1,2,3,4,5,6,7,8,9,12,24,36]
reservationTimeUnit String 时间单位,Month,当前仅支持按月

实例可选套餐

主/只读实例实例可选套餐

引擎(类型) 可选规格配置(CPU核数, 内存GB) 磁盘(GB)
MySQL/PostgreSQL/MySQL只读 [1, 1] 5-200
- [1, 2] 5-400
- [1, 4], [2, 8], [1, 8], [2, 4], [6, 8] 5-1000
- [4, 16], [8, 32],[16, 64], [32, 128], [2, 16], [4, 32], [8, 64],[16, 128], [32, 256], [56, 480], [8, 16], [12, 24], [16, 32], [20, 48], [20, 64] 5-3000
SQLServer [1, 2] 5-400
- [1, 4], [2, 8], [1, 8], [2, 4], [6, 8], [6, 12] 5-1000
- [4, 16], [8, 32],[16, 64], [32, 128], [2, 16], [4, 32], [8, 64],[16, 128], [32, 256], [56, 480], [8, 16], [12, 24], [16, 32], [20, 48], [20, 64] 5-3000

代理实例可选套餐

节点数:2、4、6、8、16

以下是旧套餐,已废弃:

引擎 CPU核数 内存(GB) 磁盘(GB)
MySQL 1 0.25 5-1000
- 1 0.5 5-1000
- 2 1 5-1000
- 2 2 5-1000
- 4 4 5-1000
- 6 8 5-1000
- 8 16 5-1000
- 12 24 5-1000
- 16 32 5-1000
- 20 48 5-1000
- 20 64 5-1000
SQLServer 2 1 10-1000
- 2 2 10-1000
- 4 4 10-1000
- 6 8 10-1000
- 6 12 10-1000
- 8 16 10-1000
- 12 24 10-1000
- 16 32 10-1000
- 20 48 10-1000
- 20 64 10-1000
PostgreSQL 1 0.5 5-1000
- 2 1 5-1000
- 2 2 5-1000
- 4 4 5-1000
- 6 8 5-1000
- 8 16 5-1000
- 12 24 5-1000
- 16 32 5-1000
- 20 48 5-1000
- 20 64 5-1000

数据库版本

MySQL版本

版本号 描述
5.5 使用定制的5.5.35
5.6 使用定制的5.6.20
5.7 使用定制的5.7.17

SQLServer版本

版本号 描述
2008r2 sqlserver 2008
2012sp3 sqlserver 2012
2016sp1 sqlserver 2016

PostgreSQL版本

版本号 描述
9.4 postgre 9.4.4

通用数据格式

时间与日期

日期与时间的表示有多种方式。为统一起见,除非是约定俗成或者有相应规范的,凡需要日期时间表示的地方一律采用UTC时间,遵循ISO 8601,并做以下约束: 1 表示日期一律采用YYYY-MM-DD方式,例如2016-06-01表示2016年6月1日 1 表示时间一律采用hh:mm:ss方式,并在最后加一个大写字母Z表示UTC时间。例如23:00:10Z表示UTC时间23点0分10秒。 1 凡涉及日期和时间合并表示时,在两者中间加大写字母T,例如2016-06-01T23:00:10Z表示UTC时间2016年6月1日23点0分10秒

IP格式

使用CIDR(http://en.wikipedia.org/wiki/Cidr)模式,
示例: 0.0.0.0/0,10.23.12.24(IP),或者10.23.12.24/24(无类域间路由,/24表示了地址中前缀的长度,范围[1,32])。
其中,%或0.0.0.0/0,表示不限制。

实例相关

引擎类型

状态值 描述
MySQL RDS for MySQL
SQLServer RDS for SQLServer
PostgreSQL RDS for PostgreSQL

实例类型

状态值 描述
Master 主实例
ReadReplica 只读实例
RdsProxy 代理实例

同步模式

状态值 描述
Async 异步复制
Semi_sync 半同步复制

同步模式状态

状态值 描述
Async 异步复制
Semi_sync 半同步复制
Modifying 处理中

实例状态

状态值 描述
Creating 创建中
Available 运行中
Rebooting 实例重启中
Backuping 实例备份中
Restoring 备份恢复中
ReadReplicating 搭建只读副本数据同步中
Initing 数据克隆中
LockExpiration 已到期
LockDiskQuota 磁盘超限
Migrating 数据迁移中
Modifying 实例调整中(包括硬件套餐升级)
MasterModifying 主实例变配中
ReadReplicateModifying 只读副本实例升级中

公网访问状态

状态值 描述
Closed 未开放外网权限
Creating 公网开通中,成功后状态为Available
Available 已开通公网

实例购买系列

状态值 描述
Basic 单机基础版,只有主库
Standard 双机高可用版,一主一备

数据库相关

数据库状态

状态值 描述
Creating 正在创建的数据库
Available 正常运行的数据库
Deleting 正在删除

账号相关

授权类型

授权类型 描述
ReadOnly 只读账号
ReadWrite 读写账号

账号权限类型

授权类型 描述
Common 只读账号
Super 读写账号

账号归属类型

状态值 描述
OnlyMaster 在master上使用的账号
RdsProxy 在中间件上使用的账号

账号状态

状态值 描述
Creating 创建中
Available 可用中
Updating 更新中
Deleting 删除中

备份相关

备份类型

状态值 描述
Manual 手工创建
Automated 自动创建

备份状态

状态值 描述
Creating 创建中
Available 备份可用
Deleting 正在删除

日志相关

日志状态

状态值 描述
Creating 创建中
Available 可以下载

参数配置相关

参数数据类型

状态值 描述
integer 该参数的值为整数,取值范围是allowedValues中的from-to的表示的整数。
string 该参数的值为字符串,取值范围是allowedValues中的值其中之一。
set 该参数的值为集合值,取值范围是allowedValues中的值其中的一个或多个。

参数的生效方式

状态值 描述
immediate 立即生效
pendingReboot 重启后生效

参数的生效状态

状态值 描述
Success 已生效
PendingReboot 重启后生效
Failed 未生效

数据库字符集

MySQL支持的字符集

字符集 描述
gbk 支持常见汉字
latin1 建议不要用
utf8 默认字符集,支持大部分语系字符
utf8mb4 适合有表情字符的场景

SQLServer支持的字符集

字符集 描述
Chinese_PRC_CI_AS 支持常见汉字
Chinese_PRC_CS_AS 建议不要用
SQL_Latin1_General_CP1_CI_AS 默认字符集,支持大部分语系字符
SQL_Latin1_General_CP1_CS_AS 适合有表情字符的场景
Chinese_PRC_BIN

数据库保留关键字

MySQL保留关键字

账号名和数据库名保留以下关键字不允许使用。

admin,aurora,replicator,xtrabak,root,mysql,test,eagleye,information_schema,guest,add,analyze,asc,between,blob,call,change,check,condition, continue,cross,current_timestamp,database,day_microsecond,dec,default,desc,distinct,double,each,enclosed,exit,fetch,float8,foreign,goto,having, hour_minute,ignore,infile,insensitive,int1,int4,interval,iterate,keys,leading,like,lines,localtimestamp,longblob,low_priority,mediumint, minute_microsecond,modifies,no_write_to_binlog,on,optionally,out,precision,purge,read,references,rename,require,revoke,schema,select,set,spatial, sqlexception,sql_big_result,ssl,table,tinyblob,to,true,unique,update,using,utc_timestamp,varchar,when,with,xor,all,and,asensitive,bigint, both,cascade,char,collate,connection,convert,current_date,current_user,databases,day_minute,decimal,delayed,describe,distinctrow,drop,else, escaped,explain,float,for,from,grant,high_priority,hour_second,in,inner,insert,int2,int8,into,join,kill,leave,limit,load,lock,longtext,match,mediumtext, minute_second,natural,null,optimize,or,outer,primary,raid0,reads,regexp,repeat,restrict,right,schemas,sensitive,show,specific,sqlstate, sql_calc_found_rows,starting,terminated,tinyint,trailing,undo,unlock,usage,utc_date,values,varcharacter,where,write,year_month,alter,as,before,binary, by,case,character,column,constraint,create,current_time,cursor,day_hour,day_second,declare,delete,deterministic,div,dual,elseif,exists,false, float4,force,fulltext,group,hour_microsecond,if,index,inout,int,int3,integer,is,key,label,left,linear,localtime,long,loop,mediumblob,middleint, mod,not,numeric,option,order,outfile,procedure,range,real,release,replace,return,rlike,second_microsecond,separator,smallint,sql,sqlwarning,sql_small_result, straight_join,then,tinytext,trigger,union,unsigned,use,utc_time,varbinary,varying,while,x509,zerofill,performance_schema

SQLServer保留关键字

账号名和数据库名保留以下关键字不允许使用。

master,model,msdb,tempdb,sa,sqlserver_mirror_login,add,external,procedure,all,fetch,public,alter,file,raiserror,and,fillfactor,read,any,for,readtext,
as,foreign,reconfigure,asc,freetext,references,authorization,freetexttable,replication,backup,from,restore,begin,full,restrict,between,function,
return,breakgoto,revert,browse,grant,revoke,bulk,group,right,by,having,rollback,cascade,holdlock,rowcount,case,identity,rowguidcol,check,
identity_insert,rule,checkpoint,identitycol,save,close,if,schema,clustered,in,securityaudit,coalesce,index,select,collate,inner,semantickeyphrasetable,
column,insert,semanticsimilaritydetailstable,commit,intersect,semanticsimilaritytable,compute,into,session_user,constraint,is,set,contains,join,setuser,containstable,key,shutdown,continue,kill,some,
convert,left,statistics,create,like,system_user,cross,lineno,table,current,load,tablesample,current_date,merge,textsize,current_time,national,then,
current_timestamp,nocheck,to,current_user,nonclustered,top,cursor,not,tran,database,null,transaction,dbcc,nullif,trigger,deallocate,of,truncate,declare,off,try_convert,default,
offsets,tsequal,delete,on,union,deny,open,unique,desc,opendatasource,unpivot,disk,openquery,update,distinct,openrowset,updatetext,distributed,openxml,use,double,option,user,
drop,or,values,dump,order,varying,else,outer,view,end,over,waitfor,errlvl,percent,when,escape,pivot,where,except,plan,while,exec,precision,with,execute,primary,within,group,exists,print,writetext,exit,proc

PostgreSQL保留关键字

账号名保留以下关键字不允许使用。

abort,abs,absolute,access,action,ada,add,admin,after,aggregate,alias,all,allocate,alter,analyse,analyze,and,any,are,array,as,asc,asensitive,assertion,
assignment,asymmetric,at,atomic,authorization,avg,backward,before,begin,between,bigint,binary,bit,bitvar,bit_length,blob,boolean,both,breadth,
by,c,cache,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,chain,char,character,characteristics,character_length,
character_set_catalog,character_set_name,character_set_schema,char_length,check,checked,checkpoint,class,class_origin,clob,close,cluster,coalesce,
cobol,collate,collation,collation_catalog,collation_name,collation_schema,column,column_name,command_function,command_function_code,comment,
commit,committed,completion,condition_number,connect,connection,connection_name,constraint,constraints,constraint_catalog,constraint_name,
constraint_schema,constructor,contains,continue,conversion,convert,copy,corresponding,count,create,createdb,createuser,cross,cube,current,
current_date,current_path,current_role,current_time,current_timestamp,current_user,cursor,cursor_name,cycle,data,database,date,datetime_interval_code,
datetime_interval_precision,day,deallocate,dec,decimal,declare,default,deferrable,deferred,defined,definer,delete,delimiter,delimiters,depth,deref,
desc,describe,descriptor,destroy,destructor,deterministic,diagnostics,dictionary,disconnect,dispatch,distinct,do,domain,double,drop,dynamic,
dynamic_function,dynamic_function_code,each,else,encoding,encrypted,end,endexec,equals,escape,every,except,exception,exclusive,exec,execute,
existing,exists,explain,external,extract,false,fetch,final,first,float,for,force,foreign,fortran,forward,found,free,freeze,from,full,function,
g,general,generated,get,global,go,goto,grant,granted,group,grouping,handler,having,hierarchy,hold,host,hour,identity,ignore,ilike,immediate,
immutable,implementation,implicit,in,increment,index,indicator,infix,inherits,initialize,initially,inner,inout,input,insensitive,insert,instance,
instantiable,instead,int,integer,intersect,interval,into,invoker,is,isnull,isolation,iterate,join,k,key,key_member,key_type,lancompiler,language,
large,last,lateral,leading,left,length,less,level,like,limit,listen,load,local,localtime,localtimestamp,location,locator,lock,lower,m,map,match,max,
maxvalue,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,mode,modifies,modify,module,month,more,move,mumps,name,names,
national,natural,nchar,nclob,new,next,no,nocreatedb,nocreateuser,none,not,nothing,notify,notnull,null,nullable,nullif,number,numeric,object,octet_length,
of,off,offset,oids,old,on,only,open,operation,operator,option,options,or,order,ordinality,out,outer,output,overlaps,overlay,overriding,owner,pad,
parameter,parameters,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,
partial,pascal,password,path,pendant,placing,pli,position,postfix,precision,prefix,preorder,prepare,preserve,primary,prior,privileges,procedural,
procedure,public,read,reads,real,recheck,recursive,ref,references,referencing,reindex,relative,rename,repeatable,replace,reset,restrict,result,return,
returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,
row,rows,row_count,rule,savepoint,scale,schema,schema_name,scope,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,
server_name,session,session_user,set,setof,sets,share,show,similar,simple,size,smallint,some,source,space,specific,specifictype,specific_name,sql,
sqlcode,sqlerror,sqlexception,sqlstate,sqlwarning,stable,start,state,statement,static,statistics,stdin,stdout,storage,strict,structure,style,sub
class_origin,sublist,substring,sum,symmetric,sysid,system,system_user,table,table_name,temp,template,temporary,terminate,than,then,time,timestamp,
timezone_hour,timezone_minute,to,toast,trailing,transaction,transactions_committed,transactions_rolled_back,transaction_active,transform,transforms,
translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,truncate,trusted,type,uncommitted,under,unencrypted,union,
unique,unknown,unlisten,unnamed,unnest,until,update,upper,usage,user,user_defined_type_catalog,user_defined_type_name,user_defined_type_schema,using,
vacuum,valid,validator,value,values,varchar,variable,varying,verbose,version,view,volatile,when,whenever,where,with,without,work,write,year,zone,
postgresql,postgres,template1,template0