Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Question Unanswered: Routing Reads and Writes to Different Servers

    I am currently forumulating a strategy for our MySQL servers to provide performance, redundancy, backups and high availability.

    I have been reading a lot about MySQL's replication capabilities. Several places recommend routing all write queries (insert, update, etc.) to the master server, and routing all read queries(select) to the slave servers.

    I am wondering how this is accomplished. Is this something that can be set up in MySQL to do this, or is it handled via application logic? Could someone possibly provide an example of this?

    Thanks in advance for any advice!

    Last edited by forgueam; 06-16-06 at 12:00.

  2. #2
    Join Date
    Mar 2005
    Kiev, Ukraine
    I'm also quite interested in such an architecture. If you find a solution somewhere, I would appreciate if you briefly described it here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts