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:
ssh -p10022 oracle@192.168.1.197
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
/u01/oracle/swingbench/bin/charbench -cs //source-int/pdb1 -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.
Author : Dominic Giles Version : 2.5.0.932 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. This simulation will take approximately 15 minutes.
Your laptop has to be power enough to handle this load.
/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
Add Comment