Kbase P53142: How to configure databases when using multiple brokers and Progress Replication.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/19/2010 |
|
Status: Verified
GOAL:
How to configure databases when using multiple brokers and Progress Replication.
GOAL:
Information about configuring Progress Replication source and target databases.
FACT(s) (Environment):
All Supported Operating Systems
Fathom Replication
FIX:
When configuring Progress Replication source and target databases the -n and -Mn values for the source and target database must always match. To accomplish this the configuration may not match the way the source or target databases are actually being used.
When the -n and -Mn values do not match errors such as: The source and target database must be started with identical number of users. (10391), will occur.
The examples below show how to start the source and target databases when the number of servers desired or required differ between the source and target databases, which would result in the inability to start the target database.
NOTE:
The target database should be started first, followed by the source, then the secondary brokers for the source and target databases.
The -Ma, -Mn and -n parameter must be the same for the primary brokers.
-Ma, ?Mn and -n affect the number of supported connections. The transaction table is sized based upon the number of supported connections for the database. The transaction table must be the same size for both databases, otherwise problems will occur.
In the examples below the -Ma parameter value is using default settings for the primary Brokers. However, this parameter may be set differently for the manually started secondary brokers as long as the total number of client connections for all servers does not exceed the -n parameter declared for the primary Brokers.
=================================================
Examples where all users are self service on the Source database:
Example 1 ----------
proserve dbtarget -DBService replagent -S 4501 -n 150 -Mn 22 [ Note: port 4501 is the default listing port for the Repl Agent, if a different port is used the source.repl.properties file must be modified]
proserve dbsource -DBService replserv -S 5555 -n 150 -Mn 22
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S 4GL -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 5 -S sql -H host -N tcp
Example 2 ----------
proserve dbtarget -DBService replagent -S 4501 -n 300 -Mn 43 [ Note: port 4501 is the default listing port for the Repl Agent, if a different port is used the source.repl.properties file must be modified]
proserve dbsource -DBService replserv -S 5555 -n 300 -Mn 43
proserve dbtarget -m3 -Mpb 20 -Ma 5 -S SQL -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S finance -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S taxes -H host -N tcp
==================================================
Examples where Source Database has users other than self service:
Example 3 -----------
proserve dbtarget -DBService replagent -S 4501 -n 300 -Mn 43 [ Note: port 4501 is the default listing port for the Repl Agent, if a different port is used the source.repl.properties file must be modified]
proserve dbsource -DBService replserv -S 5555 -n 300 -Mn 43
proserve dbsource -m3 -Mpb 10 -Ma 10 -S dayshift -H host -N tcp
proserve dbsource -m3 -Mpb 20 -Ma 5 -S SQLsource -H host -N tcp
proserve dbsource -m3 -Mpb 10 -Ma 10 -S Sales -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S Taxes -H host -N tcp
proserve dbtarget -m3 -Mpb 20 -Ma 5 -S SQL -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S finance -H host -N tcp
Example 4 ------------
proserve dbtarget -DBService replagent -S 4501 -n 150 -Mn 22 [ Note: port 4501 is the default listing port for the Repl Agent, if a different port is used the source.repl.properties file must be modified]
proserve dbsource -DBService replserv -S 5555 -n 150 -Mn 22
proserve dbsource -m3 -Mpb 5 -Ma 10 -S SQL -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S 4GL -H host -N tcp
proserve dbtarget -m3 -M.pb 10 -Ma 5 -S finance -H host -N tcp
Example 5 ------------
proserve dbtarget -DBService replagent -S 4501 -n 300 -Mn 42 [ Note: port 4501 is the default listing port for the Repl Agent, if a different port is used the source.repl.properties file must be modified]
proserve dbsource -DBService replserv -S 5555 -n 300 -Mn 42
proserve dbsource -m3 -Mpb 20 -Ma 5 -S SQLsource -H host -N tcp
proserve dbsource -m3 -Mpb 10 -Ma 10 -S Sales -H host -N tcp
proserve dbtarget -m3 -Mpb 10 -Ma 10 -S dayshift -H host -N tcp
proserve dbtarget -m3 -Mpb 30 -Ma 10 -S 4GL -H host -N tcp.