content_image/821329.jpg content_image/821333.jpg content_image/821336.jpg
<img src='content_image/821329.jpg'>

The number of times that the replica tries to reconnect to the source before giving up. The default value is 86400 times. A value of 0 means “infinite” , and the replica attempts to connect forever. Reconnection attempts are triggered when the replica reaches its connection timeout (specified by the slave_net_timeout  system variable) without receiving data or a heartbeat signal from the source. Reconnection is attempted at intervals set by the SOURCE_CONNECT_RETRY  | MASTER_CONNECT_RETRY  option of the CHANGE REPLICATION SOURCE TO  | CHANGE MASTER TO statement (which defaults to every 60 seconds). 

This option is deprecated; expect it to be removed in a future MySQL release. Use the SOURCE_RETRY_COUNT  | MASTER_RETRY_COUNT  option of the CHANGE REPLICATION SOURCE TO  | CHANGE MASTER TO  statement instead. 

• --max-relay-log-size= size 

<img src='content_image/821333.jpg'>

The size at which the server rotates relay log files automatically. If this value is nonzero, the relay log is rotated automatically when its size exceeds this value. If this value is zero (the default), the size at which relay log rotation occurs is determined by the value of max_binlog_size . For more information, see Section 17.2.4.1, “The Relay Log” . 

• --relay-log-purge={0|1} 

<img src='content_image/821336.jpg'>

