content_image/739353.jpg
2. When you set 

SOURCE_CONNECTION_AUTO_FAILOVER = 1 , set MASTER_RETRY_COUNT  and MASTER_CONNECT_RETRY  to minimal numbers that just allow a few retry attempts with the same source in a short time, in case the connection failure is caused by a transient network outage. Otherwise the asynchronous connection failover mechanism cannot be activated promptly. Suitable values are MASTER_RETRY_COUNT=3  and MASTER_CONNECT_RETRY=10 , which make the replica retry the connection 3 times with 10-second intervals between. 

3. When you set 

SOURCE_CONNECTION_AUTO_FAILOVER = 1 , the replication metadata repositories must contain the credentials for a replication user account that can be used to connect to all the servers on the source list for the replication channel. These credentials can be set using the CHANGE REPLICATION SOURCE TO statement with the MASTER_USER  and MASTER_PASSWORD  options. For more information, see Section 17.4.9, “Switching Sources with Asynchronous Connection Failover” . 

The following table shows the maximum permissible length for the string-valued options. 

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

