All Products
Search
Document Center

How to set the binlog_format variable to facilitate database recovery

Last Updated: Dec 05, 2018

DBS offers features such as full backup, incremental backup, and data recovery. To use the service, you need to create a backup plan (DBS instance) and your database configuration and account must meet specific requirements.

Notes on backing up MySQL databases

  1. You need to set the value of the binlog_format variable to row so that the binary log contains complete pre-image and post-image data about DML statements. This facilitates data recovery.
  2. We recommend that you set the value of the binlog_format variable to row to improve the chances of successful data recovery.
  3. When the value of the binlog_format variable is set to row, this only changes the binary log content and does not affect query performance. We recommend that you kill all current connections to your database so that the new setting applies to all subsequent connections to your database.

Procedure

  1. Log on to the DBS console, go to the configuration page of your backup plan, and perform a precheck. If the value of binlog_format is not row, the following message appears:

  2. To set the value of binlog_format to row, log on to your database system and run the following command: set global binlog_format=ROW.

  3. Kill all current connections to your database.