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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
|
# Verify that NDB SE DDLs are blocked in all MySQL Servers
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
create table t1 (a int) engine ndb;
ERROR HY000: DDLs are disallowed on NDB SE as there is at least one node without MySQL DD support connected to the cluster.
# Verify that the ndb_schema table was not upgraded
Is 'mysql.ndb_schema' table upgraded?
No
# Verify that DDLs are allowed when MySQL Server see all API nodes as
# upgraded to version supporting new MySQL DD
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
set GLOBAL debug="-d,ndb_simulate_upgrade_from_non_dd_version";
create table t1 (a int) engine ndb;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
drop table t1;
Warnings:
Warning 1296 [mysql.ndb_schema] Could not find expected column 'schema_op_id'
# ndb_schema will be upgraded only when a MySQL Server restarts
Is 'mysql.ndb_schema' table upgraded?
No
# Restart first MySQL Server to trigger schema distribution upgrade, the
# other Servers will pick it up gracefully
# restart: --debug=-d,ndb_simulate_upgrade_from_non_dd_version,ndb_schema_skip_create_schema_op_id
# Verify that the ndb_schema table was upgraded
Is 'mysql.ndb_schema' table upgraded?
Yes
Checking mysqld1
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
Checking mysqld2
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
Checking mysqld3
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
Checking mysqld4
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
Checking mysqld5
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
Checking mysqld6
# Verify DDLs and DMLs
create table t1(
pk int not null,
a varchar(37) not null
) engine ndb;
insert into t1 values (1, "hello");
alter table t1 add column b int null default 24;
alter table t1 modify column b int not null;
select * from t1;
pk a b
1 hello 24
drop table t1;
|
