Installing the MySQL client utility
You need to install this utility to protect the following databases:
Azure MySQL
Azure MariaDB
AWS MySQL
AWS MariaDB
AWS Aurora MySQL
GCP MySQL
The utility version must be the same or higher than the server version.
For server version 8.0, the recommended version of the MySQL client utility is 8.0.42.
For server version 8.4, the recommended version of the MySQL client utility is 8.4.4.
RPM download locations:
To install, do the following in the terminal:
- Navigate to
/usr/openv/dbpaas. If thedbpaasfolder does not exist, run the command mkdir dbpaas to create the folder. - Create the
mysqlfolder inside the/usr/openv/dbpaasfolder. Run the command mkdir mysql inside/usr/openv/dbpaas.For server version 8.0, create the folder
80inside the/usr/openv/dbpaas/mysqlfolder. Run the command mkdir 80 inside the/usr/openv/dbpaas/mysqlfolder.For server version 8.4, create the
84folder inside the/usr/openv/dbpaas/mysqlfolder. Run the command mkdir 84 inside the/usr/openv/dbpaas/mysqlfolder.
- Download the utilities as follows:
For server version 8.0, go to the
80folder, and run the command:wget https://downloads.mysql.com/archives/get /p/23/file/mysql-community-client-8.0.42-1.el9.x86_64.rpm
For server version 8.4, go to the
84folder, and run the command:wget https://downloads.mysql.com/archives/get /p/23/file/mysql-community-client-8.4.4-1.el9.x86_64.rpm
- To install, run the command:
For version 8.0:
rpm2cpio /usr/openv/dbpaas/mysql/80/mysql-community-client-8.0.42-1.el9.x86_64.rpm | bsdtar -xv --strip-components=2 -f - -C /usr/openv/dbpaas/mysql/80 'usr/bin/mysql' 'usr/bin/mysqldump' 'usr/bin/mysqlbinlog'
For version 8.4:
rpm2cpio /usr/openv/dbpaas/mysql/84/mysql-community-client-8.4.4-1.el9.x86_64.rpm | bsdtar -xv --strip-components=2 -f - -C /usr/openv/dbpaas/mysql/84 'usr/bin/mysql' 'usr/bin/mysqldump' 'usr/bin/mysqlbinlog'
Note:
Avoid using MySQL client utility 8.0.32 version as there is a bug reported by MySQL.