Error 1027 - Unsupported BinLog format

Potential Causes

• The binlog_format server parameter is not set to ROW. Hevo requires the ROW format for log-based replication.

Diagnosis

Launch an SQL prompt and run the following query:

SHOW VARIABLES LIKE 'binlog_format'; # This should return ROW for successful <span class='glossary-term' data-toggle='glossary-tooltip' data-class='glossary-tooltip' data-for='BinLog'>BinLog</span>-based replication

Suggested Actions

• Change the binlog_format parameter to ROW. This ensures that binary replication is row-based, meaning that Events affecting individual rows are captured. Click the link for the respective MySQL variant for steps to do this.

  • Amazon Aurora

  • Amazon RDS MySQL

  • Azure MySQL

  • Generic MySQL

  • Google Cloud MySQL

  • MariaDB MySQL

• Invite another team member with the required privileges to set up the Pipeline. Read Inviting and Moderating Team Members.

Revision History