mariadb

  1. C

    Major Issues Lately with MariaDB Upgrades and Updates via WHM

    After going through 2 days of hell in the last few months, I am sharing my thoughts here: 1) I no longer trust anything to do with WHM's ability to run any type of upgrade or update on MariaDB databases. Within the last few months I've had 2 major crashed database incidents due to: a) a more...
  2. E

    cPanel support for MariaDB 10.2

    According to the following: https://docs.cpanel.net/whm/sql-services/mysql-or-mariadb-upgrade/ it says that cPanel supports MariaDB version 10.2, however during the UPCP process the repository can not be found (returns a 404 error). Browsing through other threads, we saw issues with version...
  3. grayloon

    Move MariaDB

    I currently have a web server running cPanel . Sites on that server use a remote database server running MariaDB 10.2 on CentOS 7.9. Due to a dwindling number of sites we host, I'd like to combine servers by moving MariaDB to my cPanel web server. I see there are already some MySQL Community 5.7...
  4. Steve Kemp

    Yum Maria update fails

    I have just notied on one of our servers that we are getting an error when running Yum Update: if i temporarily disable the repo yum completes but anyone know why this would be occuring or how to resolve?
  5. C

    MariaDB Upgrade from 10.5 to 10.6 Failed

    I tried to upgrade mysql but the upgrade failed. My upgrade steps and the error log is below. Initially my site was totally down and throwing 500 errors, and I ran this command which brough it back up: mysql_upgrade -u root -h localhost -p --verbose --force The web site seems to be fine, and I...
  6. charliecres

    error establishing a database connection after upgrade mysql to MariaDB

    Last Night I upgraded MySQL to MariaDB 10.5. Currently, i am using cloudlinux. Now I am facing an error issue" error establishing a database connection"| after per 10-20 minutes it's getting this error for 1-2 minutes. I have tried to fix this. but unable to fix this issue. so need help to...
  7. M

    MariaDB101 mirror issue

    I cannot upgrade cPanel / EasyPHP / MariaDB because of an issue with the following mirror: Repo file: /etc/yum.repos.d/MariaDB101.repo [MariaDB101] name = MariaDB101 baseurl = https://yum.mariadb.org/10.1/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 The update...
  8. S

    Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?

    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...
  9. gdimi

    In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found

    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...
  10. B

    transfer from server with mariadb 10.3 to server with mysql 8.0

    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...
  11. T

    Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM

    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
  12. M

    strace on mariadb process shows errors

    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...
  13. H

    mariadb reinstall

    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
  14. L

    weird Mariadb memory usage

    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...
  15. 7

    Please Help Me Optimize MariaDB, Database is Really Slow

    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...
  16. D

    MariaDB Alternate Mirrors

    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...
  17. cPanelTabby

    cPanel® Version 100 is now in RELEASE!

    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...
  18. N

    unix_socket=OFF | Installation of a new cPanel with MariaDB 10.5

    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...
  19. M

    v98, mariadb 10.5, and remote databases

    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...