December 2021 Release Notes

MySQL (v 2.4.0)

Collecting data using binary logs is now available. In order to use binary logs in your data source you need to:

• Have binary logs enabled on the MySQL server:
  • Server version 5.5. and higher
  • Binary logs are enabled on the MySQL server (The log is enabled by starting the server with the --log-bin option)
  • server_id should be set to non-zero value (read more)
  • binlog_format should be set to ROW (read more)
  • row_image should be set to FULL(read more)
  • The following permissions should be set on the connected user:
    • SELECT permission on the database;
    • REPLICATION CLIENT or SUPER permission;
    • REPLICATION SLAVE permission.
• Enable binary logs in the advanced options

Once the binary logs is enabled in Panoply, only tables will be available for selection.