| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
[connection master] |
| 6 |
[Connection Master] |
| 7 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 8 |
VARIABLE_NAME VARIABLE_VALUE |
| 9 |
Innodb_redo_log_enabled ON |
| 10 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 11 |
Variable_name Value |
| 12 |
Innodb_redo_log_enabled ON |
| 13 |
CREATE TABLE tab1(c1 int,c2 text); |
| 14 |
INSERT INTO tab1 VALUES(1,'Test'); |
| 15 |
include/sync_slave_sql_with_master.inc |
| 16 |
[Connection Slave] |
| 17 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 18 |
VARIABLE_NAME VARIABLE_VALUE |
| 19 |
Innodb_redo_log_enabled ON |
| 20 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 21 |
Variable_name Value |
| 22 |
Innodb_redo_log_enabled ON |
| 23 |
SELECT * FROM tab1; |
| 24 |
c1 c2 |
| 25 |
1 Test |
| 26 |
[Connection Master] |
| 27 |
SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1'; |
| 28 |
ALTER INSTANCE DISABLE INNODB REDO_LOG; |
| 29 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 30 |
VARIABLE_NAME VARIABLE_VALUE |
| 31 |
Innodb_redo_log_enabled OFF |
| 32 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 33 |
Variable_name Value |
| 34 |
Innodb_redo_log_enabled OFF |
| 35 |
SELECT innodb_redo_log_archive_start('label1'); |
| 36 |
ERROR HY000: Cannot perform operation as InnoDB redo logging is disabled. Please retry after enabling redo log with ALTER INSTANCE |
| 37 |
CREATE TABLE tab2(c1 int,c2 text); |
| 38 |
INSERT INTO tab2 VALUES(1,'Test'); |
| 39 |
include/sync_slave_sql_with_master.inc |
| 40 |
[Connection Slave] |
| 41 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 42 |
VARIABLE_NAME VARIABLE_VALUE |
| 43 |
Innodb_redo_log_enabled ON |
| 44 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 45 |
Variable_name Value |
| 46 |
Innodb_redo_log_enabled ON |
| 47 |
SET @@global.innodb_redo_log_archive_dirs = 'label2:IRLA_DIRECTORY_1'; |
| 48 |
SELECT * FROM tab1; |
| 49 |
c1 c2 |
| 50 |
1 Test |
| 51 |
SELECT * FROM tab2; |
| 52 |
c1 c2 |
| 53 |
1 Test |
| 54 |
ALTER INSTANCE DISABLE INNODB REDO_LOG; |
| 55 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 56 |
VARIABLE_NAME VARIABLE_VALUE |
| 57 |
Innodb_redo_log_enabled OFF |
| 58 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 59 |
Variable_name Value |
| 60 |
Innodb_redo_log_enabled OFF |
| 61 |
DO innodb_redo_log_archive_start("label2"); |
| 62 |
ERROR HY000: Cannot perform operation as InnoDB redo logging is disabled. Please retry after enabling redo log with ALTER INSTANCE |
| 63 |
[Connection Master] |
| 64 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 65 |
VARIABLE_NAME VARIABLE_VALUE |
| 66 |
Innodb_redo_log_enabled OFF |
| 67 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 68 |
Variable_name Value |
| 69 |
Innodb_redo_log_enabled OFF |
| 70 |
ALTER INSTANCE ENABLE INNODB REDO_LOG; |
| 71 |
DROP TABLE tab1; |
| 72 |
DROP TABLE tab2; |
| 73 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 74 |
VARIABLE_NAME VARIABLE_VALUE |
| 75 |
Innodb_redo_log_enabled ON |
| 76 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 77 |
Variable_name Value |
| 78 |
Innodb_redo_log_enabled ON |
| 79 |
# Set Default value on master side |
| 80 |
SET @@global.innodb_redo_log_archive_dirs = ''; |
| 81 |
include/sync_slave_sql_with_master.inc |
| 82 |
[Connection Slave] |
| 83 |
ALTER INSTANCE ENABLE INNODB REDO_LOG; |
| 84 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled'; |
| 85 |
VARIABLE_NAME VARIABLE_VALUE |
| 86 |
Innodb_redo_log_enabled ON |
| 87 |
SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled'; |
| 88 |
Variable_name Value |
| 89 |
Innodb_redo_log_enabled ON |
| 90 |
# Set Default value on master side |
| 91 |
SET @@global.innodb_redo_log_archive_dirs = ''; |
| 92 |
include/rpl_end.inc |