Single Coservers on Each Node of a Multiple-Node Platform

Home | Previous Page | Next Page Configuration > Coserver Configuration > Choosing a Coserver Configuration >

Single Coservers on Each Node of a Multiple-Node Platform

This configuration is best suited to parallel-processing platforms composed of nodes that:

each have 10 or fewer CPUs.
each have an amount of physical memory that is comparable in size to the address space of a single process.
each have enough local disk space to support an equal portion of the data that is required for the intended application, plus a suitable amount of space for temporary tables and sort files.

Important:

For ease of administration, it is recommended that you use the same hardware configuration for all Extended Parallel Server nodes.

The use of multiple nodes allows the workload to be distributed across a high-speed interconnect, network, or bus (in the case of a partitioned SMP computer). Communication is not limited to client connections.

Each coserver requires a coserver-specific section in the ONCONFIG file. Each node requires an entry in the sqlhosts connectivity file and an entry in the operating system hosts network file. For more information, refer to Network-Configuration Files.

Multiple coservers allow parallel processing between the nodes to provide parallelism across coservers. To calculate the number of CPUs available to the database server, you can multiply NUMCPUVPS by the number of COSERVER parameters listed in the ONCONFIG file.