On Tue, Mar 19, 2002 at 10:13:09PM -0500, Young Sul wrote:
> Currently, I mirror the master DB on another server, and can switch over
> if the master dies.
> I'm wondering if others on this list have encountered a similar situation --
> how did
> you finally architect your DB environment?
Build a database server big enough and bad enough to handle any load.
If that was no longer possible (financial constraints or otherwise),
I think we'd start looking to divide the dataset across multiple
servers. Our site services users by region, so we could probably
get away with it without too much of a hassle. We're years away
from this, if ever, though.
We keep expecting to hit a limit any day now, but MySQL has continued to
perform beyond our expectations for years. We haven't even switched
to InnoDB tables yet.
Michael Bacarella | Netgraft Corporation
| 545 Eighth Ave #401
Systems Analysis | New York, NY 10018
Technical Support | 212 946-1038
Managed Services | mbac@stripped