Message Concentrator

Truxton uses a message bus proxy to minimize the number of connections to the PostgreSQL database server. PostgreSQL creates a new process for every connection to the server. If you have 20 clients, you will have spawned 20 processes on the server. Since Truxton ETL processes use PostgreSQL as the message queue server, it doubles the number of processes on the server since ETLs use one connection for meta data and another for message bus. Using a concentrator reduces the number of connections to the message bus server to the number of machines connecting to the server. All ETL processes will connect to the local message bus server which will have a single connection to the real message bus server.

How It Works

The concentrator is hosted inside the Truxton Service and activated by setting the mqconcentrator option to true. This will cause Truxton to open a socket on port 2525 and wait for incoming connections. The concentrator will connect to the PostgreSQL message queue server and use this single connection to pass message traffic from all clients connected on port 2525.

Truxton Settings

To activate the message bus concentrator, you must tell Truxton Service to be the concentrator and the ETLs to use the concentrator. The mqconcentrator setting tells the Truxton Service to be the server while the mbp setting tells the ETLs which message bus provider to use.

The steps are:

1. Stop the Truxton and Les services

net stop les
net stop truxton

2. Modify TruxtonSettings.xml

  <mqconcentrator>Yes</mqconcentrator>
  <mbp>MBCConnie.dll</mbp>