Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power


#Servers
#Opensource
 View Only

  • 1.  Upgrading from MariaDB 10.4 to MariaDB 10.11

    Posted 01/08/25 02:16 AM
    Edited by PRAJWAL B MEHENDARKAR 01/08/25 02:17 AM

    Mariadb 10.4 version has reached end of life and is no longer supported by the community.
    Mariadb 10.11 is now available in AIX Toolbox. It is therefore recommended that AIX Toolbox
    users use Mariadb 10.11 .


    Toolbox Users are recommended to perform the following necessary steps to migrate their
    databases.
    It is highly recommended that users create a backup of their databases and any essential
    files before proceeding with an upgrade .


    The suggested upgrade procedure is:

    1. Stop MariaDB
      SHUTDOWN WAIT FOR ALL REPLICAS;
      Refer to shutdown command for more information.
    2. Uninstall the old version of MariaDB.
      Execute the following:
      dnf remove mariadb-server
    3. Install the new version of MariaDB.
      a. RPMS have been renamed from mariadb to mariadb10.11. So, inorder to
      install mariadb 10.11 users have to run the following command
      dnf install mariadb10.11
      b. We have also added Conflicts: mysql-config >= 1.0-3 in mariadb-10.11.9 spec
      file. As a result, if an older version of mysql-config is already installed in the
      system, then the installation would fail with the following error.
      package mysql-config-1.0-3.noarch conflicts with mariadb-server < 3:10.5
      provided by mariadb-server-3:10.4.26-1.ppc
      In this case, user has to remove the older version of mysql-config first and
      then install the new version.
    4. Start MariaDB
      mysqld_safe is a wrapper that can be used to start the mysqld server process. The
      script has some built-in safeguards, such as automatically restarting the server
      process if it dies. See mysqld_safe for more information.
    5. Run mysqld_upgrade
      mysqld_upgrade does two things:
      a. Ensures that the system tables in the mysql database are fully
      compatible with the new version.
      b. Does a very quick check of all tables and marks them as compatible
      with the new version of MariaDB



    ------------------------------
    PRAJWAL B MEHENDARKAR
    ------------------------------


    #AIXOpenSource


  • 2.  RE: Upgrading from MariaDB 10.4 to MariaDB 10.11

    Posted 01/20/25 11:04 AM

    just did the upgrade...the above writing is full off inaccuracies. if someone with no mariadb knowledge is confronted with this downright nonsense...better not.

    1) just doing "dnf install mariadb10.11" does not install server binaries, so this leaves one with a dysfunctional "server" installation. mariadb10.11-server needs to be installed also.

    2) mysql_save is not part of the package, so alone this fact will leave inexperienced user baffled. its named mariadb-save, same with mysql_upgrade...ridiculous

    3) the post install script tries to create a  aix service with wrong binarie names (mysqld instead of mariadbd), and fails in checking if the service is already present.

    these are only the things that i am encounterd...who knows what else is messed up.



    ------------------------------
    I regret starting this entire conversation
    ------------------------------



  • 3.  RE: Upgrading from MariaDB 10.4 to MariaDB 10.11

    Posted 01/21/25 08:00 AM

    Thanks for bringing these issues to our attention.
    As you correctly mentioned, users should install mariadb10.11-server as well. One can run the following
    dnf install mariadb10.11-server

    Although in the new versions of mariadb, the binaries are called mariadbd-safe and mariadb-upgrade, invoking mysqld_safe and mysql_upgrade will also work since these are provided with the rpm as symbolic links.

    lrwxrwxrwx 1 root system 15 Jan 10 00:38 /opt/freeware/bin/mysql_upgrade -> mariadb-upgrade
    lrwxrwxrwx 1 root system 13 Jan 10 00:38 /opt/freeware/bin/mysqld_safe -> mariadbd-safe

    However there is an error in the writing. It should be mysql_upgrade instead of mysqld_upgrade

    In the post installation script as well, /opt/freeware/libexec/mysqld is used which is a symbolic link to mariadbd. So, it should work.

    lrwxrwxrwx 1 root system 8 Jan 21 06:54 /opt/freeware/libexec/mysqld -> mariadbd



    ------------------------------
    RESHMA KUMAR
    ------------------------------

    Original Message


Related Content