Syntax

1 SLA sla_name
2 %CLUSTER SLA syntax
2 %GRID or REPLSET SLA syntax
2 %SERVERSET SLA syntax
3? MODE=
3.1! REDIRECT
3.1 PROXY
4? USEALIASES=
4.1! ON
4.1 OFF
5? WORKERS=
5.1! 4
5.1 Number_of_threads
6? HOST=
6.1 host_name
6.1 ip_address
7? NETTYPE=
7.1 drsocssl
7.1 drsoctcp
7.1 onsocssl
7.1 onsoctcp
8? SERVICE=
8.1 port_number
8.1 service_name
9? SQLHOSTSOPT="
9.1+ ,
9.1 option
9.2 "

CLUSTER SLA syntax fragment

1 DBSERVERS=
2 ANY
2.1? POLICY=
2.1.1 ROUNDROBIN
2.1.1! WORKLOAD
2.1.1.1? +SECAPPLYBACKLOG:pages
2+ ,
2 group
2 HDR
2 PRI
2 primary
2 RSS
2 SDS
2 server
3 (1) 

2.0+ ,
2.0.0+ ,
2.0.0 group
2.0.0 HDR
2.0.0 PRI
2.0.0 primary
2.0.0 RSS
2.0.0 SDS
2.0.0 server
2.0 (
2.0.1+ ,
2.0.1 group
2.0.1 HDR
2.0.1 PRI
2.0.1 primary
2.0.1 RSS
2.0.1 SDS
2.0.1 server
2.0.2 )
2.1? POLICY=
2.1.1 ROUNDROBIN
2.1.1! WORKLOAD
2.1.1.1? +SECAPPLYBACKLOG:pages

GRID or REPLSET SLA syntax fragment

1 DBSERVERS=
2 ANY
2.1? POLICY=
2.1.1.0+ +
2.1.1.0! 
2.1.1.0.0? weight*
2.1.1.0.1 WORKLOAD
2.1.1.0! 
2.1.1.0.0? weight*
2.1.1.0.1 FAILURE
2.1.1.0.0? weight*
2.1.1.0.1 LATENCY
2.1.1 ROUNDROBIN
2+ ,
2 group
2  (1) 
2.1+ ,
2.1.0+ ,
2.1.0 group
2.1 (
2.1.1+ ,
2.1.1 group
2.1.2 )
2.1.3? POLICY=
2.1.3.1.0+ +
2.1.3.1.0! 
2.1.3.1.0.0? weight*
2.1.3.1.0.1 WORKLOAD
2.1.3.1.0! 
2.1.3.1.0.0? weight*
2.1.3.1.0.1 FAILURE
2.1.3.1.0.0? weight*
2.1.3.1.0.1 LATENCY
2.1.3.1 ROUNDROBIN

SERVERSET SLA syntax fragment

1 DBSERVERS=
2 ANY
2.1? POLICY=
2.1.1! WORKLOAD
2.1.1 ROUNDROBIN
2+ ,
2 group
2 server
2  (1) 
2.1+ ,
2.1.0+ ,
2.1.0 group
2.1.0 server
2.1 (
2.1.1+ ,
2.1.1 group
2.1.1 server
2.1.2 )
2.1.3? POLICY=
2.1.3.1! WORKLOAD
2.1.3.1 ROUNDROBIN