File: rpl_source_pos_wait_after_startup.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 (29 lines) | stat: -rw-r--r-- 1,080 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
 
#
# Step 1: setup replication
#
include/master-slave.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 master]
[connection slave]
CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=30, SOURCE_RETRY_COUNT=30;
include/start_slave.inc
[connection master]
create table t1 (a int);
Insert into t1 values(1);
drop  table t1;
include/sync_slave_sql_with_master.inc
#
# Step 2: restart Master
#
[connection master]
include/rpl_restart_server.inc [server_number=1 gtids=on]
#
# Step 3: Wait on positions by setting ignore_gtids_on_sync= 1.
#         The sync_slave_sql_with_master.inc will call SOURCE_POS_WAIT()
#         internally verifying the fix.
#
[connection master]
include/sync_slave_sql_with_master.inc
include/rpl_end.inc