Scott Haneda wrote:
There are certainly some people who have nothing better to do than preach the benefits of Postgres over MySQL on Slashdot.There is a thread over at /. about WikiMedia being out due to a power outage <http://slashdot.org/articles/05/02/22/0151213.shtml?tid=95>
MySql is getting bashed pretty hard in some cases as apparently, in power failures, you get database corruption. (this is all from the posts, not my opinion at all, I am asking only to learn more) Also, it is mentioned the MySql devs just do not have data corruption from power failure a high priority.
Many are leaning on Postgres. For me, MySql has never let me down (Knock on
PSU) but I have to ask, for more data on this matter. I run MySql on OS X,
I sometimes have to reboot, it comes back up fine, I do however, do nothing
special to shut down mysql, should I be?
The simple fact is that no matter how fancy your software is, if your computer experiences a power outage, you can't *insist* that one particular application somehow protect your data from the fate of everything else on your computer.
We have a UPS connected to our 2 servers. The Linux server is running apcupsd and controlling the Win2k server ( also running apcupsd in slave mode ). Both servers are connected via a crossover cable to each other ( so we don't have to put the network switches on the UPS ).
If WikiMedia can't implement something at least as good as the above, then how can they or anyone else point the finger at MySQL for data corruption? The mind boggles over what they expect.
Having said that, our MySQL server has experienced a power 'issue' ( my boss tripped over the power cord coming from the UPS ). We both turned white :) But MySQL started up OK, rolled back a transaction or 2, and continued on it's way.
There's nothing like a UPS though. Or better yet, a UPS, daily backups, and a transaction log.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
