mariadb

  1. E

    Errors after upgrade to MariaDB 10.2

    We upgraded to MariaDB 10.2 recently and after that, we are encountering lots of DB errors. Most of the errors are related to SQL queries referencing fields which cannot be null but no value was supplied in the query during insert or update. Can we see a list of the errors through some error...
  2. A

    SOLVED MariaDB Upgrade - The system was not able to ensure the availability of the “MariaDB-client” package

    Hello, I am unable to upgrade from MySQL to MariaDB while using the WHM interface. Software » MySQL/MariaDB Upgrade I follow the steps correctly, choosing the recommended MariaDB 10.1 version. I cannot get past this stage: 2017-09-12 01:27:59 21523 [Note] /usr/sbin/mysqld: Normal shutdown...
  3. J

    MariaDB upgrade fails

    We have a weird situation. Customer's whm/cpanel server crashes due to hardware failure. Can't recover boot partition, so we spin up another vm and restore accounts/system files from latest backup. Turns out the old server was running MariaDB, but we only installed MySQL. After three days of...
  4. DennisMidjord

    MariaDB max_user_connections

    Hi, We have a client that somehow managed to use all 750 allowed connections to our MariaDB server. Process list: pastebin.com/ARMTJvGk I tried setting max_user_connections to 100 but got this error: ERROR 1290 (HY000): The MariaDB server is running with the --max-user-connections=0 option so...
  5. Samet Chan

    SOLVED MariaDB 10.0 to 10.1 or 10.2

    Dear, Is it safe to upgrade newer MariaDB 10.1 or 10.2? I don't want site own database to be corrupted. I'm still used MariaDB 10.0 Thank you.
  6. @home

    SOLVED Can't repair MariaDB table EVENTS

    I have upgraded Mysql to MariaDB a while back but now every time I restart the SQL server I get the error : [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. I Looked up this error and found Event schedule issue But when I try...
  7. N

    Could not increase number of max_open_files to more than 50000

    I have Upgrade MariaDB and getting error: Could not increase number of max_open_files to more than 50000 Startup Log Jul 25 22:43:29 na.mysite.com systemd[1]: Starting MariaDB database server... Jul 25 22:43:30 na.mysite.com mysqld[5440]: 2017-07-25 22:43:30 140009284655232 [Warning]...
  8. S

    Installing mySQL and MariaDB

    Hi, my VPS came preconfigured with MariaDB installed. However, some of the software I'd either like to use or test seem to have issues with it or just aren't coded for it and prefer mySQL. Is there a way to install both databases and let the software use which one is best for it? I'm pretty...
  9. D

    MySQL -> MariaDB security questions

    Hi, This is my first time using WHM/cPanel and I am still busy installing, tweaking and hardening my VPS. I got a couple of questions that I really can't find a clear answer to after querying both the Big G and the cPanel forums/documentation. If anyone knows of (a) thread(s) where the...
  10. S

    MariaDB Upgrade from command line

    This may be documented some where, if so please just point me in the right direction. Is there a way to switch from MySQL to MariaDB from the command-line? Without utilizing the WHM. Doing tasks like this through a command shell is generally easier for me rather than logging into the WHM.
  11. S

    MySQL to MariaDB - what to expect?

    What problems should I expect to encounter if I move from MySQL to MariaDB? Is everything pretty much supporting MariaDB these days? Are there any popular scripts (that are up-to-date) that still don't support or work with MariaDB? Any unpopular scripts (that are up to date) that don't...
  12. C

    MariaDB query bug

    A couple days ago I upgrade cPanel and it upgraded MariaDB to 10.0.31. Since this one of my applications is having a query not work. Below is what my software vendor sent to me. How can I downgrade to 10.0.30 if I need to? This query works: SELECT * FROM (totals) WHERE TotalDate IN (select...
  13. R

    Running MariaDB 10.1 but libmysql version is 5.1.73!

    According to phpMyAdmin, I am running MariaDB 10.1 but my libmysql version is 5.1.73. Is that correct or should it be another version entirely? Server: Localhost via UNIX socket Server type: MariaDB Server version: 10.1.21-MariaDB - MariaDB Server Protocol version: 10 User: [email protected]
  14. K

    Mariadb, what should be in yum.conf ?

    When using MariaDB, what excludes should be in /etc/yum.conf ? We have exclude=courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* mysql* nsd* p0f php* proftpd* pure-ftpd* spamassassin* squirrelmail* And in /etc/yum.repos.d we have CentOS 7 stuff plus: MariaDB100.repo, EA4.repo...
  15. M

    Mysql.service changed on disk

    I recently setup a new cPanel server and after migrating from the pre-installed mysql 5.6 > MariaDB 10.1 I get the following message when restarting mysql: mysql.service changed on disk. Run 'systemctl daemon-reload' to reload units: Warning: mysql.service changed on disk. Run 'systemctl...
  16. H

    Job for mariadb.service failed after data directory move

    Hi everyone, I'm running MariaDB10.0.1, today I had to move my data-directory because the default path (var/lib/mysql) is in my root partition and was causing it to fill up. I moved the data-directory to /home/mysql. I have checked the file permissions and I think they are correct. I have...
  17. G

    MariaDB 10.2.2

    Hi there, When will MariaDB 10.2.2 be available through cPanel? 10.1 has issues that have been fixed, performance improvements and the proper use of the new Barracuda format. I don't want to manually upgrade as I want to keep it integrated with cPanel but the option to have 10.2.2 would be...
  18. K

    Upgrade to MariaDB

    Hi, I'm attempting to upgrade from 5.5 to MariaDB 10.0/10.1 via the MySQL/MariaDB Upgrade feature in WHM. When i upgrading i notice MySQL 5.6 is blocked and i not take much importance because i want to upgrade to MariaDB. When doing the upgrade failing for this error I'm not sure if...
  19. B

    MariaDB sql_mode

    I use MariaDB and when I configure sql_mode in the /etc/my.cnf file it does not work. Sql_mode always retains the same default value.
  20. benito

    Migrate to mariadb with databases in /home

    Hello! It is safe migrate to mariadb if i move all the databases to /home in mysql? Thanks