| Anthony Small 2005-09-29, 7:24 am |
| I wonder if anyone can comment on what they think would be the best
replication architecture for this scenario below.
- One site with a single main database in the UK for telephone call-centre
bookings are written to the database.
- Another site with a single database in Germany accepting online bookings.
- Data additions or changes can occur at either site and needs to be
available to the other site.
- At the moment the UK site is the main site with an estimated 70% of
activity occurring at the UK site with the rest occurring at the other site.
This ratio is expected to change and is very likely to change.
- If one site fails for any reason the other site will be used instead.
- Bookings are in entered via telephone operators and also via Internet
access. Both sites can be accessed using either method.
- No identity values are being used in the current design but the design
does include text and image data types.
It is anticipated that there would be about 1000 transactions per day but it
is difficult to estimate this. It might on some days be 300 then other days
maybe 3000!
Thanks in advance
Tony S.
|