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.
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Extended SELECT INTO OUTFILE/DUMPFILE

Next topic

Ability to change database for mysqlbinlog

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.2.2.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>