Mail Archive Home | c-jdbc List | August 2004 Index
balancing read queries to mysql replicants
- Subject: balancing read queries to mysql replicants
- From: "Crouch, Luke H." <Luke.Crouch@xxxxxxxxxxx>
- Date: Mon, 30 Aug 2004 16:15:38 -0500
using MySQL replication and would like to have our applications' SELECT queries
be distributed to the MySQL slaves, and the write queries (insert, update,
delete) be directed to the MySQL master.
looked at the documentation for a while, but it seems that all of the RAIDb
levels available to configure c-jdbc will attempt to do the replication for
us...executing the writes on all backends. we really don't want this...we'd
rather just have c-jdbc perform the job of filtering read queries to the slaves,
and write queries to the master.
there any example virtualdatabase config files for this type of setup? or can
someone point me to a tutorial for setting up c-jdbc with this kind of
- balancing read queries to mysql replicants,
Crouch, Luke H.
Powered by MHonArc.
Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.