File: gr_lower_case_table_names_same.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (31 lines) | stat: -rw-r--r-- 1,381 bytes parent folder | download
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
include/group_replication.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 server1]

## 1.  Verify lower_case_table_names cannot be set while server is
##     running and start GR on server-1.

[connection server1]
SET GLOBAL lower_case_table_names= 1;
ERROR HY000: Variable 'lower_case_table_names' is a read only variable
include/start_and_bootstrap_group_replication.inc

## 2.  Store variables of server-2 for restart.

[connection server2]

## 3A. Test GR start with command when lower_case_table_names matches.

include/start_group_replication.inc
include/assert.inc ['Assert server-1 and server-2 are ONLINE']

## 3B. Test GR start on boot when lower_case_table_names matches.

# restart:--group_replication_start_on_boot=1 --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --lower_case_table_names=1
include/rpl_reconnect.inc

## 4.  Cleanup.

include/group_replication_end.inc