Each multiplex configuration has one and only one coordinator
node that is capable of read-only and read-write operations and is also
responsible for bookkeeping to manage other nodes.
When you convert an existing simplex server to multiplex, it becomes the coordinator node.
The coordinator node:
- Runs read-only and read-write operations against shared IQ
objects.
- Manages IQ main dbspaces.
- Manipulates local data in SQL Anywhere
system and user tables.
- Coordinates all read-write operations on shared IQ objects, including:
- Shared IQ table locking
- Shared IQ storage management
- Providing global transaction IDs for read-write
transactions involving shared IQ objects
- Maintaining the global catalog
- Controls catalog synchronization for secondary servers
- Performs schema changes on shared IQ store objects
- Performs schema changes on SQL Anywhere
store objects
- Maintains and cleans up object versions