I have a Perfect debian 9 server running in a multi server setup with mariadb and ispc 3.1.6 . This server is only running Magento installs that is having db issues which we never had in Mysql so I want to convert to mysql. Is it as simple as: dump all the db data remove db info within ISPC remove mariadb, install mysql, set the mysql multi server grant permissions setup db info in ISPC, import the data?
Did you check the database limit configuration with mysqltuner already? I Use MariaDB on all systems and don't have any problems, so I doubt that this is really a general MariaDB problem. And you might want to set a higher file limit to ensure that you did not hit that limit: https://blog.schaal-24.de/server/error-error-in-accept-too-many-open-files/?lang=en
hi Till, actually my problem is hitting 'too many connections' even on the default 151. And that is due some magento queries aren't completing and I've tuned with mysqltuner and tuning-primer. I highly doubt it's a mysql vs mariadb issue as well. I just need to find what's running those crazy queries.
update: turns out it was a problem with a couple reindexing queries in standard magento. No need to change to mysql. thank you Till.