1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection master]
#
# Install plugin on nmaster.
#
INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.xxx';
SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
FROM information_schema.plugins
WHERE plugin_name LIKE 'ddl_rewriter';
PLUGIN_NAME PLUGIN_TYPE PLUGIN_VERSION PLUGIN_TYPE_VERSION
ddl_rewriter AUDIT 1.0 4.1
include/sync_slave_sql_with_master.inc
SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
FROM information_schema.plugins
WHERE plugin_name LIKE 'ddl_rewriter';
PLUGIN_NAME PLUGIN_TYPE PLUGIN_VERSION PLUGIN_TYPE_VERSION
#
# Create tables.
#
CREATE SCHEMA mysqltest_ddl_rewriter;
USE mysqltest_ddl_rewriter;
CREATE TABLE t1(i int) DATA DIRECTORY = '/tmp';
Warnings:
Note 1105 Query 'CREATE TABLE t1(i int) DATA DIRECTORY = '/tmp'' rewritten to 'CREATE TABLE t1(i int) ' by a query rewrite plugin
CREATE TABLE t2(i int) INDEX DIRECTORY = '/tmp';
Warnings:
Note 1105 Query 'CREATE TABLE t2(i int) INDEX DIRECTORY = '/tmp'' rewritten to 'CREATE TABLE t2(i int) ' by a query rewrite plugin
CREATE TABLE t3(i int) ENCRYPTION = 'n';
Warnings:
Note 1105 Query 'CREATE TABLE t3(i int) ENCRYPTION = 'n'' rewritten to 'CREATE TABLE t3(i int) ' by a query rewrite plugin
#
# Tables on master.
#
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE TABLE t2;
Table Create Table
t2 CREATE TABLE `t2` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE TABLE t3;
Table Create Table
t3 CREATE TABLE `t3` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
include/sync_slave_sql_with_master.inc
#
# Tables on slave.
#
USE mysqltest_ddl_rewriter;
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE TABLE t2;
Table Create Table
t2 CREATE TABLE `t2` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE TABLE t3;
Table Create Table
t3 CREATE TABLE `t3` (
`i` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
#
# Cleanup and uninstall plugin.
#
DROP SCHEMA mysqltest_ddl_rewriter;
UNINSTALL PLUGIN ddl_rewriter;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
