I like this feature.
iPlanet Directory (LDAP) Server does this. Slaves redirect update/change
requests to the master and return results to the client transparently as
if the slave was the master.
+------------------------------------------------------------------+
Russell E Glaue, Technologies Engineer & Integrator russ@stripped
Center for the Application of Information Technologies
WIU, 101 Horrabin Hall, 1 University Circle, Macomb, IL 61455
http://www.cait.org
On Wed, 14 Feb 2001, Hroi Sigurdsson wrote:
> Hello MySQL developers.
>
> We are looking into redirecting updates, inserts etc. directly on
> slave servers in a replicated set-up. Instead of having the clients
> figure out where to send updates, the slave will itself forward data
> manipulation queries to the master, wait for the same query from the
> master to arrive and complete, then return the result. The client will
> not know the difference (apart from the delay).
>
> What is the best place to start? We don't want to have a seperate
> proxy process doing the filtering, since authentication by ip address
> will then be impossible from the end-point's view (and to avoid the
> overhead).
>
> Can you point to some sections in the code that would be useful to
> look at? At which point in the code can we look at a query and
> determine whether it should be sent to the master? How are queries
> delimited?
> Is there a general overview/map of mysql server code/design on the
> web? The documentation was a little sparse on that area and I don't
> remember all that much of what was taught in your course (which was
> mostly about custom table handlers).
>
> Thanks for your time,
> --
> Hroi Sigurdsson hroi@stripped
> Netgroup A/S http://www.netgroup.dk
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail internals-thread478@stripped
> To unsubscribe, e-mail <internals-unsubscribe@stripped>
>
>
