SAP Sybase IQ Multiplex Architecture

SAP Sybase IQ multiplexes have a hybrid cluster architecture that involves both shared and local storage.

Shared storage is used for permanent IQ data and shared temporary data for distributed query processing. Local storage is used for catalog metadata, temporary data, and transaction logs.

Each server has its own temporary store and catalog store.

The shared IQ store and shared temporary store are common to all servers.

• Multiplex Architecture Diagram
  SAP Sybase IQ multiplex nodes may have different roles with different capabilities, unlike other database cluster architectures, which usually follow either a “shared everything” or “shared nothing” architecture.
• Data Storage
  IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and IQ user main dbspaces are shared by all multiplex servers, and all servers need access to the same physical file.
• Multiplex Configuration
  SAP Sybase IQ multiplex configuration requires static and dynamic components.
• Files on Shared Disk Arrays
  SAP Sybase IQ multiplex functionality requires using the same file paths to access files in dbspaces in the shared stores from all nodes.
• Communication Infrastructure
  The servers that participate in the multiplex share messages and data using two frameworks.