From: Shawn Green
Date: May 25 2010 3:43pm
Subject: Re: MySQL Proxy and Replication
List-Archive: http://lists.mysql.com/replication/1889
Message-Id: <4BFBF00C.6020900@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello Miguel,

Miguel Ara=FAjo wrote:
> Hi.
>=20
> Does anyone knows how mysq-proxy interacts with replication?
> I've never used mysql-proxy, and I need an application that stand betwe=
en the master and the slave to analyze the updates that go through the ma=
ster to the slave. I wonder if I should start with mysq-proxy instead of =
starting from the scratch.
> Thank you.
>=20
> Regards,
> Miguel Ara=FAjo

Have you looked into mysqlbinlog? It can read a relay log just as well=20
as it can read a binary log. The relay logs only contain the changes=20
that the SLAVE IO thread has pulled down from the master and buffered=20
until the SLAVE SQL thread can execute/apply them.

MySQL Proxy generally sits between a client and the server it is trying=20
to connect to. In the case of replication, you would want to put it=20
between the slave and it's master. To do that you would either need to=20
find or write a script that would handle the replication protocol and=20
monitor it for the data you wanted to collect.

What is it you want to know about your replication traffic?

--=20
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN