mariadb

  1. spaceman

    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...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 3

    SOLVED Moving to new server no mariadb upgrade

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

    cPanel and Almalinux, can't install mariadb

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

    cPanel & WHM® Version 98 is now in STABLE!

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

    SOLVED mariadb max_allowed_packet problem

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

    SOLVED MariaDB upgrade to 10.5 warnings

    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?
  18. C

    Fresh installation v96 - MariaDB missing

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

    Virtuozzo to kvm server, mySQL to MariaDB, PayPal PayFlow Link fails

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