Versions Compared

Version Old Version 19 New Version Current
Changes made by

Arjen Visser

Petr Horejs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 -p10022 oracle@192.168.1.197
Note

This uses port forwarding which was setup when Virtual Box was configured (02 - Rep Attack 11g XE Virtual Machines).

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
/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.

No Format
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
Note

It is easy to change the parameters of swingbench to change the load and the time that it runs.

The parameters are:

  • uc. How many users to simulate
  • rt. Run time. How long to run the simulation for
  • min. Transaction think time minimum
  • max. Transaction think time maximum

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.

...

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

  1. Download and install Replicate
  2. One-Way Logical Replication Setup

Follow the step by step guide in the Child Pages below. 

Child pages (Children Display)