Mariadb upgrade

aaP_jpd

Hi there, i have a question, if anyone can help me, i have installed aapanel with mariadb 10.7.3, but i want to upgrade mariadb to 10.7.8, but the update is not in the list available yet in the app store, is there a way to upgrade mariadb in aapanel to 10.7.8? without "break" something?, if you are wandering why i want the upgrade, is for a upgrade in 10.7.8 that involves uuid, tha is available in that version of mariadb...thanks in advance!!

aaPanel_Kern

Hello, because there are too many versions of mariadb and the update frequency is too fast, many plug-ins or systems cannot provide compatibility and update in time. Generally, it is recommended to use mariadb as early adopters. It is also recommended to use mysql as the production environment database. More than 95% of users use mysql. Our technicians are also more familiar with mysql. If there is a problem in the process of using mysql, we can also solve it faster

If the current selected system cannot install mariadb, it is recommended that you use mysql

aaP_jpd

aaPanel_Kern

Thanks for reply, and i undesrtand that, we have been using mysql, until my boss decided to migrate to mariadb for better performance and speed according to him, and that improves more in the update available in version 10.7.8 of mariadb concerning the uuid thing.....by the way, when could it be available the version 10.7.8 of mariadb in the app store to make posible the update from aapanel??...it will be posible?....thanks in advance!!

aaPanel_Kern

Hello, there is currently no update plan

aaP_jpd

oh, is a shame 🙁 ,,,,is there a way to upgrading mariadb to version 10.7.8 manually???

aaPanel_Kern

It is recommended that the server back up the database after snapshot backup, and record all database names, users, passwords, and database codes. Delete all databases. uninsatll mariadb
Finally, install the new version of mariadb manually, and then modify the root password in the panel. Finally, create a database and restore the database according to the recorded data

aaP_jpd

thanks for reply, if i install the new version of mariadb, previously uninstalled the other version, can still manage the mariadb from the panel from aapanel?? (to make the change in the root password, and make the database backup, as i have been doing till now), can i see the logs of madiadb in aapanel with the new version as before? ...thanks!... i mean aapanel can "see" the new mariadb engine from the panel although the update is not available in the app store???

aaPanel_Kern

Yes, it must be consistent with the directory installed by the panel
Database program: /www/server/mysql
Database data storage: /www/server/data

aaP_jpd

aaPanel_Kern

thanks!,...i'll give it a try and let you know.. 😃

aaP_jpd

aaPanel_Kern

one question, how ca i install mariadb in the database program and database data storage customs path?...in the installation ask me for them???? (asuming that i use the yum install mariadb-server command)

aaPanel_Kern

Can only compile and install

aaP_jpd

aaPanel_Kern

Can you give me a hand with that?...if is posible??

aaPanel_Kern

Hello, it is recommended to refer to the official documentation for installation