How stable is MySQL? Here's a quick case study ... Our clients are organizations involved in Electronic Journalism ... Radio and TV news. We produce a suite of applications that permit them to do word processing, document organization, data management (from news wire services), archives, planning and scheduling, etc under a single umbrella. Everything we do is written in C++ with Win32 applications (no Linux front-ends ... yet!).
Originally (1998), we used M$ Server 7 and 2000. Support was a problem, and though the product was relatively stable, we had constant problems because of the complexity of the database server and some quirks that we found to be illogical. Installation was a pain, and customer updates were dreaded by our tech support staff. Getting the right combination of OLE, ODBC, DCOM, etc. was more luck than skill, and the 'middle-tier' approach (using M$'s Option Pack) was always temperamental. In 1999, we began development of some alternatives, including MySQL. At first, our intention was to support several database servers (M$, Oracle, Informix, MySQL, etc.) with a common interface. As our work progressed, it became obvious that MySQL was really the best choice for our target market, so we signed up as an OEM and re-focused our development so we could incorporate MySQL's native interface. Four things happened: - Our applications became far less bloated and began running faster ... even on older hardware - Our installation was greatly simplified, with fewer components to install on servers and client workstations. - Customers who converted from M$ to MySQL began commenting on improved system performance and recommending our product to their peers. - MySQL ... in our experience ... never crashes. Support, on the few occasions we have needed it, has been superb. The ability to converse directly with the software's chief architect (Michael Widenius) as well as the key programmers is unprecedented in my experience (10 years in software development). We now have 86 systems running MySQL. Most are running WinNT or Win2K servers, but a growing number are using Linux, BSD, and True64 Unix servers. We get frequent comments/compliments on stability, and in a few cases, the only time we hear from customers is when the Sales Department contacts them to renew their support agreements. Gerald Jensen ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "José Fernández" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 7:27 PM Subject: Re: How much stable is MySQL in a production environment? On Tue, Sep 24, 2002 at 05:08:30PM +0200, José Fernández wrote: > > Do you know if is a frequent problem that the mysql database damages > suddenly? It is not. > Have you experience with this type of problems? Never. Even running alpha MySQL code I don't see anything that nasty happening. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 49 days, processed 1,042,072,083 queries (242/sec. avg) --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
