MySQL Performance: MySQL => Mysql Replication with write forwarding?

Mysql Replication with write forwarding? [message #2261]

Fri, 23 November 2007 05:23

al.james
Messages: 16
Registered: October 2006

Junior Member

Hi there...

Just a quick question.

It occurs to me that the largest change required in a typical application when scaling from single mysql server to multiple servers in a replicated environment, is enforcing that database reads go to the slave whilst database writes go to the master. Most web application frameworks maintain a single database connection, and it can be alot of work to go through the code and open another whenever a write occurs.

Is there anyway of telling a mysql slave server to pass all write operations up to its master (or the top master in the case of multi level replication)?

This would be great as there would be no changes required, I just change the config file of the slave to forward all writes to its master. 5 mins, tops...

Is this possible?

Report message to a moderator