That depends.. I've had pretty great success with later revisions of Umbraco 7, my host UnoEuro runs IIS with a MySQL backend on Linux. But I've only used it on personal projects.
If you're planning larger projects I'd recommend MSSQL, traditionally MySQL has been a 2nd class citizen in Umbraco space. And Linux is very picky about the case-sensitivity in table names, so things might break due to legacy code in Umbraco (there's a MySQL-option to allow case-insensitivity on tables though)
MySQL isn't the recommended database to use, however as Simon mentions, it can work on it.
One thing to consider carefully is that it's possible that plugins might not work so you could be limiting what sort of plugins you can use in your site. It depends very much on how they've been built.
MySQL support is also limited and fixes for issues often take longer to get resolved (although if you are interested you could pull down the Umbraco Source and submit pull requests to resolve any you come across and they would be gratefully accepted :-) )
Umbraco and MySql
Is Umbraco compatible with its database running on Linux MySQL?
I realise it would need to be configured to be case insensitive. I'm aware there were some issues in 7.7 such as https://github.com/umbraco/Umbraco-CMS/pull/2493 which was fixed.
I'm looking into hosting options and wanted to know if AWS RDS MySQL is an option.
Are there any performance considerations, positive or negative, using Umbraco with MySQL rather than Microsoft SQL Server?
I am intending to run my own tests and benchmarks, just wondering if anyone has any thoughts or past experience.
That depends.. I've had pretty great success with later revisions of Umbraco 7, my host UnoEuro runs IIS with a MySQL backend on Linux. But I've only used it on personal projects.
If you're planning larger projects I'd recommend MSSQL, traditionally MySQL has been a 2nd class citizen in Umbraco space. And Linux is very picky about the case-sensitivity in table names, so things might break due to legacy code in Umbraco (there's a MySQL-option to allow case-insensitivity on tables though)
My advice is.. test thoroughly :)
/Simon
MySQL isn't the recommended database to use, however as Simon mentions, it can work on it.
One thing to consider carefully is that it's possible that plugins might not work so you could be limiting what sort of plugins you can use in your site. It depends very much on how they've been built.
MySQL support is also limited and fixes for issues often take longer to get resolved (although if you are interested you could pull down the Umbraco Source and submit pull requests to resolve any you come across and they would be gratefully accepted :-) )
Umbraco 8 will not support MySQL
https://github.com/umbraco/Umbraco-CMS/pull/4143
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.