Swingbench can now be started to simulate an order-entry system and test the replication.
1. Start a new ssh session to the source server (dbv01) and logon as oracle
| No Format |
|---|
ssh oracle@source-int |
2. Start charbench which is the character based version of swingbench
| No Format |
|---|
cd ~oracle/swingbench/bin
./charbench -cs //source-int/orcl -u oe -p oe -uc 10 -min 10 -max 200 -rt 0:10 -a -v |
The output will be similar to the following and will run for 10 minutes. A total number of 10 users will be simulated.
| No Format |
|---|
Author : Dominic Giles
Version : 2.5.0.909
Results will be written to results.xml.
Time Users TPM TPS
8:39:02 PM 0 0 0
8:39:03 PM 0 0 0
8:39:04 PM 0 0 0
8:39:05 PM 2 0 0
8:39:06 PM 10 10 10
8:39:07 PM 10 23 13 |
3. Optional. Swingbench is highly configurable. The load on the system can be easily increased. In this example, the number of users is set to 40 and the min and max delay is shortened. As a result the TPS peaks at over 400 transactions per second
| No Format |
|---|
[oracle@source bin]$ ./charbench -cs //source-int/orcl -u oe -p oe -uc 40 -min 5 -max 15 -rt 0:10 -a -v users,tpm,tps
Author : Dominic Giles
Version : 2.5.0.909
Results will be written to results.xml.
Time Users TPM TPS
20:53:05 [0/40] 0 0
20:53:06 [0/40] 0 0
20:53:07 [0/40] 0 0
20:53:08 [0/40] 0 0
20:53:10 [31/40] 0 0
20:53:13 [40/40] 440 440
20:53:14 [40/40] 478 38
20:53:18 [40/40] 913 435
20:53:19 [40/40] 967 54
20:53:22 [40/40] 1410 443
20:53:23 [40/40] 1446 36
20:53:25 [40/40] 1745 299
20:53:26 [40/40] 1885 140 |
When we successfully installed DBVisit Replicate product on our RepAttack environment, we should test, how the replication works itself.
This chapter brings some basic examples, that should demonstrate the user how the logical replication works, how are the replicated DMLs transformed, how to use and monitor replicate and how to setup some basic features of replicate such as filtering rows and excluding columns.
Pre-requisites
Please ensure the following pre-requisites have been completed
Follow the step by step guide in the Child Pages below.
| Child pages (Children Display) |
|---|