Difference between revisions of "Message Concentrator"
| Line 12: | Line 12: | ||
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. | 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. | ||
| − | = | + | =Steps= |
| − | To activate the message bus concentrator, you must tell Truxton Service to be the concentrator and the ETLs to use | + | To activate the message bus concentrator, you must tell the Truxton Service to be the concentrator and the ETLs to use it. |
The <code>mqconcentrator</code> setting tells the Truxton Service to be the server while the <code>mbp</code> setting tells the ETLs which message bus provider to use. | The <code>mqconcentrator</code> setting tells the Truxton Service to be the server while the <code>mbp</code> setting tells the ETLs which message bus provider to use. | ||
| − | + | ==Detailed Steps== | |
1. Stop the Truxton and Les services | 1. Stop the Truxton and Les services | ||
| Line 24: | Line 24: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | 2. | + | 2. Edit the <code>TruxtonSettings.xml</code> file in the "C:\ProgramData\Truxton\Settings" folder. |
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
<mqconcentrator>Yes</mqconcentrator> | <mqconcentrator>Yes</mqconcentrator> | ||
<mbp>MBCConnie.dll</mbp> | <mbp>MBCConnie.dll</mbp> | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | 3. Start the Truxton Service | ||
| + | <syntaxhighlight lang="DOS"> | ||
| + | net start truxton | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | 4. Start the Load Status Monitor Service | ||
| + | <syntaxhighlight lang="DOS"> | ||
| + | net start les | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 17:25, 24 June 2020
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.
Steps
To activate the message bus concentrator, you must tell the Truxton Service to be the concentrator and the ETLs to use it.
The mqconcentrator setting tells the Truxton Service to be the server while the mbp setting tells the ETLs which message bus provider to use.
Detailed Steps
1. Stop the Truxton and Les services
net stop les
net stop truxton
2. Edit the TruxtonSettings.xml file in the "C:\ProgramData\Truxton\Settings" folder.
<mqconcentrator>Yes</mqconcentrator>
<mbp>MBCConnie.dll</mbp>
3. Start the Truxton Service
net start truxton
4. Start the Load Status Monitor Service
net start les
