Recommended Database Backend (1 Viewer)

[schuess]

What is the "Best Practice" or "Recommended" Database back-end that is recommended to the average MP user by the development team?

I believe you get a choice on install...

MySQL or Microsoft SQL Server Express


Which uses less resources, or works more efficiently? Easier to setup, configure, and maintain?


Thanks
schuess

 

[jameson_uk]

MySQL is the default and if you just follow the defaults this will get installed and setup for you.

The main difference is how they handle multi-language stuff but with the small load MP puts on the database there is not a massive amount in it in terms of efficiency / performance and as above either will be configured and setup for you by the installer.

Unless you have reason not to I would suggest you choose the default MySQL installation.

 

[savocanberra]

MySQL had a buggy install and reconfigured. I was forced to use M$ SQL. It terms of resouces MySQL would be better.

 

[Dadeo]

schuess - I saw your comment about this on the Advanced Installation Wiki page as well. I will try to follow the discussions here and get some more info that can assist users in making the choice during installation. Thanks!

 

[Dadeo]

We have now added a new SQL Server page to the Wiki. Infinite.loop has written some general info/guidelines and everyone can add info there.

Thanks for your input schuess.