File: gr_sql_api_max_connections.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 (22 lines) | stat: -rw-r--r-- 1,134 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
#
# WL#13378: Component service to add a "admin" session
#
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. Set max_connections to the value of current connections.
[connection server1]
SET @max_connections_saved = @@GLOBAL.max_connections;
SET @@GLOBAL.max_connections= (CURRENT_CONNECTIONS + 2);
include/assert.inc [max_connections must be the value of current connections]
# 2. Start Group Replication, the connections established
#    through SQL API must not be disallowed due to
#    max_connections being reached.
#    Start Group Replication must succeed.
include/start_and_bootstrap_group_replication.inc
# 3. Clean up.
SET @@GLOBAL.max_connections = @max_connections_saved;
include/group_replication_end.inc
# End of 8.0 tests