PreferredObserverHosts

The PreferredObserverHosts configurable property allows you to list the hosts that you would prefer as hosts for the master observer when that database is in the primary role.

The value of this property can be changed at any time, regardless of whether Fast-Start Failover is enabled or not, or whether the observer is in an OBSERVED state. The master observer will be changed automatically to an observer running on a higher priority host. Only observers running on hosts specified in the PreferredObserverHosts will observe databases and become the master observer which will initiate a failover in case of loss of the primary database. The observers can be prioritized. The priority range is from 1 to 8 and the default value of the priority is 8. A lower number has a higher priority.

Category Description
Data type String
Valid value A character string that contains one or more host names with priority, separated by comma:
host_name_1:1 [,host_name_n:priority]

Each host name can be any character string for a valid network name, even if there is no observer running on this host when it is set.

Broker default Null
Imported? No
Parameter class Not applicable
Role Primary, standby
Standby type Physical standby and logical standby
Corresponds to Not applicable
Scope Database
Cloud Control name Not applicable