MySQL query based replication


I wish to road-test a MySQL Cluster instance by passing it all query which are executed on InnoDB MySQL instance. I'm not too worried about data integrity on the Cluster at present, this study is focused on the stability and speed of the Cluster.

I do not wish to use statement-based binary log replication as queries which are purely SELECT will not get passed to the Cluster and so will give an incomplete view on performance.

What is the best method for implementing General Query Log based replication between MySQL instances?

Many thanks,

Best Solution

This is an interesting question!

There is , but it doesn't meet your needs, as it doesn't work online (i.e. in near real time).