Alibaba Cloud Resource Orchestration Service (ROS) lets you define cloud resources and their dependencies in a template. The ROS engine automatically creates and configures all resources based on the template. This topic demonstrates how to query ApsaraDB RDS instance information by using ROS.
Supported resources
ROS simplifies cloud resource management by letting you define resources such as Elastic Compute Service (ECS) instances and ApsaraDB RDS instances in a template. The ROS engine then automatically creates and configures all defined resources. For more information, see What is Resource Orchestration Service?.
ROS supports both standard resources and data source resources for ApsaraDB RDS.
-
Standard resources:
-
ALIYUN::RDS::Account: Creates an account to manage a database.
-
ALIYUN::RDS::AccountPrivilege: Grants an account permissions to access a database.
-
ALIYUN::RDS::ADInfo: Configures Active Directory (AD) domain services.
-
ALIYUN::RDS::Connection: Requests a public endpoint.
-
ALIYUN::RDS::Database: Creates a database in an instance.
-
ALIYUN::RDS::DBInstance: Creates an ApsaraDB RDS instance.
-
ALIYUN::RDS::DBInstanceParameterGroup: Modifies the parameters of an ApsaraDB RDS instance.
-
ALIYUN::RDS::DBInstanceSecurityIps: Modifies the IP address whitelist for an instance.
-
ALIYUN::RDS::DBInstanceClone: Restores historical data to a new instance, creating a clone instance.
-
ALIYUN::RDS::MigrateTask: Migrates data to an ApsaraDB RDS for SQL Server instance by restoring a backup file from Object Storage Service (OSS).
-
ALIYUN::RDS::PostgresExtensions: Installs a specified extension in the destination database.
-
ALIYUN::RDS::PrepayDBInstance: Creates a subscription database instance.
-
ALIYUN::RDS::ReadOnlyDBInstance: Creates a read-only instance.
-
-
Data source resources:
-
DATASOURCE::RDS::Accounts: Queries account information for an instance.
-
DATASOURCE::RDS::DBInstance: Queries information about an ApsaraDB RDS instance.
-
DATASOURCE::RDS::Databases: Queries information about the databases in an ApsaraDB RDS instance.
-
DATASOURCE::RDS::DBInstances: Queries a list of ApsaraDB RDS instances.
-
DATASOURCE::RDS::Zones: Queries available ApsaraDB RDS resources in a zone.
-
Configure permissions
For security, create a RAM user with the necessary permissions and use its AccessKey pair instead of accessing ApsaraDB RDS directly with your Alibaba Cloud account.
-
Create a RAM user:
-
Go to the Users page and click Create User.
-
Set Logon Name to rds-test-operator and select Programmatic Access for Access Method.
-
Click OK to create the RAM user.
-
-
Grant permissions:
-
Go to the Users page, find the RAM user, and click Add Permissions in the Actions column.
-
Add the following permission policies to the RAM user.
-
AliyunRDSFullAccess: Grants full control over ApsaraDB RDS instances, including query and modification permissions.
NoteYou can also select AliyunRDSReadOnlyAccess, which grants read-only permissions on ApsaraDB RDS instances, or create a custom permission policy. For more information, see Create a custom permission policy.
-
AliyunROSFullAccess: Grants full control over Resource Orchestration Service (ROS).
-
-
Click OK to add the permissions.
-
Procedure
-
Log on to the ROS console.
-
In the upper-left corner of the top navigation bar, select a region.
-
In the left-side navigation pane, click Stack, and then click Create Stack.
-
Select a template and click Next.
This example uses a custom template to query ApsaraDB RDS instance information. For more information about templates, see Create a stack.
-
In the Specify Template section, select Select an Existing Template.
-
For Template Import Method, select Enter Template Content.
-
In the Template Content section, select ROS and enter the template code.
The following template uses the ROS data source resource to query ApsaraDB RDS instance information. For more information, see DATASOURCE::RDS::DBInstance.
-
-
Configure the parameters.
Parameter
Required
Description
Example
Stack name
Yes
The name of the stack.
Rds_TestDBInstanceId
Yes
The ID of the ApsaraDB RDS instance.
rm-bp1tuz16pa5x8****
Configure Stack Settings
No
Stack configuration parameters.
For more information, see Configure stack parameters.
-
Click Create.
-
After the stack is created, click the Output tab to view the instance details.
