Re: Replication VS Cluster

2010-09-02 Thread Johan De Meersman
On Thu, Sep 2, 2010 at 5:51 PM, wrote: > Quoting Jangita : > > >> Simply put: I want a solution that ensures that server 2 has all the data >> at server 1 at any point in time; say server 1 suddenly fell into a pond :) >> . I wouldnt want to open server 2 and find the last insert/update/delete >>

Re: Replication VS Cluster

2010-09-02 Thread Johan De Meersman
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

Re: Replication VS Cluster

2010-09-02 Thread a . smith
Quoting Jangita : Simply put: I want a solution that ensures that server 2 has all the data at server 1 at any point in time; say server 1 suddenly fell into a pond :) . I wouldnt want to open server 2 and find the last insert/update/delete missing... Ok so that rules out any asynchro

RE: Replication VS Cluster

2010-09-02 Thread Neil Aggarwal
> Simply put: I want a solution that ensures that server 2 has all the > data at server 1 at any point in time If server 1 and 2 are on the same local network, I would use a cluster. If they are located on physically separate networks, I would use master-master replication. Neil -- Nei

Re: Replication VS Cluster

2010-09-02 Thread Jangita
On 02/09/2010 4:35 p, a.sm...@ukgrid.net wrote: Clustering is a general term, do you know which one you are comparing with replication? Clustering most typically refers to high availability clustering or high performance clustering, which wouldnt necessarily/normally imply any copy of the actual

Re: Replication VS Cluster

2010-09-02 Thread Jangita
On 02/09/2010 4:32 p, Johan De Meersman wrote: On Thu, Sep 2, 2010 at 1:10 PM, Jangita mailto:jang...@jangita.com>> wrote: ... Growth should be linear to the growth of customers, no ? :-) I thought so too; but one customer = 1 customer record, plus all his transactions, and also weirdly

Re: Replication VS Cluster

2010-09-02 Thread a . smith
Clustering is a general term, do you know which one you are comparing with replication? Clustering most typically refers to high availability clustering or high performance clustering, which wouldnt necessarily/normally imply any copy of the actual data. If you want a copy of your data on a

Re: Replication VS Cluster

2010-09-02 Thread Johan De Meersman
On Thu, Sep 2, 2010 at 1:10 PM, Jangita wrote: > Hi Guys, > We have a system that has been running along nicely for the past three > months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal > system; slightly 2 hits per minute but growing exponentally as customers > increase. > Grow

Replication VS Cluster

2010-09-02 Thread Jangita
Hi Guys, We have a system that has been running along nicely for the past three months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal system; slightly 2 hits per minute but growing exponentally as customers increase. We have now bought two servers 12Gb RAM RAID blah blah; and