| Author |
Message
|
| lash7273 |
 Posted: Tue Nov 13, 2007 10:14 am Post subject: 2 brokers 1 database |
 |
|
Newbie
Joined: 13 Nov 2007
Posts: 3
|
Hi All,
Can 2 brokers share 1 database ??
thanks in advance. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Nov 13, 2007 10:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Yes.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqsidude |
| Posted: Tue Nov 13, 2007 10:55 am Post subject: |
|
|
Centurion
Joined: 22 Jan 2004
Posts: 148
|
| I guess the brokers should use different schemas though? |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 13, 2007 11:34 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqsidude wrote: |
| I guess the brokers should use different schemas though? |
AFAIK the tables are automatically prefixed with the broker name.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Wed Nov 14, 2007 6:20 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
Brokers of the same version can share the same database schema; records are keyed off the broker's UUID.
Brokers of different versions cannot share the same database schema. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Nov 14, 2007 6:27 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqmatt wrote: |
Brokers of the same version can share the same database schema; records are keyed off the broker's UUID.
Brokers of different versions cannot share the same database schema. |
Thanks - I knew broker id was in there somewhere! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jsware |
| Posted: Thu Nov 15, 2007 5:30 am Post subject: |
|
|
Chevalier
Joined: 17 May 2001
Posts: 455
|
| mqmatt wrote: |
Brokers of the same version can share the same database schema; records are keyed off the broker's UUID.
Brokers of different versions cannot share the same database schema. |
Which means that you have to migrate all brokers sharing the schema from version to version at the same time.
We use 1 database and two schemas.
_________________
Regards
John
The pain of low quaility far outlasts the joy of low price. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 15, 2007 5:41 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| scottj2512 wrote: |
| Which means that you have to migrate all brokers sharing the schema from version to version at the same time. |
Or, you know. Add a new schema for the new version...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
