Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-287

It is possible to enable encrypt_binlog with no binary logging

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.21-20
    • Component/s: None

      Description

      Hi,
      I am trying to enable encrypt_binlog without binary logging and it is possible to do.
      Initializing as:

      $ ./all_no_cl --innodb_page_size=64K --encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32
      2017-12-31T08:55:49.421259Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
      2017-12-31T08:55:49.424730Z 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536.
      2017-12-31T08:55:52.048119Z 0 [Warning] InnoDB: New log files created, LSN=130886
      2017-12-31T08:55:52.713311Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
      2017-12-31T08:55:52.975787Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 67fb3fd4-ee08-11e7-8f69-002590e9b448.
      2017-12-31T08:55:53.007597Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
      2017-12-31T08:55:53.241275Z 0 [Warning] CA certificate ca.pem is self signed.
      2017-12-31T08:55:53.340024Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
      Server socket: /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/socket.sock with datadir: /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/data
      Server on socket /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/socket.sock with datadir /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/data halted
      Server socket: /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/socket.sock with datadir: /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/data
      [shahriyar.rzaev@qaserver-02 PS301217-5.7.20-18-linux-x86_64-debug]$ ./cl
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 5
      Server version: 5.7.20-18-debug MySQL Community Server (GPL)
      

      Maybe it is suitable not to enable it if there is no binary logging. Because it is going to encrypt binary logs?

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              robert.golebiowski Robert Golebiowski (Inactive)
              Reporter:
              shahriyar.rzayev Shahriyar Rzayev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 8 minutes
                  8m