Debian Codegraph @

mysql-test/suite/component_keyring_file/r/rpl_binlog_cache_temp_file_encryption.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 include/master-slave.inc
4 Warnings:
5 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
6 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
7 [connection master]
8 # Creating local configuration file for keyring component: component_keyring_file
9 # Creating manifest file for current MySQL server instance
10 [connection slave]
11 # Creating local configuration file for keyring component: component_keyring_file
12 # Creating manifest file for current MySQL server instance
13 [connection master]
14 # ----------------------------------------------------------------------
15 include/rpl_stop_server.inc [server_number=1]
16 include/rpl_start_server.inc [server_number=1]
17 include/rpl_stop_server.inc [server_number=2]
18 include/rpl_start_server.inc [server_number=2]
19 [connection slave]
20 include/start_slave.inc
21 [connection master]
22 CREATE TABLE t1 (c1 TEXT) ENGINE=INNODB;
23 # Adding debug point 'ensure_binlog_cache_temporary_file_is_encrypted' to @@GLOBAL.debug
24 INSERT INTO t1 VALUES (REPEAT('123', 16384.0));
25 # Removing debug point 'ensure_binlog_cache_temporary_file_is_encrypted' from @@GLOBAL.debug
26 SET GLOBAL binlog_encryption=OFF;
27 # Adding debug point 'ensure_binlog_cache_temp_file_encryption_is_disabled' to @@GLOBAL.debug
28 INSERT INTO t1 VALUES (REPEAT('off', 16384.0));
29 # Removing debug point 'ensure_binlog_cache_temp_file_encryption_is_disabled' from @@GLOBAL.debug
30 SET GLOBAL binlog_encryption=ON;
31 # Adding debug point 'ensure_binlog_cache_temporary_file_is_encrypted' to @@GLOBAL.debug
32 INSERT INTO t1 VALUES (REPEAT('on1', 16384.0));
33 # Removing debug point 'ensure_binlog_cache_temporary_file_is_encrypted' from @@GLOBAL.debug
34 # Adding debug point 'ensure_binlog_cache_is_reset' to @@GLOBAL.debug
35 INSERT INTO t1 VALUES ("567");
36 BEGIN;
37 INSERT INTO t1 VALUES ("789");
38 ROLLBACK;
39 # Removing debug point 'ensure_binlog_cache_is_reset' from @@GLOBAL.debug
40 include/sync_slave_sql_with_master.inc
41 include/diff_tables.inc [master:t1,slave:t1]
42 [connection master]
43 DROP TABLE t1;
44 include/sync_slave_sql_with_master.inc
45 [connection master]
46 SET GLOBAL binlog_encryption= OFF;
47 [connection slave]
48 SET GLOBAL binlog_encryption= OFF;
49 SET GLOBAL keyring_operations= ON;
50 # ----------------------------------------------------------------------
51 # Teardown
52 # Removing manifest file for current MySQL server instance
53 # Removing manifest file for current MySQL server instance
54 # Removing local keyring file for keyring component: component_keyring_file
55 # Removing local keyring file for keyring component: component_keyring_file
56 # Removing local configuration file for keyring component: component_keyring_file
57 # Removing local configuration file for keyring component: component_keyring_file
58 include/rpl_end.inc
59 # Restarting server without the manifest file
60 # ----------------------------------------------------------------------