Ühel kenal päeval, K, 2006-08-23 kell 13:09, kirjutas Markus Schiltknecht: > 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.
True. But if you have very few writes, then there seems no reason to do sync anyway. > 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