• UID623
  • Fans2
  • Follows1
  • Posts72

Create RDS instance using ROS

More Posted time:Sep 12, 2016 16:47 PM
RDS plug-in introduction
ROS provides two types of resources for generating RDS instances, namely pay-as-you-go instance ALIYUN::RDS::DBInstance and subscription instance ALIYUN::RDS::PrepayDBInstance.
RDS plug-in can support simultaneous creation of RDS instances, connection mode setup, account generation, account creation, database creation, account authorizing, backup setup, access white lists configuration and so on. This article will introduce how to create pay-as-you-go instances and complete the above configurations.
ALIYUN::RDS::DBInstance resource
• Configurations related to RDS instances
o Engine: Database type, value range: [MySQL/SQLServer/PostgreSQL/PPAS]
o EngineVersion: Database version. Value range: 5.5/5.6 for MySQL, 2008r2 for SQLServer, 9.4 for PostgreSQL, and 9.3 for PPAS
o DBInstanceClass: Instance type. Reference configurations
o DBInstanceStorage: Storage space. Different data types have different online and offline storage
o DBInstanceNetType: Network connection type of an instance. Internet: public network; Intranet: private network
o SecurityIPList: List of IP addresses allowed to access all databases for this instance. IP addresses are separated by commas.
Attention: The above configuration parameters are required. Among them, SecurityIPList can be set to if no access white lists are configured. But it is not recommended for security considerations.
o ConnectionMode: The access mode. Performance: the standard access mode; Safety: the high security access mode. The access mode is assigned by the RDS system by default.
o AllocatePublicConnection: Used to apply for external network connection for the instance. After the external network connection is successfully created, an external network connection string will be assigned. Note: In the standard mode, only one access mode (internet or intranet) is supported.
o ZoneId: Used to designate the zone.
o MultiAZ: Used to specify whether multiple availability zones are adopted. MultiAZ and ZoneId parameters are mutually exclusive, and only one of them should be configured. MultiAZ RDS instances can bear server room-level faults, but there may be network latency between multiple zones.
o VpcId, VSwitchId: The two parameters are required for VPC RDS instances.
• Account configuration:
o MasterUsername: Account. The account requires a uniqueness check. It may consist of lower case letters, numbers and underlines, and must start with a letter and have no more than 16 characters.
o MasterUserPassword: Password
• A configuration item of database. It supports simultaneous creation of multiple database DBMappings. The configurations are as follows:
o DBName: The database name requires a uniqueness check. It may consist of lower case letters, numbers and underlines, and must start with a letter and have no more than 64 characters.
o CharacterSetName: Used to set the database character sets.
o DBDescription: Data descriptions.
• Modify Backup Policy
o PreferredBackupTime: Backup time, in the format of HH:mmZ- HH:mm Z
o PreferredBackupPeriod: Backup period. Values: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday
o BackupRetentionPeriod: Retention days of the backup (7 to 730 days). The default value is 7 days.
Note: Setting backup policy will enable backup.
  "ROSTemplateFormatVersion" : "2015-09-01",
  "Resources" : {
    "Database": {
      "Type": "ALIYUN::RDS::DBInstance",
      "Properties": {
        "DBInstanceDescription": "ros",
        "AllocatePublicConnection": true,
        "SecurityIPList": "",
        "MultiAZ": true,
        "MasterUsername": "ros",
        "MasterUserPassword": "sdlfk68UY",
        "PreferredBackupTime": "23:00Z-24:00Z",
        "PreferredBackupPeriod": ["Monday", "Wednesday"],
            "DBName": "ros",
            "CharacterSetName": "utf8"

• Database instance: MySQL 5.6, 1-core 1GB, storage space: 10GB. Safety mode for external network connection.
• Database: name: ros; character type: UTF-8
• Account: name: ros; with permissions for database ros at the same time.
• Backup settings: automatic backup during 07:00-08:00 every Monday and Wednesday.