| 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?
|
|
|
|
|
| Re: Mysql Replication with write forwarding? [message #2270 is a reply to message #2269 ] |
Tue, 27 November 2007 15:48  |
|
| al.james wrote on Tue, 27 November 2007 06:43 |
This leads to the question: How is mysql proxy for performance / reliability. Are any people using it in real life large scale applications?
Our application is very read heavy. Would we see a penalty in read performance using mysql proxy? I have seen the stats on their site and it looks ok, but of course, stats are not the same as real life experience!
Thanks!
|
We're going to do some detailed benchmarks on mysql proxy soon to see how it performs and what load it could be used for. So, stay tuned!
Alexey Kovyrin, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
|
|
|
| Re: Mysql Replication with write forwarding? [message #2272 is a reply to message #2270 ] |
Tue, 27 November 2007 17:17 |
al.james
Messages: 16
Registered: October 2006 |
Junior Member |
|
|
Well thats good. Thanks, looking forward to it! 
[Updated on: Tue, 27 November 2007 17:18]
|
|
|
Members
Search
Help
Register
Login
Home
