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. To connect to the first VM from the host machine (laptop), use the following command:
| No Format |
|---|
ssh oracle@source-int-p10022 oracle@192.168.1.197 |
| Note |
|---|
This uses port forwarding which was setup when Virtual Box was configured (02 - Set up NAT network in Virtual Box). 192.168.1.197 is the IP address of the host machine (laptop). Use ifconfig or ipconfig to identify what the local IP address is of the host machine. |
2. Start charbench which is the character based version of swingbench.
| No Format |
|---|
cd ~oracle/u01/oracle/swingbench/bin ./charbench -cs //source-int/orclpdb1 -u oe -p oe -uc 10 -min 10 -max 200 -rt 0:10 -a -v users,tpm,tps |
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.909932 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 |
2. Switch to the session where the Dbvisit Replicate console is running and the replication can be seen to be working
| No Format |
|---|
- Dbvisit Replicate 2.6.00.3735(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 715 and SCN 14587518 (12/28/2013 20:44:38).
APPLY IS running. Currently at plog 715 and SCN 14587446 (12/28/2013 20:44:36).
Progress of replication dbvrep_orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.CUSTOMERS: 98% Mine:372/372 Unrecov:0/0 Applied:365/365 Conflicts:0/0 Last:28/12/2013 20:44:38/OK
OE.ADDRESSES: 98% Mine:372/372 Unrecov:0/0 Applied:365/365 Conflicts:0/0 Last:28/12/2013 20:44:38/OK
OE.CARD_DETAILS: 98% Mine:331/331 Unrecov:0/0 Applied:327/327 Conflicts:0/0 Last:28/12/2013 20:44:38/OK
OE.ORDER_ITEMS: 97% Mine:2636/2636 Unrecov:0/0 Applied:2582/2582 Conflicts:0/0 Last:28/12/2013 20:44:38/OK
OE.ORDERS: 98% Mine:2140/2140 Unrecov:0/0 Applied:2098/2098 Conflicts:0/0 Last:28/12/2013 20:44:39/OK
OE.INVENTORIES: 97% Mine:2577/2577 Unrecov:0/0 Applied:2525/2525 Conflicts:0/0 Last:28/12/2013 20:44:38/OK
OE.LOGON: 98% Mine:2605/2605 Unrecov:0/0 Applied:2554/2554 Conflicts:0/0 Last:28/12/2013 20:44:39/OK
--------------------------------------------------------------------------------------------------------------------------------------------
7 tables listed. |
| Note |
|---|
It is easy to change the parameters of swingbench to change the load and the time that it runs. The parameters are:
All command line options are listed here |
| Tip |
|---|
Put the above command line to run swingbench in a script and call it run_swinbench.sh so that you do not have to remember the full command. |
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.
| Note |
|---|
Your laptop has to be powerful enough to handle this load. |
| No Format |
|---|
/u01/oracle/swingbench/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.932
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 |