> Obviously, the details are vague here, I was just wondering if anyone had > any stories, personal ones, rather than the press announcements, of adopting > MySQL for line of business, critical stuff - what it involved, how it went, > what issues they faced in getting it accepted and so on. > > I'm genuinly interested.
We started a web site with MySQL in 1999 or so. The site ran on a modest little server, sharing it with dozens of other web sites. With success traffic grew and we always figured in 6 months MySQL would never be able to handle the load and we'd have to shell out mega bucks and mega pain for something like Oracle. Our site generated perhaps 5 queries a second back in the day. Every time performance started to drop we've always been able to solve the problem more easily than imagined. Besides throwing hardware at it (which can only go so far), we could always better optimize a query, do some kind of preprocessing, tweak some database settings, etc. I've stopped worrying. It's 2004 and our single server now processes 2000+ queries a second, and the site today is just as fast as it was in 1999 (fast!) What I like best about MySQL is not all of the features that it comes shrink-wrapped with, but that with a little creativity and a few hours of work you can get it to do almost anything you want. MySQL finds a good balance between what the RDBMS should do and what it should leave alone. Maybe this was an accident, maybe it was a sign of technical brilliance--ignoring marketing demands to achieve technical superiority. Regardless, it's to a great effect. I suspect all of the clever and hard work in the world won't get MS SQL Server to do the unconventional. Also, insert obligatory benefits of open source boilerplate here. -- Michael Bacarella 24/7 phone: 1-646-641-8662 Netgraft Corporation http://netgraft.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]