Mark Atwood (fallenpegasus) wrote,
Mark Atwood

Can Zend easily handle read/write splitting and multiple read slave load balancing

I've been posed with an interesting question, and because I don't know Zend very well, I don't have the answer.

I want to do a pretty standard MySQL replication configuration, with one write master and with multiple read slaves. Is there a straightforward way to configure Zend's database interface to split the reads off from the writes, and to load balance the reads?

It can be done with MySQL proxy, but, I like to have as few moving parts as possble, so can it be done without proxy, and without having to completely rewrite the Zend DB interface.
Tags: mysql

  • Post a new comment


    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded