Jesse Erlbaum writes:
> Hey All!
>
> I have been evaluating MySQL and using it on internal production machines for
> a while now (>1 year). I am now in a position where I have a new application
> which is being specified, and it has a great need to be able to scale up to a
> large load.
>
> The database engine I specify will be used by a web site which may have
> Yahoo-level traffic. In practice, this means at LEAST one SELECT per web
> request, and possibly one UPDATE per request, as well. In addition to this,
> there will be application use -- more complex queries hitting the same
> database.
>
> If I specify Oracle, I can stick additional machines in a cluster to scale up
> performance (and provide fail-over fault tolerance). I understand that MySQL
> is considerably faster than Oracle, but as usage grows where can I go (besides
> buying bigger and bigger servers)? Does MySQL have any capability to cluster
> additional machines? Is there a documented way to handle automatic fail-over?
>
> Is anyone else here using MySQL in a comparable high-load, mission critical
> application?
>
> Thanks for your input! I love MySQL, and I would prefer to stick with it, if
> feasible.
>
> Regards,
>
> -Jesse-
>
>
>
> --
>
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
> Jesse Erlbaum ........... mailto:[EMAIL PROTECTED]
> Lead Programmer/IT Director .. Vanguard Media
> data: 212.242.7685...voice: 212.242.5317 x115
> +-+-+-+-+-+-+- http://www.vm.com/ +-+-+-+-+-+-+-+
Hi!
Beside solutions which Monty pointed out to you, if your site is
going to be THAT crowded you should try few other tips, if you will be
using Linux:
1. Try Reiser FS file system ([EMAIL PROTECTED]) which will provide 10
- 20 % improvement on reading/ writing database files.
2. You should setup RAID 1+0, with which you will get speed plus
security, although this is an expensive solution.
3. If you are using RAID, you can put up a smart RAID (Digital's
Micropolis or similar) and connect several servers to it, which will
give you a certain level of SFT. There are several mechanisms for
distributing work over servers, one being redir mechanism and the
other being famous Beowulf.
This will not aleviate read / write bottleneck, which Monty described,
but it is on TODO list, and it will be done definitely.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
