Description

Note
This interface applies only to MySQL and PostgreSQL instances that use local SSDs.

Query the binlog files of an instance, supporting querying by page. RDS provides binlog file downloads.

  • When the DownloadLink is NULL, this indicates that RDS has not provided a download URL.
  • When DownloadLink is not NULL, you can use this URL to download the backup file through wget (add double quotes), a browser, or programming. The expiration time for this URL is LinkExpiredTime. Use it before the expiration time. If it has expired, you can see the following error code during the download:
    <? xml version="1.0" encoding="UTF-8" ? >
<Error>
<Code>AccessDenied</Code>
<Message>Request has expired.</Message>
<Expires>2012-12-25T09:47:52.000Z</Expires>
<ServerTime>2012-12-25T09:49:00.000Z</ServerTime>
<RequestId>50D9768CA801C2F102005C70</RequestId>
<HostId>oss-test.aliyun-inc.com</HostId>
</Error>

Request parameters

Name Type Required Description
Action String Yes Required parameter. Value: DescribeBinlogFiles.
DBInstanceId String Yes Instance ID.
StartTime String Yes Query start time. Format: yyyy-MM-dd’T’HH:mm:ssZ.
EndTime String Yes Query end time, which must be later than the query start time. Format: yyyy-MM-dd’T’HH:mm:ssZ.
PageSize Integer No Number of records on every page. Values: 30, 50, and 100; default value: 30.
PageNumber Integer No Page number, which must be greater than 0, but must not exceed the maximum Integer value. Default value: 1.

Return parameters

Name Type Description
<Public Return Parameters> For more information, see Public parameters.
TotalRecordCount Integer Total number of binlog files.
PageNumber Integer Page number.
PageRecordCount Integer Number of binlog files displayed on the current page.
Items List<BinLogFile>

BinLogFile parameters

Name Type Description
FileSize Long Binlog file size, in the unit of bytes.
LogBeginTime String Start time for binlog file recording.
LogEndTime String End time for binlog file recording.
DownloadLink String HTTP-compliant download URL. If this parameter is set to NULL, no download URL exists.
HostInstanceID String ID of the instance to which the binlog belongs. This parameter indicates whether the binlog is from the master or slave instance.
LinkExpiredTime String URL expiration time, for example, 2011-06-11T15:00:00Z.

Request example

https://rds.aliyuncs.com/?Action=DescribeBinlogFiles
&DBInstanceId=riauvjz6zajfiq6ba1370329449201
&StartTime=2011-06-11T15:00:00Z
&EndTime=2013-06-05T15:00:00Z
&<Public request parameters>

Response example

XML format

<DescribeBinlogFilesResponse> 
  <RequestId>66816822-CEC1-4C8D-AB26-2530A7D4DCA5</RequestId>
  <TotalRecordCount>1</TotalRecordCount>
  <PageNumber>1</PageNumber>
  <PageRecordCount>1<PageRecordCount>
  <Items>
    <BinLogFile>
    <FileSize>123</FileSize>
    <LogBeginTime>2013-06-01T15:00:00Z</LogBeginTime>
     <LogEndTime>2013-06-02T18:00:00Z</LogEndTime>
     <DownloadLink>http://rdslog- real.oss.aliyuncs.com/custins47742/hostins46770/mysql-bin. 000120.zip? spm=0.0.0.0.eMQKjs&OSSAccessKeyId=c9gzsqpauj3duw5whwdv40hb&Expires=1384916927&Signature=07TMgM3G2Jw4sOO6yN8nWDgBJPA%3D</DownloadLink>
    <LinkExpiredTime>2013-06-09T18:00:00Z</LinkExpiredTime>
   </BinLogFile>
  </Items>
</DescribeBinlogFilesResponse>

JSON format

{
    "RequestId":"66816822-CEC1-4C8D-AB26-2530A7D4DCA5"
"PageNumber":1,
"TotalRecordCount":1,
"PageRecordCount":1
"Items":
{"BinLogFile":
[
{
FileSize:”123”
LogBeginTime:”2013-06-01T15:00:00Z”
LogEndTime:”2013-06-02T18:00:00Z”
DownloadLink:”http://rdslog-real.oss.aliyuncs.com/custins47742/hostins46770/mysql-bin. 000120.zip?spm=0.0.0.0.eMQKjs&OSSAccessKeyId=c9gzsqpauj3duw5whwdv40hb&Expires=1384916927&Signature=07TMgM3G2Jw4sOO6yN8nWDgBJPA%3D”
LinkExpiredTime”2013-06-09T18:00:00Z”
}
]
}
}