I was thinking about using my L4 load balancer to handle this type of
stuff, but of course the load balancer can't really tell the difference
between a read and a write. So I was thinking that I might have to
setup two DSN's if I wanted this type of support. one that would be load
balanced, and another that would only go to the master.
Of course that would require me to do some rewriting or search and
replacing of my existing code.
/John
William M Conlon wrote:
I was reading up on mySQL database replication (master and slaves),
and was curious whether witango had any facilities to support
replicated db clusters. I was thinking something in the dsconfig.ini,
maybe that would specify the master (for writes) and the slaves (for
reads).
Then we could just refer to our DSN and let witango figure out where
to connect.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
