From: Jay R. A. <jr...@ba...> - 2004-07-11 17:45:13
|
On Sun, Jul 11, 2004 at 11:52:46AM -0500, JT Smith wrote: > The reason I can do this from an application environment is 2 fold. > > 1) The interval that the slaves use to update from the master is > determined largely by the configuration of the slaves to their master. > > 2) As a developer, you control whether your app is reading directly > from the master or from the slave, and presumably you know what your > app needs to do to work properly. True. > From a content viewing point of view, yes the data can be out of date > for a little bit, but that's the whole purpose of caching in a content > environment. Let the data go out of date for a little bit in order to > not stress out the machine. If you're in an environment where cachable > reads need to not be cached, then instead of buying 2 small database > servers and doing replication, buy one motherhog database server and > serve all requests from there. True, but not always practical. In my view, replication is the solution for a) people whose needs exceed one motherhog server (that's a cool adjective; can I steal it? :-) and b) people who want physical distribution to avoid disaster outages. > I'm not trying to be a prick, shun anyone's ideas, or anything else > dickheadish. It's just that: > > 1) This isn't an easy problem to solve in any way that doesn't cause > other problems. You're correct, it's not. > and > > 2) I don't think that the amount of time required to solve this > particular problem is a good investment given that it's not even a > problem yet. Not at the moment... but it's good to think about the final target market at design time. Like David, I'm not a target customer for some time... just a hacker, kibitzing. ;-) Cheers, -- jra -- Jay R. Ashworth jr...@ba... Designer Baylink RFC 2100 Ashworth & Associates The Things I Think '87 e24 St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274 "You know: I'm a fan of photosynthesis as much as the next guy, but if God merely wanted us to smell the flowers, he wouldn't have invented a 3GHz microprocessor and a 3D graphics board." -- Luke Girardi |