Creates a stress testing task on Advanced Database & Application Migration (ADAM).

Database Autonomy Service (DAS) provides the intelligent stress testing feature. You use an ADAM stress testing task to check whether you need to scale up or scale out your database instance to handle workloads during peak hours. For more information, see Intelligent Stress Testing.

The database instances that are used for stress testing must meet the following requirements:

  • The source database instance is a High-availability Edition or Enterprise Edition instance of ApsaraDB RDS for MySQL, or a Cluster Edition or Archive Database Edition instance of the ApsaraDB PolarDB MySQL-compatible edition.
  • The destination database instance is an ApsaraDB RDS for MySQL instance or a ApsaraDB PolarDB MySQL-compatible edition instance.
  • The source database instance and the destination database instance are connected to DAS. For information about how to connect database instances to DAS, see Access an Alibaba Cloud database instance.
  • DAS Professional Edition are activated for the source database instance and the destination database instance. For more information, see DAS Professional Edition.

Request parameters

Parameter Type Required Example Description
Action String Yes CreateAdamBenchTask

The operation that you want to perform. Set the value to CreateAdamBenchTask.

Description String Yes test-das-bench-0501

The description of the stress testing task.

SrcSqlOssAddr String Yes http://rdslog-hz-v3.oss-cn-hangzhou.aliyuncs.com/custins4131****

The URL of the Object Storage Service (OSS) folder in which the archived objects for SQL statements that run on the source database instance are stored. You can obtain the URL after you upload the archived files to OSS.

SrcEngine String No MySQL

The database engine that the source database instance runs.

SrcEngineVersion String No 9i

The version of the database engine that the source database instance runs.

SrcMaxQps double Yes 2013.22

The maximum number of queries per second (QPS) within the time period during which traffic on the source database instance is captured. The value must be accurate to two decimal places.

SrcMeanQps double Yes 312.22

The average QPS within the time period in which traffic on the source database instance is captured. The value must be accurate to two decimal places.

RequestStartTime Long Yes 1588819800000

The start time of the stress testing task. Specify the time in the UNIX timestamp format. Unit: milliseconds.

RequestDuration Long Yes 86400000

The duration of the stress testing task. Unit: milliseconds.

Rate Integer No 1

The rate at which the traffic captured from the source database instance is replayed on the destination database instance. Valid values: 1 to 30. Default value: 1.

DstInstanceId String Yes rm-2ze1jdv45i7l6****

The ID of the destination database instance. The destination database instance must be an ApsaraDB RDS for MySQL instance or an ApsaraDB PolarDB MySQL-compatible edition instance. You can call the GetInstanceInspections operation to obtain the ID of the destination database instance. For more information, see GetInstanceInspections.

DstSuperAccount String Yes root***

The name of the privileged account that is used to manage the destination database instance.

DstSuperPassword String Yes root***1234

The password of the privileged account that is used to manage the destination database instance.

Response parameters

Parameter Type Example Description
Code String 200

The returned HTTP status code.

Message String Successful

The returned message that indicates the result of the request.

Note If the request is successful, Successful is returned. If the request fails, an error message that includes an error code is returned.
Data String "Data": { "total": 1, "list":[...] }, "Code": 200, "Success": true }

The details of the response, such as the HTTP status code and the number of returned entries.

RequestId String B6D17591-B48B-4D31-9CD6-9B9796B2****

The ID of the request.

Success String true

Indicates whether the request is successful. Valid values:

  • true: The request is successful.
  • false: The request failed.

Examples

Sample requests

http(s)://das.cn-shanghai.aliyuncs.com/?Action=CreateAdamBenchTask
&Description=test-das-bench-0501
&SrcSqlOssAddr=http://rdslog-hz-v3.oss-cn-hangzhou.aliyuncs.com/custins4131****
&SrcEngine=MySQL
&SrcEngineVersion=9i
&SrcMaxQps=2013.22
&SrcMeanQps=312.22
&RequestStartTime=1588819800000
&RequestDuration=86400000
&Rate=1
&DstInstanceId=rm-2ze1jdv45i7l6****
&DstSuperAccount=root***
&DstSuperPassword=root***1234
&<Common request parameters>

Sample success responses

XML format

HTTP/1.1 200 OK
Content-Type:application/xml

<CreateAdamBenchTaskResponse>
    <Code>200</Code>
    <Message>Successful</Message>
    <Data>"Data": { "total": 1, "list":[...] }, "Code": 200, "Success": true }</Data>
    <RequestId>B6D17591-B48B-4D31-9CD6-9B9796B2****</RequestId>
    <Success>true</Success>
</CreateAdamBenchTaskResponse>

JSON format

HTTP/1.1 200 OK
Content-Type:application/json

{
  "Code" : "200",
  "Message" : "Successful",
  "Data" : "\"Data\": { \"total\": 1, \"list\":[...] }, \"Code\": 200, \"Success\": true }",
  "RequestId" : "B6D17591-B48B-4D31-9CD6-9B9796B2****",
  "Success" : "true"
}

Error codes

HttpCode Error code Error message Description
400 InvalidParams The request parameters are invalid. The error message returned because the specified request parameters are invalid.

For a list of error codes, visit the API Error Center.