mariadb

  1. A

    Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment?

    Hello, I need to migrate a CentOS 7 server to Almalinux 8 using the transfer tool. Unfortunately I have forgotten to set the desired rdbms (it would have been MariaDB 10.4) and now it's too late (MySQL 8 came by default and can't change to MariaDB any longer). 1. Should it be safe (I don't...
  2. E

    How to load MariaDB 10.3 on a WHM system with MySQL 8.0?

    My server company has installed WHM with MySQL 8.0 and is not responding to my request to change this to MariaDB 10.3. Is it possible for me to do this? Is there a way to achieve this without a WHM reinstall? Can I just reinstall WHM from the current setup so that the DB server gets changed to...
  3. spaceman

    How to make MariaDB 10.11 available on supported OS?

    I notice on this page: https://support.cpanel.net/hc/en-us/articles/1500002121102-What-versions-of-MySQL-and-MariaDB-does-cPanel-support- ...that MariaDB 10.11 is supported by cPanel on both AlmaLinux 8 and CloudLinux 8. I've got one of each of the above servers (and other older ones too), but...
  4. spaceman

    MariaDB upgrade from 10.3 to 10.5 or 10.6?

    I'm getting closer to upgrading from MariaDB 10.3 to either 10.5 or 10.6 on a couple of busy shared servers, one running CL 7.9 and the other CL 8.8. Assuming that: 1. We've taken all the normal precautions, like backing up the database first, in case we need to restore it. 2. We have enough...
  5. WebHostPro

    SOLVED Can you restore a backup with Maria DB MariaDB 10.6 to a server with MySQL 8.0?

    I have new servers that are forced to use MySQL 8.0. How can I migrate and restore accounts that currently use Maria DB MariaDB 10.6? There's no option that I can find to change Maria 10.6 to MySQL 8 Thank you!
  6. spaceman

    SOLVED Will WHM Transfer Tool work if source server is MariaDB 10.5 and target is MariaDB 10.3?

    Hi All, Question: Will WHM Transfer Tool work if source server is running MariaDB 10.5 and target is 10.3? Scenario: I've got two busy multi-tenant servers both running MariaDB 10.3. I've like to upgrade one of them to 10.5 (or 10.6), knowing there's a small possibility that older sites MIGHT...
  7. spaceman

    Selling API access to MariaDB data. Any experiences/recommendations to share?

    Hi All, I have a prospective opportunity to sell data to others from one of our MariaDB databases. What I *don't* want to do is to custom develop an API solution, including all the management of the monitoring, and recurring billing, etc. What I *do* want to do/find is a good SaaS solution to...
  8. U

    MariaDB database files

    My server went down and hosting company issued me a new VPS, I had MariaDB version 10.7 on my server. I have a full Cpanel account backup, but where can I find MariaDB SQL database file of my wordpress website? I searched for /home/username/mysql but nothing found, after finding it how can I...
  9. D

    /var/run/mysqld/ does not get created after reboot

    Hey. We've run into a strange problem lately and we can't figure out what the problem is. On all of our servers that run cPanel and CloudLinux, the /var/run/mysqld/ directory does not get created during a reboot. MariaDB is configured to use /var/run/mysqld/mysqld.pid as the pid file (which is...
  10. B

    MariaDB and System Resolved process tracking

    I keep getting alerts from CSF saying that MariaDB and System Resolved are using excessive resources (running for longer than the threshold). I have added them to the Process Ignore list: exe:/usr/sbin/mariadbd exe:/usr/lib/systemd/systemd-resolved But no luck. Interestingly, I never had to...
  11. W

    Migration from Centos 7 with Mariadb 10.5 to Ubuntu 20.04 with Mysql 8

    I have read that Ubuntu 20.04 comes installed with MYSQL 8 and Cpanel only supports that. My origin server is currently running Mariadb 10.5 (10.6 is the latest) and i plan to use the transfer tool to move each account to the new Ubuntu server with MYSQL 8. Will I have any issues with this...
  12. bloatedstoat

    CL6 with MariaDB 10.3 migrating to CL8 with mySQL 8.

    Hello, I'm prepping for a migration from our trusty CL6 server to a shiny new Almalinux/CL8 server. The cPanel versions are identical, however the database on the source server is MariaDB 10.3 and the out of the box install provisioned to us has mySQL8. I've read on here about removing mySQL8...
  13. W

    Upgrade MySQL 5.7 to MariaDB 10.6

    I want to upgrade my server from MySQL 5.7 to MariaDB 10.6 i want to confirm that if i upgrade it how much time it takes and can i faced any problem after upgradtion. i have 150+ website hosted on my server.
  14. A

    Upgrade MariaDB 10.3 to 10.6

    Hi, I read that MariaDB 10.3 will reach end of life on 25 May 2023. What does that imply? No more updates for this version? We are planning to perform upgrade to 10.6 next month. Is there anything important to take note? Do we need to rewrite some queries? How long does the upgrade takes? If...
  15. T

    MariaDB repo - [Errno 14] HTTPS Error 404 - Not Found

    Any idea on how to resolve this?
  16. A

    What version of MariaDB on AlmaLinux 8 is recommended to migrate from MySQL 5.7?

    Hello, I need to migrate a shared hosting server (with many accounts on it) with MySQL 5.7 / CentOS 7. From what I read, migrating them to MySQL 8 is not recommended due to significant differences between 5.7 and 8.0 so I believe I will install cPanel with MariaDB. Any recommendation for the...
  17. H

    [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table

    Hello, I use Current Version MariaDB 10.6.12-MariaDB During the process of backing up all sites All copying operations succeed except for one site that shows this error while copying the database [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table...
  18. R

    Unable to update from mysql to mariadb

    Hi, i have install a cpanel on new server and want to move on mariadb but whm showing only one option MySQL 8.0. It is not showing other version of mysql and mariadb. How can i move on mariadb?
  19. D

    SOLVED cpanel MariaDB will no longer be supported?

    Hello https://blog.cpanel.com/changes-in-mariadbs-release-schedule/ The cpanel mariadb i see here has made EO, so i understood it, what do you think is the situation? Thansk.
  20. M

    Unable to install with MariaDB on Rocky8

    Tried multiple times now, either with 10.6 or 10.5 info [MariaDB] Enable of yum target: MariaDB105 is already enabled Disabling package module mysql Disabling package module mariadb Last metadata expiration check: 0:00:03 ago on Wed Feb 8 15:26:50 2023. Dependencies resolved...