Skip to main content

Enable Binlog format

Step 1: Create a parameter group​

  1. Go to the RDS console.
  2. To create a new group, click on Parameter groups on the left sidebar menu and then click Create parameter group.
  3. In the Parameter group family field, select the parameter you want to apply.
  4. In the Type field, select DB Cluster Parameter Group.
  5. Name your group and fill in the description field - they are both mandatory.
  6. Click Create.

image

Step 2: Edit binlog_format​

  1. Click on the name of your parameter group.
  2. On the next page, click Edit in the top-right corner.
  3. Type in ‘binlog_format’ in the filter bar.
  4. Change the value of binlog_format to ROW and click Save Changes.

image

Step 3: Apply the change in the DB​

If you want to create a database with a newly created parameter group:

  1. Click on Create database.
  2. Scroll down to the Additional configuration section and extend the collapsible menu.
  3. In the DB cluster parameter group field, select your new group.

image

If you want to modify a database with a newly created parameter group:

  1. Click on Databases in the left sidebar menu.
  2. Click on your database >> Modify.
  3. In the Additional configuration section, change the field value to your parameter group in the DB cluster parameter group field.
  4. Click Continue >> Modify cluster.
  5. You need to Reboot all databases from the Actions menu for the changes to take effect.

image