MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
sync_slave_sql_with_master.inc
1 # ==== Purpose ====
2 #
3 # Waits until the slave SQL thread has been synced, i.e., all events
4 # have been copied over to slave. This is like mtr's built-in command
5 # sync_slave_with_master, but more flexible (e.g., you can set a
6 # custom timeout and you can force it to use GTIDs instead of filename
7 # and offset).
8 #
9 #
10 # ==== Usage ====
11 #
12 # [--let $sync_slave_connection= <connection_name>]
13 # [--let $use_gtids= 1]
14 # [--let $slave_timeout= NUMBER]
15 # [--let $rpl_debug= 1]
16 # --source include/sync_slave_io_with_master.inc
17 #
18 # Must be called on the master. Will change connection to the slave.
19 #
20 # Parameters:
21 #
22 # $use_gtids
23 # If set, uses GTIDs instead of filename and offset for positions.
24 #
25 # $sync_slave_connection
26 # By default, this script switches connection to 'slave'. If
27 # $sync_slave_connection is set, then '$sync_slave_connection' is
28 # used instead of 'slave'.
29 #
30 # $slave_timeout
31 # See include/wait_for_slave_param.inc.
32 #
33 # $rpl_debug
34 # See include/rpl_init.inc
35 
36 
37 --let $include_filename= sync_slave_sql_with_master.inc
38 --source include/begin_include_file.inc
39 
40 --source include/save_master_pos.inc
41 
42 --let $rpl_connection_name= slave
43 if ($sync_slave_connection)
44 {
45  --let $rpl_connection_name= $sync_slave_connection
46 }
47 --source include/rpl_connection.inc
48 
49 --source include/sync_slave_sql.inc
50 
51 --let $include_filename= sync_slave_sql_with_master.inc
52 --let $skip_restore_connection= 1
53 --source include/end_include_file.inc