| 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 |
# ---------------------------------------------------------------------- |