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:
Sent: Mon January 20, 2025 11:03 AM
From: C- -T
Subject: Upgrading from MariaDB 10.4 to MariaDB 10.11
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
Original Message:
Sent: Wed January 08, 2025 02:16 AM
From: PRAJWAL B MEHENDARKAR
Subject: Upgrading from MariaDB 10.4 to MariaDB 10.11
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:
- Stop MariaDB
SHUTDOWN WAIT FOR ALL REPLICAS;
Refer to shutdown command for more information. - Uninstall the old version of MariaDB.
Execute the following:
dnf remove mariadb-server - 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. - 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. - 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
------------------------------