| 1 |
include/group_replication.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 server1] |
| 6 |
|
| 7 |
############################################################## |
| 8 |
# 1. Verify that the write_set_encoded memory instrument |
| 9 |
# SHALL be enabled by default. |
| 10 |
include/assert.inc ['There should be 1 entry corresponding to the write_set_encoded in the setup_instruments table for ENABLED=YES'] |
| 11 |
|
| 12 |
############################################################## |
| 13 |
# 2. Verify that the write_set_encoded memory instrument |
| 14 |
# can be disabled by updating ENABLED column of |
| 15 |
# setup_instruments table. |
| 16 |
include/assert.inc ['There should be 1 entry corresponding to the write_set_encoded in the setup_instruments table for ENABLED=YES'] |
| 17 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/write_set_encoded";; |
| 18 |
include/assert.inc ['There should be 1 entry corresponding to the write_set_encoded in the setup_instruments table for ENABLED=NO'] |
| 19 |
|
| 20 |
################################################################# |
| 21 |
# 3. Cleanup |
| 22 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/write_set_encoded";; |
| 23 |
include/group_replication_end.inc |
| 24 |
|
| 25 |
################################################################# |
| 26 |
|
| 27 |
Warnings: |
| 28 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 29 |
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. |
| 30 |
[connection server1] |
| 31 |
|
| 32 |
############################################################## |
| 33 |
# 1. Verify that the Gcs_message_data::m_buffer memory instrument |
| 34 |
# SHALL be enabled by default. |
| 35 |
|
| 36 |
############################################################## |
| 37 |
# 2. Verify that the Gcs_message_data::m_buffer memory instrument |
| 38 |
# can be disabled by updating ENABLED column of |
| 39 |
# setup_instruments table. |
| 40 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/Gcs_message_data::m_buffer";; |
| 41 |
|
| 42 |
################################################################# |
| 43 |
# 3. Cleanup |
| 44 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/Gcs_message_data::m_buffer";; |
| 45 |
|
| 46 |
################################################################# |
| 47 |
|
| 48 |
Warnings: |
| 49 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 50 |
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. |
| 51 |
[connection server1] |
| 52 |
|
| 53 |
############################################################## |
| 54 |
# 1. Verify that the certification_data memory instrument |
| 55 |
# SHALL be enabled by default. |
| 56 |
|
| 57 |
############################################################## |
| 58 |
# 2. Verify that the certification_data memory instrument |
| 59 |
# can be disabled by updating ENABLED column of |
| 60 |
# setup_instruments table. |
| 61 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_data";; |
| 62 |
|
| 63 |
################################################################# |
| 64 |
# 3. Cleanup |
| 65 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_data";; |
| 66 |
|
| 67 |
################################################################# |
| 68 |
|
| 69 |
Warnings: |
| 70 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 71 |
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. |
| 72 |
[connection server1] |
| 73 |
|
| 74 |
############################################################## |
| 75 |
# 1. Verify that the certification_data_gc memory instrument |
| 76 |
# SHALL be enabled by default. |
| 77 |
|
| 78 |
############################################################## |
| 79 |
# 2. Verify that the certification_data_gc memory instrument |
| 80 |
# can be disabled by updating ENABLED column of |
| 81 |
# setup_instruments table. |
| 82 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_data_gc";; |
| 83 |
|
| 84 |
################################################################# |
| 85 |
# 3. Cleanup |
| 86 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_data_gc";; |
| 87 |
|
| 88 |
################################################################# |
| 89 |
|
| 90 |
Warnings: |
| 91 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 92 |
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. |
| 93 |
[connection server1] |
| 94 |
|
| 95 |
############################################################## |
| 96 |
# 1. Verify that the certification_info memory instrument |
| 97 |
# SHALL be enabled by default. |
| 98 |
|
| 99 |
############################################################## |
| 100 |
# 2. Verify that the certification_info memory instrument |
| 101 |
# can be disabled by updating ENABLED column of |
| 102 |
# setup_instruments table. |
| 103 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_info";; |
| 104 |
|
| 105 |
################################################################# |
| 106 |
# 3. Cleanup |
| 107 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_info";; |
| 108 |
|
| 109 |
################################################################# |
| 110 |
|
| 111 |
Warnings: |
| 112 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 113 |
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. |
| 114 |
[connection server1] |
| 115 |
|
| 116 |
############################################################## |
| 117 |
# 1. Verify that the transaction_data memory instrument |
| 118 |
# SHALL be enabled by default. |
| 119 |
|
| 120 |
############################################################## |
| 121 |
# 2. Verify that the transaction_data memory instrument |
| 122 |
# can be disabled by updating ENABLED column of |
| 123 |
# setup_instruments table. |
| 124 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/transaction_data";; |
| 125 |
|
| 126 |
################################################################# |
| 127 |
# 3. Cleanup |
| 128 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/transaction_data";; |
| 129 |
|
| 130 |
################################################################# |
| 131 |
|
| 132 |
Warnings: |
| 133 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 134 |
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. |
| 135 |
[connection server1] |
| 136 |
|
| 137 |
############################################################## |
| 138 |
# 1. Verify that the message_service_received_message memory instrument |
| 139 |
# SHALL be enabled by default. |
| 140 |
|
| 141 |
############################################################## |
| 142 |
# 2. Verify that the message_service_received_message memory instrument |
| 143 |
# can be disabled by updating ENABLED column of |
| 144 |
# setup_instruments table. |
| 145 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/message_service_received_message";; |
| 146 |
|
| 147 |
################################################################# |
| 148 |
# 3. Cleanup |
| 149 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/message_service_received_message";; |
| 150 |
|
| 151 |
################################################################# |
| 152 |
|
| 153 |
Warnings: |
| 154 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 155 |
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. |
| 156 |
[connection server1] |
| 157 |
|
| 158 |
############################################################## |
| 159 |
# 1. Verify that the sql_service_command_data memory instrument |
| 160 |
# SHALL be enabled by default. |
| 161 |
|
| 162 |
############################################################## |
| 163 |
# 2. Verify that the sql_service_command_data memory instrument |
| 164 |
# can be disabled by updating ENABLED column of |
| 165 |
# setup_instruments table. |
| 166 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/sql_service_command_data";; |
| 167 |
|
| 168 |
################################################################# |
| 169 |
# 3. Cleanup |
| 170 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/sql_service_command_data";; |
| 171 |
|
| 172 |
################################################################# |
| 173 |
|
| 174 |
Warnings: |
| 175 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 176 |
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. |
| 177 |
[connection server1] |
| 178 |
|
| 179 |
############################################################## |
| 180 |
# 1. Verify that the mysql_thread_queued_task memory instrument |
| 181 |
# SHALL be enabled by default. |
| 182 |
|
| 183 |
############################################################## |
| 184 |
# 2. Verify that the mysql_thread_queued_task memory instrument |
| 185 |
# can be disabled by updating ENABLED column of |
| 186 |
# setup_instruments table. |
| 187 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/mysql_thread_queued_task";; |
| 188 |
|
| 189 |
################################################################# |
| 190 |
# 3. Cleanup |
| 191 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/mysql_thread_queued_task";; |
| 192 |
|
| 193 |
################################################################# |
| 194 |
|
| 195 |
Warnings: |
| 196 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 197 |
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. |
| 198 |
[connection server1] |
| 199 |
|
| 200 |
############################################################## |
| 201 |
# 1. Verify that the message_service_queue memory instrument |
| 202 |
# SHALL be enabled by default. |
| 203 |
|
| 204 |
############################################################## |
| 205 |
# 2. Verify that the message_service_queue memory instrument |
| 206 |
# can be disabled by updating ENABLED column of |
| 207 |
# setup_instruments table. |
| 208 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/message_service_queue";; |
| 209 |
|
| 210 |
################################################################# |
| 211 |
# 3. Cleanup |
| 212 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/message_service_queue";; |
| 213 |
|
| 214 |
################################################################# |
| 215 |
|
| 216 |
Warnings: |
| 217 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 218 |
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. |
| 219 |
[connection server1] |
| 220 |
|
| 221 |
############################################################## |
| 222 |
# 1. Verify that the consistent_members_that_must_prepare_transaction memory instrument |
| 223 |
# SHALL be enabled by default. |
| 224 |
|
| 225 |
############################################################## |
| 226 |
# 2. Verify that the consistent_members_that_must_prepare_transaction memory instrument |
| 227 |
# can be disabled by updating ENABLED column of |
| 228 |
# setup_instruments table. |
| 229 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_members_that_must_prepare_transaction";; |
| 230 |
|
| 231 |
################################################################# |
| 232 |
# 3. Cleanup |
| 233 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_members_that_must_prepare_transaction";; |
| 234 |
|
| 235 |
################################################################# |
| 236 |
|
| 237 |
Warnings: |
| 238 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 239 |
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. |
| 240 |
[connection server1] |
| 241 |
|
| 242 |
############################################################## |
| 243 |
# 1. Verify that the consistent_transactions memory instrument |
| 244 |
# SHALL be enabled by default. |
| 245 |
|
| 246 |
############################################################## |
| 247 |
# 2. Verify that the consistent_transactions memory instrument |
| 248 |
# can be disabled by updating ENABLED column of |
| 249 |
# setup_instruments table. |
| 250 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions";; |
| 251 |
|
| 252 |
################################################################# |
| 253 |
# 3. Cleanup |
| 254 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions";; |
| 255 |
|
| 256 |
################################################################# |
| 257 |
|
| 258 |
Warnings: |
| 259 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 260 |
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. |
| 261 |
[connection server1] |
| 262 |
|
| 263 |
############################################################## |
| 264 |
# 1. Verify that the consistent_transactions_prepared memory instrument |
| 265 |
# SHALL be enabled by default. |
| 266 |
|
| 267 |
############################################################## |
| 268 |
# 2. Verify that the consistent_transactions_prepared memory instrument |
| 269 |
# can be disabled by updating ENABLED column of |
| 270 |
# setup_instruments table. |
| 271 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_prepared";; |
| 272 |
|
| 273 |
################################################################# |
| 274 |
# 3. Cleanup |
| 275 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_prepared";; |
| 276 |
|
| 277 |
################################################################# |
| 278 |
|
| 279 |
Warnings: |
| 280 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 281 |
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. |
| 282 |
[connection server1] |
| 283 |
|
| 284 |
############################################################## |
| 285 |
# 1. Verify that the consistent_transactions_waiting memory instrument |
| 286 |
# SHALL be enabled by default. |
| 287 |
|
| 288 |
############################################################## |
| 289 |
# 2. Verify that the consistent_transactions_waiting memory instrument |
| 290 |
# can be disabled by updating ENABLED column of |
| 291 |
# setup_instruments table. |
| 292 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_waiting";; |
| 293 |
|
| 294 |
################################################################# |
| 295 |
# 3. Cleanup |
| 296 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_waiting";; |
| 297 |
|
| 298 |
################################################################# |
| 299 |
|
| 300 |
Warnings: |
| 301 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 302 |
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. |
| 303 |
[connection server1] |
| 304 |
|
| 305 |
############################################################## |
| 306 |
# 1. Verify that the consistent_transactions_delayed_view_change memory instrument |
| 307 |
# SHALL be enabled by default. |
| 308 |
|
| 309 |
############################################################## |
| 310 |
# 2. Verify that the consistent_transactions_delayed_view_change memory instrument |
| 311 |
# can be disabled by updating ENABLED column of |
| 312 |
# setup_instruments table. |
| 313 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_delayed_view_change";; |
| 314 |
|
| 315 |
################################################################# |
| 316 |
# 3. Cleanup |
| 317 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_delayed_view_change";; |
| 318 |
|
| 319 |
################################################################# |
| 320 |
|