Difference between revisions of "Message Concentrator"
Jump to navigation
Jump to search
(Created page with "<syntaxhighlight lang="xml"> <syslog>localhost</syslog> <syslogport>514</syslogport> <mqconcentrator>Yes</mqconcentrator> <mbp>MBCConnie.dll</mbp> </syntaxhighlight>") |
|||
| Line 1: | Line 1: | ||
| + | Truxton uses a message bus proxy to minimize the number of connections to the [https://www.postgresql.org/ 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. | ||
| + | |||
| + | =TruxtonSettings.xml= | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
<syslog>localhost</syslog> | <syslog>localhost</syslog> | ||
Revision as of 08:37, 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.
TruxtonSettings.xml
<syslog>localhost</syslog>
<syslogport>514</syslogport>
<mqconcentrator>Yes</mqconcentrator>
<mbp>MBCConnie.dll</mbp>
