Re: SELECT queries on replicate DB server

2004-09-28 Thread Gerald Taylor
Thanks, that is a really good answer. Raises a bunch more questions but they're good ones. Jim Grill wrote: My question is: Why would they deem it necessary to use yet a third server? Could it be because the main server and the main slave are constantly being updated and they wouldn't want to

SELECT queries on replicate DB server

2004-09-27 Thread Gerald Taylor
We have a main db server that has a pretty big db and it sometimes gets overloaded. We also have a replicated slave server... every update to the main server writes through to it and it is the one that is backed up to avoid interruption service for the website. There are certain sections of

Re: SELECT queries on replicate DB server

2004-09-27 Thread Jim Grill
My question is: Why would they deem it necessary to use yet a third server? Could it be because the main server and the main slave are constantly being updated and they wouldn't want to overload the main slave(which is not on as high a horsepower of a box I know for a fact). Could it be