Qloapps / QloApps

QloApps is a Free and Open-source hotel management and reservation system to take a hotel business online. QloApps offers a Property Management System (PMS), a Booking Engine, and an attractive Hotel Website. Elevate hotel operations with QloApps to streamline processes and provide an enhanced experience for both hoteliers and guests.
https://qloapps.com
Open Software License 3.0
4.5k stars 483 forks source link

MySQL 5.7 Extended EOL has passed since October 2023 #1177

Open soft4rchitecture opened 1 month ago

soft4rchitecture commented 1 month ago

Hi,

Context I'm considering integrating this great component into a solution.

Problem Nevertheless, I noticed that Extended EOL for the DB has passed since end of last year. This means no more development, and more importantly, no more security patches (if you see otherwise don't hesitate to comment). In turn, the fact that no security patches are applied anymore means vulnerability risk for user data, which is a risk that can not be taken if you're doing real business.

The next MySQL LTS version is 8.0.x, but Premier Support ends on the 30th of April, 2025, really soon. The best fit candiate would be MySQL LTS 8.4.x, with Premier Support ending in 2029.

Solution So as to ease data migration and avoid any data loss issues, Use a 2 step migration path:

  1. First update Solution so that it uses MySQL 8.0.x.
  2. When most issues are ironed out, update Solution so that it uses MySQL 8.4.x.
soft4rchitecture commented 1 month ago

@sumitwebkul @rohit053

sumitwebkul commented 2 weeks ago

Hi @soft4rchitecture,

We understand your concern of upgrading the PHP and MySql Versions in QloApps.

I want to inform you that the PHP and MySQL version upgrade is already in our roadmap and we have already planned to switch the QloApps PHP and MySQL versions to 8.x soon.

We can not provide you with any tentative release date for the same but we will surely inform you once the QloApps with upgraded PHP and MySql versions will be released.