MySQL Bugs: #45328: Enable MySQL Proxy to act as a relay between replication nodes

Bug #45328	Enable MySQL Proxy to act as a relay between replication nodes
Submitted:	4 Jun 2009 11:31
Reporter:	Kay Roepke	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Proxy: Core	Severity:	S4 (Feature request)
Version:	0.7.1, 0.8	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	binlog, proxy, replication

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently MySQL Proxy should be able to simply forward packets when being set as the "master" for a replication slave, but none of the callbacks work, making its use in this scenario rather pointless.

How to repeat:
1. Start proxy as
mysql-proxy --proxy-lua-script=./lib/rw-splitting.lua --plugins=proxy 
--proxy-backend-addresses=master_host:master_port

2. Obtain master log information from master.

3. Connect to slave, run CHANGE MASTER command.

4. Run START SLAVE

(same as in bug#36779)

Suggested fix:
Implement the necessary binlog parsing and hook up callbacks to the states in the replication protocol.