https://github.com/session-replay-tools/MySQL-replay-module
http://blog.csdn.NET/wangbin579/article/details/8950282
项目需求需要安装tcpcopy在线copy流量,测试测试机mysql性能。
10.0.0.95 线上数据库
10.0.0.96测试数据库
10.0.0.97作为assistant server
搭建过程
10.0.0.97
Installation
Getting intercept installed on the assistant server
Git clone git://github.com/session-replay-tools/intercept.git
cd intercept
./configure --with-resp-payload
make
make install
报错的话执行
yum -y install pcre
yum -y install libpcap*
安装完执行
/usr/local/intercept/sbin/intercept -i eth0 -F 'tcp and src port 3306' -d
10.0.0.95 线上数据库安装
Getting tcpcopy installed on the online server
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
安装完执行
/usr/local/tcpcopy/sbin/tcpcopy -x 3306-10.0.0.96:3306 -s 10.0.0.97
10.0.0.96测试数据库
route add -host 客户端IP gw 10.0.0.97
关键所在
就可以在客户端IP 上访问10.0.0.95 线上数据库,然后访问数据包可以实时同步到10.0.0.96上,执行相同的操作。
10.0.0.95线上数据库的日志
[root@mc_a_db95 ~]# tailf /usr/local/tcpcopy/logs/error_tcpcopy.log
10.0.0.97assistant server上的日志
tailf /usr/local/intercept/logs/error_intercept.log