Ühel kenal päeval, K, 2006-08-23 kell 13:09, kirjutas Markus
> Hannu Krosing wrote:
> > But any sync _replication_ system will have severe impact on
> > performance. My guess is that for a full sync replication, going from 1
> > server to 2 will actually lower performance andsome small gains would be
> > possible only starting from 3rd server.
> Only testing will show concrete results, but for sure such a general 
> answer does not make much sense. It all depends very much on the type of 
> your load. Especially the read/write ratio is very important. 


But if you have very few writes, then there seems no reason to do sync

> Another important factor is the amount of conflicting transactions.

That too, but just the need to do *any* locking on all nodes will
significantly slow down sync replication

> > My quess is based on using standard 100Gb ethernet. It may be possible
> > to do better on some more advanced interconnects like myrinet.
> 100Gb ethernet already sounds very advanced... ;-)

Yeah, I meant some mix of 100Mb and 1Gb ;)

> Regards
> Markus
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to