Установка MySQL Govenour
Форум
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Sven
  2. Monday, 08 October 2018
  3.  Subscribe via email
Currently installed: 10.2.18-MariaDB (By cPanel)

Please check this


[[email protected] ~]# yum remove db-governor db-governor-mysql
Loaded plugins: fastestmirror, rhnplugin, universal-hooks
This system is receiving updates from CLN.
No Match for argument: db-governor
No Match for argument: db-governor-mysql
No Packages marked for removal
[[email protected] ~]# yum install governor-mysql
Loaded plugins: fastestmirror, rhnplugin, universal-hooks
This system is receiving updates from CLN.
Loading mirror speeds from cached hostfile
epel/x86_64/metalink | 31 kB 00:00:00
* cpanel-addons-production-feed: 85.13.201.2
* cloudlinux-x86_64-server-7: cl-mirror.vimexx.nl
* epel: mirror.imt-systems.com
Resolving Dependencies
--> Running transaction check
---> Package governor-mysql.x86_64 0:1.2-36.el7.cloudlinux will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================================================================================================================================================================
Package Arch Version Repository Size
===============================================================================================================================================================================================================================================================================================================
Installing:
governor-mysql x86_64 1.2-36.el7.cloudlinux cloudlinux-x86_64-server-7 260 k

Transaction Summary
===============================================================================================================================================================================================================================================================================================================
Install 1 Package

Total download size: 260 k
Installed size: 1.0 M
Is this ok [y/d/N]: y
Downloading packages:
governor-mysql-1.2-36.el7.cloudlinux.x86_64.rpm | 260 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : governor-mysql-1.2-36.el7.cloudlinux.x86_64 1/1
fs.suid_dumpable = 1
Set FS suid_dumpable for governor to work correctly
Add to /etc/sysctl.conf suid_dumpable instruction for governor to work correctly
Run script: /usr/share/lve/dbgovernor/mysqlgovernor.py --install
!!!Before making any changing with database make sure that you have reserve copy of users data!!!
Instruction: how to create whole database backup - http://docs.cloudlinux.com/index.html?backing_up_mysql.html
Verifying : governor-mysql-1.2-36.el7.cloudlinux.x86_64 1/1

Installed:
governor-mysql.x86_64 0:1.2-36.el7.cloudlinux

Complete!
[[email protected] ~]# /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb102
Now set MySQL to type 'mariadb102'
[[email protected] ~]# /usr/share/lve/dbgovernor/mysqlgovernor.py --install
!!!Before making any changing with database make sure that you have reserve copy of users data!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!Ctrl+C for cancellation of installation!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Instruction: how to create whole database backup - http://docs.cloudlinux.com/index.html?backing_up_mysql.html
---
metadata:
command: configureservice
reason: Disabled monitoring for mysql.
result: 1
version: 1
Start download current installed packages
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-server-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-server-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-server-10.2.18-1.el7.centos.x86_64.rpm with status 200
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-compat-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-compat-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-compat-10.2.18-1.el7.centos.x86_64.rpm with status 200
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-devel-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-devel-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-devel-10.2.18-1.el7.centos.x86_64.rpm with status 200
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-shared-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-shared-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-shared-10.2.18-1.el7.centos.x86_64.rpm with status 200
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-common-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-common-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-common-10.2.18-1.el7.centos.x86_64.rpm with status 200
URL http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-client-10.2.18-1.el7.centos.x86_64.rpm
Downloaded file /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-client-10.2.18-1.el7.centos.x86_64.rpm from http://httpupdate.cpanel.net/RPM/unknown/centos/7/x86_64/MariaDB-client-10.2.18-1.el7.centos.x86_64.rpm with status 200
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-devel-10.2.18-1.el7.centos.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-shared-10.2.18-1.el7.centos.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-common-10.2.18-1.el7.centos.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-compat-10.2.18-1.el7.centos.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-client-10.2.18-1.el7.centos.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/old/MariaDB-server-10.2.18-1.el7.centos.x86_64.rpm was loaded
Start download packages for new installation
Loaded plugins: fastestmirror, rhnplugin, universal-hooks
Cleaning repos: cpanel-addons-production-feed MariaDB102 cl-ea4 cl-mysql-meta cloudlinux-imunify360 cloudlinux-x86_64-server-7 cpanel-plugins epel imunify360 imunify360-alt-php imunify360-ea-php-hardened kernelcare letsencrypt-cpanel lynis zabbix zabbix-non-supported
Cleaning up everything
Maybe you want: rm -rf /var/cache/yum, to also free up space taken by orphaned data from disabled or removed repos
Cleaning up list of fastest mirrors
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-client-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-devel-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-client-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-devel-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/mysqlclient16-5.1.73-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/mysqlclient15-5.0.91-2.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/mysqlclient18-compat-10.1.28-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/libaio-0.3.109-13.el7.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB-meta-client-10.2.18-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-bench-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-libs-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-server-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-server-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-bench-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-devel-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-libs-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
Package /usr/share/lve/dbgovernor/tmp/governor-tmp/new/cl-MariaDB102-devel-10.2.17-1.el7.cloudlinux.x86_64.rpm was loaded
New packages will be installed:
cl-MariaDB-meta-10.2.18-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB-meta-client-10.2.18-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB-meta-devel-10.2.18-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB102-10.2.17-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB102-bench-10.2.17-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB102-devel-10.2.17-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB102-libs-10.2.17-1.el7.cloudlinux.x86_64.rpm
cl-MariaDB102-server-10.2.17-1.el7.cloudlinux.x86_64.rpm
libaio-0.3.109-13.el7.x86_64.rpm
mysqlclient15-5.0.91-2.el7.cloudlinux.x86_64.rpm
mysqlclient16-5.1.73-1.el7.cloudlinux.x86_64.rpm
mysqlclient18-compat-10.1.28-1.el7.cloudlinux.x86_64.rpm
You are attempting to install a LOWER mariadb version (10.2.17) than currently installed one (10.2.18).
This could lead to unpredictable consequences, like fully non working service.
Think twice before proceeding.
Continue? [y/n] n
Rate this post:
  1. 09.10.2018 14:10:18
  2. # 1
Sven Accepted Answer
Posts: 5
Joined: 13.11.2017
0
Votes
Undo
Nothing?
  1. 10.10.2018 12:10:55
  2. # 2
Posts: 187
Joined: 31.01.2017
0
Votes
Undo
Hi Sven,

According to https://www.cloudlinux.com/cloudlinux-os-blog/entry/beta-mariadb-for-mysql-governor-updated-1-16
the third CLI command should be:
# /usr/share/lve/dbgovernor/mysqlgovernor.py --install-beta
  1. 10.10.2018 19:10:19
  2. # 3
Sven Accepted Answer
Posts: 5
Joined: 13.11.2017
0
Votes
Undo
cPanel just Installed MariaDB 10.2.
So I really must do this?: /usr/share/lve/dbgovernor/mysqlgovernor.py --install-beta

When I do: yum install governor-mysql
Governor is activated and working.
  1. 12.10.2018 15:10:03
  2. # 4
Posts: 187
Joined: 31.01.2017
0
Votes
Undo
MySQL Governor requires MariaDB version installed from CloudLinux repositories for its operation.
  1. 12.10.2018 21:10:44
  2. # 5
Sven Accepted Answer
Posts: 5
Joined: 13.11.2017
0
Votes
Undo
Ok, sorry for asking, but it was unclear for me why I should reinstall the same MariaDB version again.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
гость
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.