DotNetNuke and MySQL

A question that I see a lot of is, "Can DotNetNuke run on top of MySQL". The answer is a bit complicated. I believe there is a MySQL provider out there for it. But, it is a terrible idea to try to run DNN on MySQL. STOP TRYING!

DNN does provide an abstraction layer so that it can be run against multiple databases. And, I believe there is a MySQL provider provided by someone at cost. But, even if you can get the core running against MySQL, it's still a bad idea...

Reason #1: Loss of modules - You would lose the key thing that makes DNN special, Modules. I'm sure some of the core modules are included in the MySQL provider, but, the core modules are just the beginning of DotNetNuke. Y ou would have to create a MySQL provider for every module that you want to use. The cost of doing this would far exceed the cost of using a hosting company that would provide you a shared SQL Server on which you can run DNN.

Reason #2: Performance -The SQL used for DotNetNuke is chock full of Stored Procedures. The Stored Procedures improve the performance and security of the system.

To be continued....