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