Monday
Dec102007
1 Master, N Slaves
Monday, December 10, 2007 at 12:46AM
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.
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.