----- Original Message ----- From: "Kevin Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 8:49 PM Subject: [mail] Re: [HACKERS] 7.4 Wishlist
> Al Sutton wrote: > > Point to Point and Broadcast replication > > ---------------------------------------- > > With point to point you specify multiple endpoints, with broadcast you can > > specify a subnet address and the updates are broadcast over that subnet. > > > > The difference being that point to point works well for cross network > > replication, or where you have a few replicants. I have multiple database > > servers which could have a deadicated class C network that they are all on, > > by broadcasting updates you can cutdown the amount of traffic on that net by > > a factor of n minus 1 (where n is the number of servers involved). > > Yech. Now you can't use TCP anymore, so the underlying replication > code has to handle all the issues that TCP deals with transparently, > like error checking, retransmits, data windows, etc. I don't think > it's wise to assume that your transport layer is 100% reliable. > > Further, this doesn't even address the problem of bringing up a leaf > server that's been down a while. It can be significantly out of date > relative to the other servers on the subnet. > > I suspect you'll be better off implementing a replication protocol > that has the leaf nodes keeping each other up to date, to minimize the > traffic coming from the next level up. Then you can use TCP for the > connections but minimize the traffic generated by any given node. > I wasn't saying that ALL replication traffic must be broadcast, if a specific server needs a refresh when it comes then point to point is fine because only one machine needs the data, and thus broadcasting it to all would load machines with data they didn't need. The aim of using broadcast is to cut down the ongoing traffic, say, for example, I have a cluster of ten database servers I can connect them onto a dedicated LAN shared only by database servers and I would see 10% of the traffic I would get if I were using point to point (this is assuming that the addition of error checking, retransmits, etc. to the broadcast protocol adds a similiar overhead per packet as TCP point to point). If others wish to know more about this I can prepare an overview for how I see it working. [Other points snipped] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]