Oracle 5.0, Reference Manual

Page: 1484 / 3232

Replication and Binary Logging Options and Variables
1464
System variables used on replication slaves. The following list describes system variables
for controlling replication slave servers. They can be set at server startup and some of them can be
changed at runtime using
SET
. Server options used with replication slaves are listed earlier in this
section.
•
init_slave
[1464]
Command-Line Format
--init-slave=name
Option-File Format
init_slave
Option Sets Variable Yes,
init_slave
[1464]
Variable Name
init_slave
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
string
This variable is similar to
init_connect
[456] , but is a string to be executed by a slave server each
time the SQL thread starts. The format of the string is the same as for the
init_connect
[456]
variable.
Note
The SQL thread sends an acknowledgment to the client before it
executes
init_slave
[1464] . Therefore, it is not guaranteed that
init_slave
[1464] has been executed when
START SLAVE
returns. See
Section 13.4.2.7, “
START SLAVE
Syntax” , for more information.
•
relay_log
[1464]
Command-Line Format
--relay-log=name
Option-File Format
relay-log
Option Sets Variable Yes,
relay_log
[1464]
Variable Name
relay-log
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
file name
The name of the relay log file.
•
relay_log_index
[1464]
Command-Line Format
--relay-log-index
Option-File Format
relay_log_index
Option Sets Variable Yes,
relay_log_index
[1464]
Variable Name
relay_log_index
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
string