Upgrade mySQL (mariadb) server to current version

  • Platform information:
    • Hardware: Raspberry Pi 4 Model B Rev 1.1 (4GB)
    • OS: Raspbian GNU/Linux 10 (buster)
    • Java Runtime Environment: which java platform is used and what version
    • openHAB version: 2.5.1-2 (Release Build)
  • Issue of the topic: Upgrade mariadb server used in mySQL from its installed version of 10.0.28-MariaDB-2+b1 Raspbian testing-staging to the latest MariaDB (v10.4)

mySQl with the Maria DB server is currently running on my Openhab2 system. There are some new features in the latest Maria DB (such as lag() function) that are not in the version I have installed. I would like to take advantage of these new features but I can not find any guidance on how to upgrade the server or if would even work.

  • Please post configurations (if applicable):
    • Items configuration related to the issue
    • Sitemap configuration related to the issue
    • Rules code related to the issue
    • Services configuration related to the issue
  • If logs where generated please post these here using code fences: