阿里官方API:https://help.aliyun.com/document_detail/26226.html?spm=5176.product26090.6.819.CyyA4l
脚本如下:
#!/usr/bin/env python
# coding=utf-8
from aliyunsdkcore import client
from aliyunsdkrds.request.v20140815 import DescribeDBInstancesRequest
import json
import pymysql
#参数传入
accessKey = sys[0]
accessSecret = sys[1]
region =sys[2]
# 获得cn-qingdao ecs列表
clt = client.AcsClient(accessKey, accessSecret, region)
request = DescribeDBInstancesRequest.DescribeDBInstancesRequest()
request.set_accept_format('json')
request.set_PageSize(100) # 每页条数
request.set_PageNumber(1) # 第几页
response = json.loads(clt.do_action_with_exception(request), encoding='utf-8')
for info in response.get('Items').get('DBInstance'):
rds_no = info.get('DBInstance