advertise
« Scalability Developer Competition Launched by GigaSpaces - $25k in prizes | Main | thesimsonstage.ea.com »
Monday
Dec102007

1 Master, N Slaves

Hello all,

Reading the site you can note that "1 Master for writes, N Slaves for reads" scheme is used offen.

How is this implemented? Who decides where writes and reads go? Something in application level or specific database proxies, like Slony-I?

Thanks.

Reader Comments (1)

Usually it's in the application because it knows the configuration. There's also MySQL Proxy (http://forge.mysql.com/wiki/MySQL_Proxy) that will route reads and writes in some future release. I was sure someone already made it do this, but I can't find the reference.

November 29, 1990 | Unregistered CommenterTodd Hoff

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>