Informix Warehouse Accelerator architecture options

There are several approaches that you can use to integrate Informix® Warehouse Accelerator into your current system architecture.

You can install the accelerator server on the same computer as your Informix database server, on a separate computer, or on a cluster. There must be a TCP/IP connection between the database server and the accelerator server. If the accelerator server is installed on the same computer as the database server, the connection must be a local loop-back TCP/IP connection.

If the Informix database server is installed in a high-availability cluster environment, you can also reduce the workload on the primary server by using one or more of the secondary servers to accelerate queries. You can also install the accelerator server on a secondary server.

The query optimizer on the database server identifies which data warehouse queries can be accelerated and sends those queries to the accelerator server. The result set is sent back to the database server, which passes the result set back to the client. If the query cannot be processed by the accelerator server, the query is processed on the database server.

The accelerator server and the database server on the same computer

The following figure shows the accelerator server and the database server installed on the same computer.

Figure 1. The accelerator server and the database server installed on the same computer.

Begin figure description - Most of the figure is described by the surrounding text. The figure shows a client computer connected to a symmetric multiprocessing system (SMP). The client is used to send queries to and receive results sets back from the database server. Inside the Informix database server, the query optimizer determines if the accelerator server can process the query. If yes, the query is sent to the accelerator server over a local loopback TCP/IP connection between the database server and the accelerator server. If no, the query is processed by the query optimizer on the database server. - end figure description

The accelerator server and the database server on different computers

The following figure shows the accelerator server and the database server installed on different computers.

Figure 2. The accelerator server and the database server installed on different computers.

Begin figure description - This figure is similar to the previous figure, but shows the accelerator server installed on a separate computer. A client computer is connected to a symmetric multiprocessing system (SMP). - end figure description

The accelerator server installed on a cluster system

The following figure shows the accelerator server installed on a cluster and the database server installed on a separate computer.

Figure 3. The accelerator server installed on a cluster system and the database server installed on a separate computer.

Begin figure description - This figure is similar to the previous figure. It shows the accelerator server installed on a cluster. A client computer is connected to a symmetric multiprocessing system (SMP). A group of cluster nodes is connected to the database server which is used by the administrator to access a set of stored procedures. - end figure description