-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.7.21-20
-
Component/s: None
-
Labels:
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?