From: Johan De Meersman Date: September 2 2010 3:54pm Subject: Re: Replication VS Cluster List-Archive: http://lists.mysql.com/mysql/222804 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e64f8f4a6ffc03048f48d790 --0016e64f8f4a6ffc03048f48d790 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal 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 --0016e64f8f4a6ffc03048f48d790--