mariadb

  1. D

    SOLVED Install MySQL 5.6 instead of MariaDB

    OS : Centos 7.6 KVM WHM : v78.0.20 I am running magento 1.9.x & it supports only MySQL 5.6 (Oracle or Percona) . The problem is cpanel by default installs the MariaDB so can you tell me how i can install the MySQL 5.6 & remove the MariaDB . Please tell me the step by step command i am not so...
  2. A

    SOLVED [CPANEL-25892] No repository exists for MariaDB103 with RHEL

    On a fresh installation of cPanel 78.20, I upgraded to MariaDB 10.2 without issue. When attempting to upgrade from MariaDB 10.2 to 10.3, the upgrade stops at Step 4 with the following error. I have attempted to resolve the issue by confirming the Maria DB packages are available both by adding...
  3. S

    Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem

    As MySQL ran out of date I decided to upgrade from MySQL 5.6 to MariaDB 10.3. Unfortunately the migration wizard quits quite early while with the following error I therefore checked where to find the MariaDB-Client package yum list all maria* Loaded plugins: fastestmirror, priorities...
  4. W

    Updating MariaDB to 10.3

    I want to update my current MariaDB 10.2 to 10.3 However, i am currently running WHM 76.0.18. The latest MariaDB they have is 10.2. I am wondering if it is safe to update to 10.3 from the SSH command line and if that will cause any conflicts with WHM 76? I know WHM 78 has MariaDB 10.3 but...
  5. B

    MariaDB 10.3 with MyRocks

    I just upgraded my VPS to cPanel 78.0.1 so I could run MariaDB 10.3. I was hoping to be able to test converting tables to the MyRocks storage engine, which is included in 10.3, I didn't see the option. I also notice my PHP app is reporting the DB server as MySQL(i) 10.2.21-MariaDB-log when...
  6. G

    Upgrade MariaDB to 10.3: backup without mysqldump?

    I can see the warning when I try to do that: In MariaDB® 10.3, the mysqldump client includes logic for the mysql.transaction_registry table. You cannot use the mysqldump client from an earlier MariaDB release on MariaDB 10.3 and later. For more information about how to upgrade to MariaDB 10.3...
  7. C

    systemctl start mariadb error but mysql running

    Hello, so I needed to move my datadir of MariaDB on my cPanel server because as many it happens, I kept the default config of partitions, and didn't think about it, so I had 20GB and it was getting full, and obviously the main folder taking space was /var/lib/mysql Long story short, I moved the...
  8. C

    SOLVED MariaDB 10.0 > 10.1 or 10.2

    Hi Cpanel Members & Team I'm trying to update mariaDB 10.0 to (10.1 or 10.2) and this is my issues Error installing MariaDB dependencies: (XID kkfzd8) The system failed to execute yum with the arguments “--assumeyes --config /etc/yum.conf install shadow-utils grep perl-DBI coreutils...
  9. C

    Aborted connection errors after upgrade to MariaDB 10.2

    I recently upgraded from MariaDB 10.1 to 10.2, and am seeing lots of these kind of errors, but I don't seem to be losing data or notice any issues besides the warnings: 2018-08-21 15:57:48 140579807250176 [Warning] Aborted connection 926492 to db: 'database_name' user: 'site_user' host...
  10. P

    Move from MySQL 5.7 to MariaDB 10.0.34 manually?

    Hello I´m updating all my cpanel servers to new ones. (from centOS 6X to centOS 7 because Cloudlinux 6X will discontinue soon). At now i have installed MariaDB 10.0.34 and all sites are working fine and perfect. 2 days ago i built one of the new ones (by default with mySQL 5.7) and i made the...
  11. D

    SOLVED Mariadb 10.2 - Disabling Strict Mode

    I am wondering if disabling strict mode going to stick when cpanel/WHM auto updates itself? If so, is it going to stick while upgrading minor MariaDB 10.2.x versions?
  12. G

    Change MariaDB tmp folder?

    Hello, I try to change tmp folder of mariadb because I found out that files .MAD are are constantly being created inside tmp folder and despite the fact that I increased the tmp folder from the beginning of the installation of cpanel to 15GB are filling the space with results operational...
  13. U

    The system failed to drop the MySQL user error

    hi, after i downgrade from mariadb 10.2 to mysql 5.6 i got this error when i delete user The system failed to drop the MySQL user “xxxx” because of an error: (XID bn962q) The system received an error from the “MySQL” database “mysql”: 1728 (Cannot load from mysql.procs_priv. The table is...
  14. A

    Cant update MariaDB

    Yum update failing on this: Transaction check error: file /etc/my.cnf conflicts between attempted installs of MariaDB-common-10.2.16-1.el7.centos.x86_64 and cl-MariaDB102-libs-10.2.15-1.el7.cloudlinux.x86_64 file /usr/lib64/mysql/plugin/auth_gssapi_client.so conflicts between attempted...
  15. cPanelMichael

    InnoDB fails to start on systems using MariaDB when the kernel is older than 2.6.24

    Hello, In MariaDB version 10.1.34, the F_DUPFD_CLOEXEC flag is used with FCNTL as part of the operation to create a temporary file during the InnoDB startup process. Kernel versions older than 2.6.24 do not support the F_DUPFD_CLOEXEC flag, and thus InnoDB will fail to start. The following line...
  16. P

    Downgrade Mariadb to 10.1?

    Hello i using cpanel last version on centos 7 i install mariadn 20.2 in MySQL/MariaDB Upgrade option in WHM i want install mariadb 10.1 ..( i want downgrade from 10.2 to 10.1) can you help me ? i read this post : That's correct. If you want to use MariaDB 10.1, you'd create...
  17. P

    Upgrading MariaDB and old sites

    My server is currently using Maria 5.6 and I am wanting to upgrade to V 10. But there are quite a few sites on the server that can only run php 5.3. Will upgrading Maria cause problems with those sites? I'm getting different answers and no one seems to know for sure. I've checked the Maria site...
  18. L

    MariaDB Did Not Start Up After Upgrade

    I'm using WHM/cPanel 70, and I decided to take the plunge and do the upgrade from MariaDB 10.1 to 10.2 using the MySQL/MariaDB upgrade tool in WHM. During Step 7 of the upgrade process, I got the following error: MariaDB did not start up after upgrade; there may be a problem in /etc/my.cnf. at...
  19. keat63

    Upgrading MySQL 5.6 to MariaDB 10.2 Question

    My server is currently on MySql5.6 If I were to upgrade this to Maria10.2, what's the likelyhood of it breaking ?
  20. M

    Problems after moving to MariaDB

    Accidentally I have replacement MySQL server. We are using MySQL version 5.6.37 and Does not get any Server Error Log. Today I Do Upgrade to MariaDB 10.2.8 and Now lot of Server Error Log happened about Deadlock found when trying to get lock and Lock wait timeout exceeded. So this issue only...