The mysql-replay-module is a TCPCopy extension designed to replay MySQL sessions, enabling real-world testing of MySQL applications.
For detailed information, please consult TCPCopy before proceeding.
- git clone git://github.com/session-replay-tools/intercept.git
- cd intercept
- ./configure --with-resp-payload
- make
- make install
- git clone git://github.com/session-replay-tools/tcpcopy.git
- cd tcpcopy
- git clone git://github.com/session-replay-tools/mysql-replay-module.git
- ./configure --set-protocol-module=mysql-replay-module
- make
- make install
Configure the route commands to direct response packets to the assistant server. For example, assuming 10.110.12.18
is the IP address of the assistant server and 10.110.12.15
is the MySQL client IP address, use the following route command to direct all responses from 10.110.12.15
to the assistant server:
route add -host 10.110.12.15 gw 10.110.12.18
./intercept -F <filter> -i <device>
Note that the filter format is the same as the pcap filter. For example:
./intercept -i eth0 -F 'tcp and src port 3306' -d
In this example, intercept
will capture response packets from a TCP-based application listening on port 3306, using the eth0 network device.
Please note that ip_forward
is not enabled on the assistant server.
a) Configure user password pairs in conf/plugin.conf
within the installation directory.
Format:
user user1@password1,user2@password2,...,userN@passwordN;
For example:
user root@123456;
b) To start tcpcopy
, use the following command:
./tcpcopy -x localServerPort-targetServerIP:targetServerPort -s <intercept server> [-c <ip range>]
For example (assuming 10.110.12.17 is the IP address of the target server):
./tcpcopy -x 3306-10.110.12.17:3306 -s 10.110.12.18
tcpcopy
captures MySQL packets (assuming MySQL listens on port 3306) on the current server, modifies them as needed, and forwards them to port 3306 on 10.110.12.17
(the target MySQL server). It also connects to 10.110.12.18
to request that intercept
forwards the response packets to it.
- User Accounts and Privileges: Both MySQL instances on the target and online servers must have identical user accounts and privileges, though passwords can differ.
- Session Replay: Only complete sessions can be replayed.
- OpenSSL Support: OpenSSL 1.1.0+ is not currently supported.
- Password Plugin Compatibility: MySQL 8.0’s caching_sha2_password is not supported. To test MySQL 8.0 using MySQL 5.7 production flows, use mysql_native_password and ensure that all users involved in the test are configured with the mysql_native_password plugin.
- The
./configure --with-resp-payload
option forintercept
cannot be used together with the./configure
option fortcpcopy
. - tcpcopy with mysql-replay-module only supports the MySQL protocol.
- For additional assistance, visit tcpcopy.
- 2017.03 v1.0 mysql-replay-module released
- 2024.09 v1.0 Open source fully uses English
Have a bug or a feature request? Please open a new issue. Before opening any issue, please search for existing issues.
Copyright 2024 under the BSD license.