| MYSQL SERVER(backup) ----\
\
| MYSQL SERVER | ---------- | SNIFFER | ------------- | mysql client |
\-------------------------------------/the mysql server connects to the sniffer, the sniffer forwards the packet to the mysql server (and also sets the mysql clients IP address as source ip address so that the traffic can go directly from the mysql server to the mysql client)
the backup server has a normal connection to the sniffer but the sniffer filters out all select statements (removes the overhead)
mysql sniffer easy (1 database)
|mysql server(backup) + sniffscript(if own ip is addressed don't do anything) | ---- | |mysql server(backup) + sniffscript(if own ip is addressed don't do anything) | ---- | bridge/hub | ------ | mysql server | |mysql server(backup) + sniffscript(if own ip is addressed don't do anything) | ---- |