Send to a Friend

iTony's avatar

What MySQL engine would you recommend?

Asked by iTony (202points) April 17th, 2008

I am working in a school website that it would showcase students work like videos, pictures, articles, news. Normal users would be able to comment, fave, and rate this content.

We are on the database design stage and we are using MySQL for our database management system, but I am not sure which engine to use on this work since I’ve never work on a website this big. The database would be accessed any time the authors (not everybody can upload content) would upload their media content(article, video, music, picture, or game) to the database. Also when the normal user (registered user) would comment, rate, or fave a media content.

Mainly I am wondering about the pluggable engines. I am not sure if I should worry about database transactions and use the InnoDB Engine or not worry about them MyISAM.

Or if you think I should use other engine

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.