Re: [Mysqlfs-general] Seperate the servers to allow different insert/update hosts.

[Andrew R. <ros...@gm...>]

On 14/04/2008, Shane Spencer <sh...@bo...> wrote:
> So, I set up mysql master to slave replication as a test.  It works
>  really stupidly well with mysqlfs for distributing an instant backup
>  offsite somewhere.  I'm hoping to use mysqlfs for some awesome,
>  pointless, evil..
>
>  Any chance you could aid my effort by allowing two DB connections if
>  requested?  One for insert/update and one for all selects?  This would
>  allow changes to go upstream (as well as local w/ good locking).  I
>  know this probably makes your brain twist a bit, but c'mon.  It'll be
>  unsafe, unprotected byte-sex.  You know you wanna do it.


Hi Shane

 Why not use mysql proxy (http://forge.mysql.com/wiki/MySQL_Proxy)
first just to be sure what your doing actually requires "unprotected
byte-sex" ;)

-
Andrew Rose
http://andrew-rose.blogspot.com