MySQL Governor on CloudLinux 7

[christof.bruyland]

I want to run MySQL governor on CloudLinux with the OS provided MariaDB packages.
Im running the following commands:

yum install -y governor-mysql

This installed version 1.0-96

/usr/share/lve/dbgovernor/db-select-mysql --mysql-version=auto

/usr/share/lve/dbgovernor/mysqlgovernor.py --install

This will result in a failed installation of cl-MariaDB packages, because of conflicts with mariadb-libs (used by postfix).
After troubleshooting, Ive detected that the [bold]/usr/share/lve/dbgovernor/utils/db_install_common.sh[bold] script is still trying to install mysql* packages and not mariadb* packages.

With following patch I managed to install the OS specific packages:

*** /usr/share/lve/dbgovernor/utils/db_install_common.orig.sh	2015-07-10 13:03:21.000000000 +0200

--- /usr/share/lve/dbgovernor/utils/db_install_common.sh	2015-08-04 11:30:50.633006443 +0200

***************

*** 49,55 ****

if [ -e /usr/libexec/mysqld ]; then

mv -f /usr/libexec/mysqld /usr/libexec/mysqld.bak

fi

!	yum install mysql mysql-server mysql-libs mysql-devel mysql-bench  --nogpgcheck -y

fi

if [ "$SQL_VERSION" == "mysql50" ]; then

wget -O /etc/yum.repos.d/cl-mysql.repo  [URL]http://repo.cloudlinux.com/other/$CL/mysqlmeta/cl-mysql-5.0-common.repo[/URL]

--- 49,55 ----

if [ -e /usr/libexec/mysqld ]; then

mv -f /usr/libexec/mysqld /usr/libexec/mysqld.bak

fi

!	yum install mariadb mariadb-server mariadb-libs mariadb-devel mariadb-bench  --nogpgcheck -y

fi

if [ "$SQL_VERSION" == "mysql50" ]; then

wget -O /etc/yum.repos.d/cl-mysql.repo  [URL]http://repo.cloudlinux.com/other/$CL/mysqlmeta/cl-mysql-5.0-common.repo[/URL]

***************

*** 139,145 ****

if [ -e /usr/libexec/mysqld ]; then

mv -f /usr/libexec/mysqld /usr/libexec/mysqld.bak

fi

!	yum install mysql mysql-server mysql-libs mysql-devel mysql-bench  --nogpgcheck -y --enablerepo=cloudlinux-updates-testing

fi

if [ "$SQL_VERSION" == "mysql50" ]; then

wget -O /etc/yum.repos.d/cl-mysql.repo  [URL]http://repo.cloudlinux.com/other/$CL/mysqlmeta/cl-mysql-5.0-common.repo[/URL]

--- 139,145 ----

if [ -e /usr/libexec/mysqld ]; then

mv -f /usr/libexec/mysqld /usr/libexec/mysqld.bak

fi

!	yum install mysql mariadb-server mariadb-libs mariadb-devel mariadb-bench  --nogpgcheck -y --enablerepo=cloudlinux-updates-testing

fi

if [ "$SQL_VERSION" == "mysql50" ]; then

wget -O /etc/yum.repos.d/cl-mysql.repo  [URL]http://repo.cloudlinux.com/other/$CL/mysqlmeta/cl-mysql-5.0-common.repo[/URL]

Could it be possible to verify this, and update the governor-mysql package if needed?

[alexey.com.s]

Hello,

here is fixed version of governor for CL7:

https://<a href="http://www.cloudlin...ed1234.php</a>