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
|
include/group_replication.inc [rpl_server_count=3]
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 server1]
[connection server1]
## List Partitioning ##
CREATE TABLE t1 (id int PRIMARY KEY, c2 int)
CHARSET=utf8mb4
PARTITION BY LIST (id)
(PARTITION p1 VALUES in (5, 10, 15),
PARTITION p2 VALUES in (2, 3),
PARTITION p3 VALUES in (11, 21));
include/rpl_sync.inc
[connection server2]
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`id` int NOT NULL,
`c2` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY LIST (`id`)
(PARTITION p1 VALUES IN (5,10,15) ENGINE = InnoDB,
PARTITION p2 VALUES IN (2,3) ENGINE = InnoDB,
PARTITION p3 VALUES IN (11,21) ENGINE = InnoDB) */
INSERT INTO t1 VALUES (05, 2);
INSERT INTO t1 VALUES (10, 5);
INSERT INTO t1 VALUES (03, 1);
INSERT INTO t1 VALUES (100, 50);
ERROR HY000: Table has no partition for value 100
include/rpl_sync.inc
[connection server1]
INSERT INTO t1 VALUES (11, 5);
INSERT INTO t1 VALUES (21, 10);
DELETE FROM t1 WHERE id= 5;
include/rpl_sync.inc
[connection server3]
include/assert.inc ['Check that partition p1 on table t1 has 1 row']
include/assert.inc ['Check that partition p2 on table t1 has 1 row']
include/assert.inc ['Check that partition p3 on table t1 has 2 rows']
DROP TABLE t1;
include/rpl_sync.inc
include/group_replication_end.inc
|
