Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Upgrade MySQL versions for portable Linux and Windows

Description

Current version MySQL embedded in the portable versions (Linux and Windows) is 5.4.X

Need to upgrade to newer version or to replace with other DBMS (e.g. MariaDB MySQL is still the DMBS used) and to test compliance with scripts for DB building and update the GitHub Actions build.

More info in the comments.

Environment

None

is blocked by

relates to

Activity

miz October 26, 2020 at 5:26 PM

Yes, all the software version references have been updated in the admin manual.

Alessandro Domanico October 26, 2020 at 5:04 PM
Edited

MariaDb mention was just an option, SQLite is mentioned only in the comments as another solution for the portable subsequent to this one.

This issue is in status, which means that only the documentation is missing. Maybe we just need to updated the description to make clear the advancements….

Where the Admin Manual has been updated yet? Maybe this ?

miz October 26, 2020 at 3:55 PM
Edited

This issue is not clear anymore. We upgrade mysql to version 5.7 already and the Admin Manual has been updated consequently. Here we mention MariaDb and also a SQLlite solution; what are the plans ?

Alessandro Domanico October 23, 2020 at 2:10 PM

This issue needs to be documented after will be closed.

miz October 10, 2020 at 8:00 PM
Edited

I totally agree with the idea of using a file-based database like sqlite. I was starting to review the OH.sh run script (which in my opinion needs quaite a lot of work, especially on the mysql part), and using sqlite would basically solve all the issues (TCP ports, startup / shutdown of the service, backup and restore, etc.).

I can contribuite by testing the solution / adapting the scripts. Please let me know in case you decide to proceed on this topic.

Done

Details

Assignee

Reporter

Labels

Components

Fix versions

Original estimate

Time tracking

2d 2h logged

Sprint

Priority

Created January 28, 2020 at 10:35 PM
Updated October 29, 2020 at 9:12 PM
Resolved September 28, 2020 at 8:55 PM