Installation & Upgrade & De-installation

This chapter describes all installation/upgrade/de-installation steps.

Installation

Prerequisites

This paragraph describes all necessary steps which must be completed before you start the DMK installation.

• The system must come with a perl installation

Execute the below command to check if perl is installed:

which perl

Otherwise install the following packages if needed.

Debian/Ubuntu

$ apt install zip libswitch-perl libaio1 libaio-dev ksh libncurses5 sudo tuned psmisc -ybas

CentOS/RedHat 7

$ sudo yum install ksh perl-Switch wget -y

RedHat 8

$ sudo subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms

$ dnf install ksh perl-Switch tar libncurses.so.5 ncurses-compat-libs wget

Alma Linux/Rocky Linux 8

$ dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm -y

$ dnf config-manager --enable epel

$ dnf config-manager --set-enabled powertools

$ dnf install ksh perl-Switch tar libncurses.so.5 ncurses-compat-libs wget

For Rocky Linux 9

$ dnf install epel-release -y

$ dnf config-manager --enable epel

$ dnf config-manager --set-enabled crb

$ dnf install ksh perl-Switch tar wget perl

$ cd /usr/lib64

$ sudo ln -s libtinfo.so.6 libtinfo.so.5

$ sudo ln -s libncurses.so.6 libncurses.so.5

• Ensure the mysql.cnf configuration file exists

Software extraction

Based on the dbi services and OFA (Oracle Flexible Architecture) best practices extract the archive under ${MYQL_BASE}/local, as explained below:

gzip --decompress dmk-xx-xx-xxxx.tar.gz

tar -xvf dmk-xx-xx-xxxx.tar

Typically, ${MYSQL_BASE} match:

• “/u01/app/mysql” on Linux/Unix

Adapt the DMK configuration file

This is one of the most important installation steps, once extracted the “default” configuration file is available under ${DMK_HOME}/etc.

• ${DMK_HOME}/etc/dmk.conf.unix for Linux

Adapt the following variables

• MYSQL_BASE, set it as explained in the OFA document

• MYSQL_CNF, location of the mysql.cnf

⚠️ During the installation, the “default**” configuration file ${DMK_HOME}/etc/dmk.conf.unix is renamed to dmk.conf**. This mechanism avoids any configuration loss in case of upgrades.

Install

Install DMK, from the ${DMK_HOME}/bin directory or with absolute path as follows:

For Linux/Unix use the appropriate SHELL script :

mysql@vmoraoel:/u01/app/mysql/local/dmk/bin/#> echo $SHELL

/bin/bash

mysql@vmoraoel:/u01/app/mysql/local/dmk/bin/#> . ./dmk.sh

Don’t be afraid, the installation is automated without questioning.

Congratulations you have successfully installed DMK!

DMK as ROOT or another user

DMK doesn’t only belong to a unique/specific user, if the necessary privileges are correctly distributed you can start DMK from another user as presented below.

Install and source DMK under the target user

[root@vmoraoel ~]# . /u01/app/mysql/local/dmk/bin/dmk.sh

Once installed it can be sourced using the DBA’s login profile

[root@vmoraoel ~]# . /home/mysql/.profile

Upgrade

dbi services recommend to perform a backup of your DMK package before upgrading.

The upgrade process is similar to the installation except that the prerequisites are already fulfilled:

• Extract the software as explained in chapter Software extraction

• Install DMK as explained in chapter Install

That’s it!

⚠️ Upgrades don’t affect the configuration file “${DMK_HOME}/etc/dmk.conf” file, please review this for newly introduced aliases or variables.

De-installation

This paragraph describes the de-installation of the DMK toolkit.

For Linux:

rm ~/.DMK_*

rm -rf $DMK_HOME

Do not forget to remove the profile from your environment.