I have done this, but only with some external programming. I was using Informix, not MySQL, but the principle would be the same. Essentially, I put a layer in between the client and the data base, and it wrote transactions into a FIFO for a slave on each server. The slaves, in turn, took care of all writes to the data bases. The reads were distributed simply by having the clients open different copies of the data base.
Ugly, but it works. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -----Original Message----- From: JM [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2006 6:37 AM To: mysql@lists.mysql.com Subject: Implementing HA w/o clustering hi, how can i spread reads on a non-cluster config? what i have in mind is a master (with a passive box beside) and 2 replicated servers.. unfortunately i can only spread reads and not writes... thanks, DISCLAIMER: This Message may contain confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you received this message in error please notify your Mail Administrator and delete this message immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of GMA New Media, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
