These calculations use the following assumptions about the example replication system:
Tables T1 and T2 are in database DB1.
Table T3 is in database DB2.
All three tables are replicated to sites S1, S2, and S3.
The parameters are shown in the following tables (note that not all messages are replicated to all sites).
Database |
Table |
# Cols |
Columns changed |
Change rate (num/sec) |
Row width (bytes) |
Row width changed |
# Sites |
---|---|---|---|---|---|---|---|
DB1 |
T1 |
10 |
5 |
20 |
200 |
100 |
3 |
DB1 |
T2 |
10 |
5 |
10 |
400 |
200 |
2 |
DB2 |
T3 |
120 |
100 |
2 |
1500 |
1000 |
2 |
Table |
Percent of updates to S1 |
Percent of updates to S2 |
Percent of updates to S3 |
---|---|---|---|
T1 |
10% |
40% |
40% |
T2 |
40% |
80% |
0% |
T3 |
20% |
0% |
20% |
Transaction rate |
DB1 |
DB2 |
S1 |
S2 |
S3 |
---|---|---|---|---|---|
Inbound |
20/sec |
20/sec |
- |
- |
- |
Outbound |
- |
- |
5/sec |
10/sec |
8/sec |