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...
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...
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...
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...
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...
I have Upgrade MariaDB and getting error: Could not increase number of max_open_files to more than 50000
Jul 25 22:43:29 na.mysite.com systemd: Starting MariaDB database server...
Jul 25 22:43:30 na.mysite.com mysqld: 2017-07-25 22:43:30 140009284655232 [Warning]...
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?
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...
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.
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...
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...
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]
When using MariaDB, what excludes should be in /etc/yum.conf ?
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:
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...
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...
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...
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...