Extended mysqlbinlog

Percona Server has implemented compression support for mysqlbinlog in 5.5.35-33.0. This is similar to support that both mysql and mysqldump programs include (the -C, --compress options “Use compression in server/client protocol”). Using the compressed protocol helps reduce the bandwidth use and speed up transfers.

Percona Server has also implemented support for SSL. mysqlbinlog now accepts the SSL connection options as all the other client programs. This feature can be useful with --read-from-remote-server option. Following SSL options are now available:

  • --ssl - Enable SSL for connection (automatically enabled with other flags).
  • --ssl-ca=name - CA file in PEM format (check OpenSSL docs, implies –ssl).
  • --ssl-capath=name - CA directory (check OpenSSL docs, implies –ssl).
  • --ssl-cert=name - X509 cert in PEM format (implies –ssl).
  • --ssl-cipher=name - SSL cipher to use (implies –ssl).
  • --ssl-key=name - X509 key in PEM format (implies –ssl).
  • --ssl-verify-server-cert - Verify server’s “Common Name” in its cert against hostname used when connecting. This option is disabled by default.

Version Specific Information

  • 5.5.35-33.0 mysqlbinlog option --compress introduced
  • 5.5.35-33.0 mysqlbinlog now has all SSL connection options as the rest of the MySQL client programs.

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.