|
MySQL would not have been my choice for a system with the ambition level of FM. Very few large systems have been built to use it. That said, I doubt if I would change that decision now. MySQL is improving and, correctly used, can probably provide what FM needs.
My question is: why should a database problem should bring down everybody? A large email system is a classic example of a case where segmented databases make sense. Then, in the event of a problem, only a subset of the client base is impacted and recovery is much faster.
As at least other poster mentioned, it is technically feasible to create databases that virtually never fail. Some of the methods needed are not, however, supported yet by MySQL. I think the solution is multiple databases, any of which can be restored if necessary in less than 30 minutes. While none of us like downtime, an occasional half hour outage is something that I think most of us could live with.
|