Hi Team, have a MySQL to Snowflake Log Based Repli...
# troubleshooting
s
Hi Team, have a MySQL to Snowflake Log Based Replication and had below settings for MySQL. Recently, migrated the source from MySQL to Aurora MySQL ( Binlogs are only available on writer instance, not on reader instance which incase a MySQL Read Replica had binlog). When ever there is a long running pipeline, RollbackSegmentHistoryListLength increases. Is any sql session parameter affecting this ? Did anyone else face the same issue ?
Copy code
"name": "session_sqls",
      "kind": "array",
      "value": [
        "SET @@session.time_zone='+0:00'",
        "SET @@session.wait_timeout=28800",
        "SET @@session.net_read_timeout=3600",
        "SET @@session.innodb_lock_wait_timeout=3600"
      ],
      "label": "Session SQLs",
      "description": "List of SQL commands to run when a connection made. This allows to set session variables dynamically, like timeouts."
👀 1