Is there any potential problem if use MyISAM engine in production environment?

asked 2013-07-30 00:39:51 -0500

tkdchen
1 ●1 ●1

As the subject. By using MyISAM is safe for production environment? And does it affect future upgrade?

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2013-08-01 17:04:30 -0500

Evgeny

13177 ●57 ●107 ●219 http://askbot.org/

Yes, the potential problem is due to lack of transactions in that engine and the database may end up in inconsistent state.

We have a number of users we support who are on MySQL, so far no major problems, however I plan to migrate them to Postgres and definitely would not recommend MySQL for the new deployments.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2013-07-30 00:39:51 -0500

Seen: 391 times

Last updated: Aug 01 '13

Is there any potential problem if use MyISAM engine in production environment? edit

1 Answer