One or more secondary nodes may participate in a Sybase IQ multiplex configuration. 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.
The number of secondary nodes supported depends on the license purchased, as follows:
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)
Secondary nodes:
Can be either read-only nodes (reader nodes) or read-write nodes (writer 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.
Reader nodes:
Can run read-only operations against shared IQ objects.
Can manipulate local data in temporary and SA base tables.
