查看BINLOG日志的步骤

描述


查询实例的BINLOG文件（仅MySQL数据库实例），支持分页。RDS提供Binlog文件下载。

• 
  当DownloadLink为NULL时，表示RDS没有提供下载链接URL。
• 
  当DownloadLink不为NULL时，用户可以根据此URL，通过wget（请加双引号）、浏览器、编写程序下载备份文件，此URL已设置过期时间LinkExpiredTime，请在过期时间之前使用。若过期，用户在下载时，将会出现如下错误码：
  1. [backcolor=transparent] <?[backcolor=transparent] xml version[backcolor=transparent] =[backcolor=transparent] "1.0"[backcolor=transparent] encoding[backcolor=transparent] =[backcolor=transparent] "UTF-8"[backcolor=transparent] [backcolor=transparent] ?>
  2. [backcolor=transparent]<Error>
  3. [backcolor=transparent]<Code>[backcolor=transparent]AccessDenied[backcolor=transparent]</Code>
  4. [backcolor=transparent]<Message>[backcolor=transparent]Request has expired.[backcolor=transparent]</Message>
  5. [backcolor=transparent]<Expires>[backcolor=transparent]2012-12-25T09:47:52.000Z[backcolor=transparent]</Expires>
  6. [backcolor=transparent]<ServerTime>[backcolor=transparent]2012-12-25T09:49:00.000Z[backcolor=transparent]</ServerTime>
  7. [backcolor=transparent]<RequestId>[backcolor=transparent]50D9768CA801C2F102005C70[backcolor=transparent]</RequestId>
  8. [backcolor=transparent]<HostId>[backcolor=transparent]oss-test.aliyun-inc.com[backcolor=transparent]</HostId>
  9. [backcolor=transparent]</Error>

• 
  请求示例
  1. [backcolor=transparent] https[backcolor=transparent] :[backcolor=transparent] //rds.aliyuncs.com/?Action=DescribeBinlogFiles
  2. [backcolor=transparent]&[backcolor=transparent]DBInstanceId[backcolor=transparent]=[backcolor=transparent]riauvjz6zajfiq6ba1370329449201
  3. [backcolor=transparent]&[backcolor=transparent]StartTime[backcolor=transparent]=[backcolor=transparent]2011[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]11T15[backcolor=transparent]:[backcolor=transparent]00[backcolor=transparent]:[backcolor=transparent]00Z
  4. [backcolor=transparent]&[backcolor=transparent]EndTime[backcolor=transparent]=[backcolor=transparent]2013[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]05T15[backcolor=transparent]:[backcolor=transparent]00[backcolor=transparent]:[backcolor=transparent]00Z
  5. [backcolor=transparent]&<公共请求参数>
• 
  返回示例
  XML格式：
  1. [backcolor=transparent] <DescribeBinlogFilesResponse>[backcolor=transparent]
  2. [backcolor=transparent]  [backcolor=transparent]<RequestId>[backcolor=transparent]66816822-CEC1-4C8D-AB26-2530A7D4DCA5[backcolor=transparent]</RequestId>
  3. [backcolor=transparent]  [backcolor=transparent]<TotalRecordCount>[backcolor=transparent]1[backcolor=transparent]</TotalRecordCount>
  4. [backcolor=transparent]  [backcolor=transparent]<PageNumber>[backcolor=transparent]1[backcolor=transparent]</PageNumber>
  5. [backcolor=transparent]  [backcolor=transparent]<PageRecordCount>[backcolor=transparent]1[backcolor=transparent]<PageRecordCount>
  6. [backcolor=transparent]  [backcolor=transparent]<Items>
  7. [backcolor=transparent]    [backcolor=transparent]<BinLogFile>
  8. [backcolor=transparent]    [backcolor=transparent]<FileSize>[backcolor=transparent]123[backcolor=transparent]</FileSize>
  9. [backcolor=transparent]    [backcolor=transparent]<LogBeginTime>[backcolor=transparent]2013-06-01T15:00:00Z[backcolor=transparent]</LogBeginTime>
  10. [backcolor=transparent]     [backcolor=transparent]<LogEndTime>[backcolor=transparent]2013-06-02T18:00:00Z[backcolor=transparent]</LogEndTime>
  11. [backcolor=transparent]     [backcolor=transparent]<DownloadLink>[backcolor=transparent]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[backcolor=transparent]</DownloadLink>
  12. [backcolor=transparent]    [backcolor=transparent]<LinkExpiredTime>[backcolor=transparent]2013-06-09T18:00:00Z[backcolor=transparent]</LinkExpiredTime>
  13. [backcolor=transparent]   [backcolor=transparent]</BinLogFile>
  14. [backcolor=transparent]  [backcolor=transparent]</Items>
  15. [backcolor=transparent]</DescribeBinlogFilesResponse>
  
  JSON格式：
  1. [backcolor=transparent]{
  2. [backcolor=transparent]    [backcolor=transparent]"RequestId"[backcolor=transparent]:[backcolor=transparent]"66816822-CEC1-4C8D-AB26-2530A7D4DCA5"
  3. [backcolor=transparent]"PageNumber"[backcolor=transparent]:[backcolor=transparent]1[backcolor=transparent],
  4. [backcolor=transparent]"TotalRecordCount"[backcolor=transparent]:[backcolor=transparent]1[backcolor=transparent],
  5. [backcolor=transparent]"PageRecordCount"[backcolor=transparent]:[backcolor=transparent]1
  6. [backcolor=transparent]"Items"[backcolor=transparent]:
  7. [backcolor=transparent]{[backcolor=transparent]"BinLogFile"[backcolor=transparent]:
  8. [backcolor=transparent][
  9. [backcolor=transparent]{
  10. [backcolor=transparent]FileSize[backcolor=transparent]:”[backcolor=transparent]123[backcolor=transparent]”
  11. [backcolor=transparent]LogBeginTime[backcolor=transparent]:”[backcolor=transparent]2013[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]01T15[backcolor=transparent]:[backcolor=transparent]00[backcolor=transparent]:[backcolor=transparent]00Z[backcolor=transparent]”
  12. [backcolor=transparent]LogEndTime[backcolor=transparent]:”[backcolor=transparent]2013[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]02T18[backcolor=transparent]:[backcolor=transparent]00[backcolor=transparent]:[backcolor=transparent]00Z[backcolor=transparent]”
  13. [backcolor=transparent]DownloadLink[backcolor=transparent]:”[backcolor=transparent]http[backcolor=transparent]:[backcolor=transparent]//rdslog-real.oss.aliyuncs.com/custins47742/hostins46770/mysql-bin.000120.zip?spm=0.0.0.0.eMQKjs&OSSAccessKeyId=c9gzsqpauj3duw5whwdv40hb&Expires=1384916927&Signature=07TMgM3G2Jw4sOO6yN8nWDgBJPA%3D”
  14. [backcolor=transparent]LinkExpiredTime[backcolor=transparent]”[backcolor=transparent]2013[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]09T18[backcolor=transparent]:[backcolor=transparent]00[backcolor=transparent]:[backcolor=transparent]00Z[backcolor=transparent]”
  15. [backcolor=transparent]}
  16. [backcolor=transparent]]
  17. [backcolor=transparent]}
  18. [backcolor=transparent]}