[ic] Request for comments and documentation - multiple server architecture
Thu, 21 Dec 2000 06:51:25 -0500
Quoting Greg Cope (firstname.lastname@example.org):
> Looking throught the code Vend::DBI does do some checking of where the
> statement is a SELECT - so in thoery there is no reason why not as
> within these routines that prepare the statments (i.e. define the $sth
> from a different dbhandle depending on wherethere replication is being
This is definitely possible. If we ever get a real-life instance where I
need to do it, I don't anticipate any trouble. But I wouldn't put something
like that together in a vacuum. Unfortunately, I have little free consulting
time to give away other than what you see on the list, so that will pretty
much depend on Akopia needing it.
> But what logic would be used i.e if its a select do we use a slave, and
> if thats down give up or try another ? Same goes for the Master - does
> it have a backup master ?
I would think your director would handle that.
> Could something like this be put on the Akopia / Interchange "wish list"
All you have to do is enter it in Bugzilla as an enhancement. The better
laid out and thought out it is the better I pay attention. 8-)
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <email@example.com>
The U.S. Senate -- white male millionaires working for YOU! -- Dave Barry