Hi Team, We are working on to sync data from Mysql to Snowflake, everything was working fine However after update of Airbyte, I am getting error

Could not connect with provided configuration. Error: The variable "log_bin" should be set to "ON", but it is "OFF"

Is there any proper documentation steps how do we do it ? As I have to share this to Infra team @kapa.ai Thank you

Hi, It looks like the error you're encountering is related to the

log_bin

variable being set to "OFF" on your MySQL server. For Airbyte to use Change Data Capture (CDC) for MySQL, binary logging must be enabled. Here are the steps to enable binary logging on your MySQL server: ### Step-by-Step Guide to Enable Binary Logging 1. Create a dedicated read-only MySQL user: First, create a dedicated read-only user for replicating data. You can use the following commands:

sql    CREATE USER <user_name> IDENTIFIED BY 'your_password_here';    GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO <user_name>;

2. Enable binary logging on your MySQL server: You must enable binary logging for MySQL replication using CDC. If you are self-managing your MySQL server, configure your MySQL server configuration file with the following properties:

ini    server-id = 223344    log_bin = mysql-bin    binlog_format = ROW    binlog_row_image = FULL    binlog_expire_logs_seconds = 864000

If you are using a cloud provider (AWS, GCP, etc.), they usually provide easy one-click options for enabling the binlog on your source MySQL database. 3. Verify the

log_bin

status: Ensure that the

log_bin

variable is set to "ON". You can verify this by running:

sql    SHOW VARIABLES LIKE 'log_bin';

For more detailed steps, you can refer to the [Airbyte MySQL Source Documentation](https://docs.airbyte.com/integrations/sources/mysql#quick-start). If you continue to face issues, please provide the exact error logs or screenshots, and we can assist you further. Thank you!