All nodes in a multiplex configuration are secondary nodes except the coordinator.
One secondary node acts as a designated failover node, the first choice node to assume the coordinator role if the current coordinator is unable to continue.
Demo/Trial Edition: Unlimited secondary nodes
Small Business Edition: None (multiplex not allowed)
Single Application Server Edition: One secondary node
Enterprise Edition: Unlimited secondary nodes (license needed for each)
Can be either read-only nodes (reader nodes) or read-write nodes (writer nodes).
Can run read-only and read-write operations against shared IQ objects.
Can manipulate local data in temporary and SA base tables.
Can run read-only operations against shared IQ objects.
Can manipulate local data in temporary and SA base tables.