I have this same problem with a twist. I have multiple mysql servers
setup in a master-slave relationship.
I want all writes to go to 1 system, and all reads to come from a a
group of 4 other systems.
All the databases/tables have the same names, is there an easy way to
manage this circumstance?
I'm currently using embedded Perl instead of native mysql support (even
using sql relay to handle talking to the 4 backend hosts)
Lanny
--- Peter Bowyer <peeebeee@???> wrote:
> On Mon, 22 Nov 2004 12:09:50 -0500, Dominic Germain
> <mailinglists@???> wrote:
> > Is is possible in a configuration file to use more than MySQL
> server?
> >
> > I want to continue to run all queries on the my locally readonly
> > replicated db, but I want cumulate some stats in a table to an
> another
> > server...
>
> Quote both connections in 'mysql_servers'. Make sure you specifiy the
> database names in the queries.
>
> Peter
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users
> Exim details at http://www.exim.org/ ##
>
