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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
|
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]
[connection slave]
set @saved_slave_rows_search_algorithms= @@global.slave_rows_search_algorithms;
Warnings:
Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
SET GLOBAL slave_rows_search_algorithms= 'INDEX_SCAN,HASH_SCAN';
Warnings:
Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
[connection master]
CREATE TABLE gtable (doc JSON);
INSERT INTO gtable (doc) VALUES
('{"id": 1, "name": "abcd efgh"}'),
('{"id": 2, "name": "abcd ijk"}');
ALTER TABLE gtable ADD COLUMN gtext JSON
GENERATED ALWAYS AS (JSON_EXTRACT(doc, '$.name')) VIRTUAL;
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET doc = JSON_SET(doc, '$.name', 'abcd lmnopqrstuvxz')
WHERE JSON_EXTRACT(doc, '$.id') = 2;
include/sync_slave_sql_with_master.inc
[connection master]
INSERT INTO gtable(doc) VALUES (NULL);
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET doc = '{ "id": 4, "name": "abc aba" }' where doc IS NULL;
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET doc = NULL WHERE JSON_EXTRACT(doc, '$.id') = 4;
include/sync_slave_sql_with_master.inc
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
[connection master]
CREATE TABLE gtable(id INT, doc JSON, gcol JSON AS (JSON_ARRAY(id, doc)));
INSERT INTO gtable(id, doc) VALUES(10, '{"a": 1}');
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET doc = JSON_REPLACE(gcol, '$[0].a',"a");
include/sync_slave_sql_with_master.inc
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
[connection master]
CREATE TABLE gtable (doc TEXT);
INSERT INTO gtable (doc) VALUES ('point(1 1)'), ('point(2 2)');
ALTER TABLE gtable ADD COLUMN gtext GEOMETRY
GENERATED ALWAYS AS (ST_GEOMFROMTEXT(doc)) VIRTUAL;
UPDATE gtable SET doc = 'POINT(3 3)' WHERE ST_X(ST_GEOMFROMTEXT(doc)) = 2;
INSERT INTO gtable(doc) VALUES (NULL);
UPDATE gtable SET doc = 'POINT(4 4)' where doc IS NULL;
UPDATE gtable SET doc = NULL WHERE ST_X(ST_GEOMFROMTEXT(doc)) = 4;
include/sync_slave_sql_with_master.inc
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
[connection master]
CREATE TABLE gtable(a DOUBLE,
b DOUBLE AS (a * a));
INSERT INTO gtable (a) VALUES (1);
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET a= 2;
include/sync_slave_sql_with_master.inc
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
[connection master]
CREATE TABLE gtable(geo GEOMETRY, gcol GEOMETRY AS (GEOMETRYCOLLECTION(geo, geo)));
INSERT INTO gtable (geo) VALUES (POINT(1, 1));
include/sync_slave_sql_with_master.inc
[connection master]
UPDATE gtable SET geo = LINESTRING(POINT(1, 1), POINT(2, 2));
include/sync_slave_sql_with_master.inc
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE;
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS;
SET @slave_preserver_commit_order_saved= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER;
include/stop_slave.inc
SET GLOBAL replica_parallel_type= 'LOGICAL_CLOCK';
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET GLOBAL replica_parallel_workers= 4;
SET GLOBAL replica_preserve_commit_order= ON;
include/start_slave.inc
CALL mtr.add_suppression("This version of MySQL doesn't yet support 'sorting of non-scalar JSON values'");
[connection master]
CREATE TABLE gtable(id INT, jd JSON, td TEXT,
gcol JSON AS (JSON_OBJECT(id,jd,JSON_KEYS(jd),td)));
INSERT INTO gtable(id,jd,td) VALUES(100, '{"a":1}', 'characters');
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:gtable, slave:gtable]
[connection master]
UPDATE gtable SET jd = JSON_REPLACE(jd, '$[0].a',"a");
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:gtable, slave:gtable]
[connection master]
UPDATE gtable SET jd= JSON_SET(jd, '$.key', '["h","e","l","l","o"]');
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:gtable, slave:gtable]
[connection master]
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
SET @@global.slave_rows_search_algorithms= @saved_slave_rows_search_algorithms;
Warnings:
Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
include/stop_slave.inc
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved;
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved;
SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @slave_preserver_commit_order_saved;
include/start_slave.inc
include/rpl_end.inc
|
