Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Chris Thomas 1 post 71 karma points
    Nov 30, 2018 @ 11:51
    Chris Thomas

    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 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.

  • Simon Justesen 44 posts 102 karma points
    Nov 30, 2018 @ 13:04
    Simon Justesen

    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 :)


  • Nik 1321 posts 5662 karma points MVP 3x c-trib
    Nov 30, 2018 @ 14:27

    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 :-) )

  • Alex Skrypnyk 5772 posts 21985 karma points MVP 4x admin c-trib
    Sep 04, 2019 @ 15:03
    Alex Skrypnyk

    Umbraco 8 will not support MySQL

Please Sign in or register to post replies

Write your reply to: