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
    0

    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.

  • Simon Justesen 43 posts 100 karma points
    Nov 30, 2018 @ 13:04
    Simon Justesen
    0

    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

  • Nik 1155 posts 4763 karma points MVP 2x c-trib
    Nov 30, 2018 @ 14:27
    Nik
    0

    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 5397 posts 19981 karma points MVP 3x admin c-trib
    Sep 04, 2019 @ 15:03
    Alex Skrypnyk
    0

    Umbraco 8 will not support MySQL

    https://github.com/umbraco/Umbraco-CMS/pull/4143

Please Sign in or register to post replies

Write your reply to:

Draft