toru okada wrote: > I can give you two good reasons. LiveJournal and Wikipedia.
They are not reasons to stay away from MySQL, just examples of misconfigured systems and bad behaving OS'es. What might be a reason is that the default configuration of MySQL offers no data integrity protection in case of power failures. By default MySQL uses MyISAM tables which are not even transactional. When you use InnoDB tables MySQL will make the right calls to the OS to protect your data, but it is very common for OS'es to foobar, both Linux and Windows (just go to the Disk Manager in Windows and read the warning about write-back caching and dataloss). I can think of many reasons not to trust MySQL to protect my data, ranging from sloppy foreign keys to crazy NOT NULL implementations, but power outages are not one of them. You just have to take the right precautions (you did pull the plug out of a running disksystem a few times while doing acceptance tests, didn't you?). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
