Hi Guys, I'm a lurker on this list but I have decided to come out of my shell for a moment. I a previous job I was the Oracle DBA for my development team. We had a persistent problem with Oracle corrupting the development database. Oracle had no idea with the problem was even after I sent them a copy of the data files. I eventually traced the problem to a flaky memory chip in the development database server. We replaced the chip, reinstalled Oracle and the problem went away.
Now, the lessons learned from this story; No database server software can account for all possible conditions. Regardless of the database, you will have an event at some point in time that causes database corruption. It's like death and taxes. It's going to happen. Deal with it. Create a good backup strategy, a good disaster recovery plan and practice doing restores at least once a month. Expecting the software to save you from all situations is just a bad idea. John Griffin -----Original Message----- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:36 PM To: Michael T. Babcock Cc: [EMAIL PROTECTED]; Muruganandam Subject: Re: Can MySQL handle 120 million records? I guess you can say I'm a follower. Other DB systems have been in use for years, so their reliability has been generally proven through use. It's good to know that a lot of people have had success with MySQL, but considering MySQL is the new comer, I'm still a little tepid! At 01:22 PM 12/18/2002 -0500, Michael T. Babcock wrote: >Michael She wrote: >X-MDRcpt-To: [EMAIL PROTECTED] >X-Return-Path: [EMAIL PROTECTED] >X-MDaemon-Deliver-To: [EMAIL PROTECTED] > >>2. Some of the comments in the mySQL manual... people losing data doing >>routine stuff like table optimizations, adding keys, etc. If a database >>is reliable, things like that shouldn't happen. Comments like those in >>the MySQL manual scared me. > > >1) Do you believe this doesn't ever happen with other 'enterprise' level >DB systems? >2) What do you think Microsoft's pages would look like if they allowed >arbitrary user comments (read their newsgroups ...) >3) Those reports should be filed as bugs to be fixed, not added as >comments in the manual. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- 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
