Hi,
Did anyone ever look at http://prometheus.zerodivide.net/mysql_cluster/
I haven't used it myself.
Dick
-----Original Message-----
From: Emiliano [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [midgard] mysql replication and stuff...
Alan Knowles wrote:
> Yes, as per the manual :)
>
> You can send select requests to the slave (eg. localhosts) and it will
> obviously take the load off the master..
> but you _must_ send the update and insert requests to the master..
So it's more a master-slave kind of thing. Replication is complex,
what with multiple 'masters' changing one baseline database. I can see
why tsx would want to eschew that.
Fixing this within midgard is, as yo uwould expect, doable, although
not trivial enough for me to say 'here is the patch'. It'll require
mod_midgard to have two DB connections open, and it'll be yet another
MySQL dependancy introduced. I wonder why MySQL didn't put proxying
code in MySQL to pass through non-select calls to the master. In fact,
short-term, I'd probably create a dedicated proxy to split the
datastream to the local slave and the remote master.
Emile
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
