Control Web Panel

WebPanel => Updates => Topic started by: Vistior31 on November 09, 2023, 08:31:33 PM

Title: How to update Mariadb to 11.1?
Post by: Vistior31 on November 09, 2023, 08:31:33 PM
Hello,

I want to update my Joomla site to version 5, this requires updating the DB, is this possible with CentOS 7 and CWP7 working together?

If yes, how much will this upgrade service cost me?

MySQL   8.1   or
MariaDB   11.1.0   
Title: Re: How to update Mariadb to 11.1?
Post by: Painkiller88 on November 10, 2023, 07:43:21 AM
Hi,

its possible and absolutely free.

Just follow these instructions and change version to the needed one:

https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version
Title: Re: How to update Mariadb to 11.1?
Post by: Starburst on November 10, 2023, 11:10:26 AM
MariaDB 11.x support has been discussion in detail in another thread.

MariaDB 10.11.x is the current LTS version.

Upgrading MariaDB is Free, unless you need to hire someone to do it.
Title: Re: How to update Mariadb to 11.1?
Post by: Painkiller88 on November 10, 2023, 07:03:26 PM
Quote from: Starburst on November 10, 2023, 11:10:26 AM
MariaDB 11.x support has been discussion in detail in another thread.

MariaDB 10.11.x is the current LTS version.

Upgrading MariaDB is Free, unless you need to hire someone to do it.

can you point me to the discussion about mariadb 11

i cant find it when i search.

thanks
Title: Re: How to update Mariadb to 11.1?
Post by: Vistior31 on November 10, 2023, 07:26:34 PM
Quote from: Vistior31 on November 09, 2023, 08:31:33 PM
Hello,

I want to update my Joomla site to version 5, this requires updating the DB, is this possible with CentOS 7 and CWP7 working together?

If yes, how much will this upgrade service cost me?

MySQL   8.1   or
MariaDB   11.1.0   

Quote from: Painkiller88 on November 10, 2023, 07:43:21 AM
Hi,

its possible and absolutely free.

Just follow these instructions and change version to the needed one:

https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version

Thank you both for the useful information
Title: Re: How to update Mariadb to 11.1?
Post by: Starburst on November 10, 2023, 09:36:59 PM
https://forum.centos-webpanel.com/index.php?topic=12900.msg45510#msg45510
Title: Re: How to update Mariadb to 11.1?
Post by: vikjak002 on August 19, 2024, 12:32:20 AM
Upgrading MariaDB to a stable release that brings a host of new features, bug fixes, and performance improvements. Some of the key enhancements in this version include better performance for large datasets, improved query optimization, and enhanced security features.

As MariaDB 10.4 is outdated for the latest WordPress 6.6 and gives a warning to update it to at least 10.5


I followed the link to successfully upgrade MariaDB 10.4 to 10.6 version by following the article below

https://startechies.net/blog/upgrade-mysql-mariadb-to-stable-version-linux/
Title: Re: How to update Mariadb to 11.1?
Post by: Starburst on August 20, 2024, 03:19:11 PM
MariaDB 10.11 is the current LTS version and works fine with WordPress 6.6.x

Currently all others only have a 1 year update life form the time they are first released.

There is a guide at:
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/ (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/)
Title: Re: How to update Mariadb to 11.1?
Post by: govind on September 02, 2024, 12:55:42 PM
Instead of upgrading to the latest MariaDB 11.6, I plan to upgrade to MariaDB 10.6. It’s a best practice to move from MariaDB 10.4 to 10.6 to ensure that our applications continue to run smoothly without any issues.

I was able to upgrade MariaDB 10.6 on my CWP using the article below:

https://startechies.net/blog/upgrade-mysql-mariadb-to-stable-version-linux/
Title: Re: How to update Mariadb to 11.1?
Post by: Starburst on September 02, 2024, 10:05:47 PM
11.4 is the latest LTS version.
10.6 is EOL July 2026, while 10.11 EOL is February 2028.
11.x only has a 1 year lifespan.

And the version you mention 11.6 is in RC only, not for production use, yet.

https://mariadb.org/download/?t=mariadb&p=mariadb&r=10.6.19&os=windows&cpu=x86_64&pkg=msi&mirror=acorn#release-schedule (https://mariadb.org/download/?t=mariadb&p=mariadb&r=10.6.19&os=windows&cpu=x86_64&pkg=msi&mirror=acorn#release-schedule)


There are specific CWP update articles at:

https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version (https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version)

https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25 (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25)

AlmaLinux 8:
https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-8/ (https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-8/)

AlmaLinux 9:
https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-9/ (https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-9/)