On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal <neil@stripped>wrote:
> If server 1 and 2 are on the same local network, I would use
> a cluster.
>
As in NDB ? I've no personal experience with it - save for a sales talk by
MySQL guys some years back where we decided it was useless to us - but I
understand it has quite a few specific limitations that make it suited for a
rather specific range of applications.
> If they are located on physically separate networks,
> I would use master-master replication.
>
If you're on separate networks, you're gonna have trouble maintaining both
performance and perfect replication, regardless of what you do; not to
mention you'll be in performance hell as soon as you want to switch to the
remote master.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
