mariadb

<redacted by user>

Hi All, I notice that some of our MariaDB 10.3 database have a mixture of MyISAM and InnoDB table types on them. Is it inherently "bad" to have both types of table on the same database? Or doesn't/shouldn't it make any difference? If it is ill-advised, then I guess we'll look into converting...

I am trying to update mariadb from 10.0 to 10.2 on a centos7 with cpanel/whm, but with no success. The problem seems to be that there is no yum repo anymore for mariadb 10.1 and the wizard is trying to do a step by step upgrade from 10.0 to 10.2, by first doing the 10.0 to 10.1 upgrade. The...

When try transfer from a server with Mariadb10.3 to Mysql 8.0 transfer in some databases got error and do not work. However, when do a fullbackup and a restore work always well. Now i need transfer a large site(more then 200G) and transfer is better option (site not stop). Anyone know why in...

Is there a way to upgrade from MySQL to MariaDB when there is no MariaDB option in the WHM MySQL upgrade setting? Thank you Bill

Hi, When I do strace in WHM for the mariadb process I get this output, indicating some errors. Can anyone help me out to ubderstand what this is. Did lots of searching on Google but got stuck. strace: Process 3201 attached restart_syscall(<... resuming interrupted read ...>) = 1 accept4(21...

Mariadb was corrupted. so need to uninstall it and reinstall. already taken the backups of all databases. so how to uninstall it and reinstall mariadb.??? is there any tools available for repair or reinstall mariadb

We made small tweaks on my.cnf according to mysql tuner, and tuning primer, after mariadb got locktables and frooze with default cpanel my.cnf file, but i can't really figure out when the memory will be stabilize usage of mariadb or mariadb 10.5.13 of cpanel or if there a memory leak in cpanel...

My server has really slowed down recently. I think it's due to MySQL. Please find below the results from mysqltuner.pl. -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM...

For improved security, I've blocked the ASN for OVH as their platform is a constant source of annoyance with spam hitting my servers. Unfortunately, I've learned MariaDB hosts their repos on OVH after I noticed failed updates because of the ASN block. Can anyone recommend alternate repos for...

cPanel® Version 100 is now in RELEASE! We are happy to announce that cPanel Version 100 has now been released to the RELEASE tier! What’s new in Version 100? So much! Some of the features we’re most excited about include: Jupiter – A Modern Theme for cPanel WordPress Toolkit Deluxe is now...

Hello, how are you? I notice the upgrade of Maria DB 10.5 creates a rule to turn off the UNIX sockets plugin inside. The same thing is with MySQL 5.7 on a new installation: symbolic-links=0 BUT MARIADB SUPPORT THAT, usually, the recommendation is to remove this line when you install MariaDB...

Before I go ahead and update MariaDB from 10.3 to 10.5 can someone please confirm that 10.5 works correctly with v98 when using remote databases? Manage MySQL® Profiles still shows it only supports : MySQL versions 5.6, 5.7, and 8.0. MariaDB versions 10.1, 10.2, and 10.3. It was my...

I have a problem and need a solution please help I'm in the middle of this. I ordered a new server to transfer all clients to. due to wanting to upgrade to cloudlinux os 8 I got up to updating MySQL to MariaDB and there is no MariaDB on the new server at the moment I have CENTOS 8.4 and Cpanel...

According this page cPanel & WHM version 92 for CentOS 8 | cPanel & WHM Documentation cPanel for Centos 8 (and i understand Almalinux should be the same) supports MariaDB 10.3 and system administrators have the ability to select the default database between MySQL 8 and MariaDB 10.3 only. But...

cPanel & WHM® Version 98 is now in STABLE! We are happy to announce that cPanel, L.L.C. has released cPanel & WHM Version 98 to the STABLE tier! What’s new in Version 98? To see what’s changing in this new version, check out the release notes, as well as the brief highlights below If you have...

Hello there I set the max_allowed_packet value to 4GB for mariadb, but when mariadb is restarted, this value automatically becomes 1GB. Tweak settings > Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration? setting is set to off. In my.cnf content...

When I try to upgrade to MariaDB 10.5 I get the following warnings, can someone help as to whether it is safe or what I need to do?

Hi, I'm on a new installation of v96 on CentOS 8 and when I go to select MariaDB update, only MySQL 8 it's available. I understand that when you choose one branch (MySQL or MariaDB) there's not possible change, but why on fresh installation the user cannot choose it? Also, the default...

Webhost decided to change servers and as part of that, MySQL 5.6 to MariaDB 10.3. Also PHP 7.2 to 7.4. Tested live and test sites on php 7.4 and all worked fine. Tested all that was possible on test server prior to changeover and all was fine. Only thing that could not be tested was our online...