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
|
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]
#
# Lock replica for backup
#
[connection slave]
include/save_error_log_position.inc
LOCK INSTANCE FOR BACKUP;
#
# Flush binary logs so relay log is tried to be purged
#
[connection master]
FLUSH BINARY LOGS;
#
# Check that relay logs have not been purged on replica
#
include/sync_slave_sql_with_master.inc
./slave-relay-bin.000001
./slave-relay-bin.000002
./slave-relay-bin.000003
./slave-relay-bin.000004
include/assert_error_log.inc [server: 2, pattern: Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.
Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.]
#
# Unblock backup on replica
#
include/save_error_log_position.inc
UNLOCK INSTANCE;
#
# Generate log purge from source onto replica
#
[connection master]
FLUSH BINARY LOGS;
#
# Check relay logs have been purged on replica
#
include/sync_slave_sql_with_master.inc
./slave-relay-bin.000005
./slave-relay-bin.000006
include/assert_error_log.inc [server: 2, pattern: NONE]
call mtr.add_suppression("Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.");
#
# Cleanup
#
[connection master]
include/rpl_end.inc
|
