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
> ...manually...
> 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 | [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
