{"id":404,"date":"2019-04-28T02:18:31","date_gmt":"2019-04-28T02:18:31","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/24x7serversupport-blog\/?p=404"},"modified":"2019-04-28T02:18:31","modified_gmt":"2019-04-28T02:18:31","slug":"how-to-install-mysql-governor","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/","title":{"rendered":"How to install MySQL Governor"},"content":{"rendered":"\n

IMPORTANT<\/strong>: Please make full database backup (including system tables) before you will do \u00a0 \u00a0 \u00a0 \u00a0upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong.<\/p>\n\n\n\n

MySQL Governor is compatible only with MySQL 5.x, 8.0; MariaDB & Percona Server 5.6.<\/em><\/strong>
<\/p>\n\n\n\n

To install MySQL Governor on your server install governor-mysql package at first: <\/p>\n\n\n\n

# yum remove db-governor db-governor-mysql \u00a0# you can ignore errors if you don’t have those packages installed
# yum install governor-mysql <\/p><\/blockquote>\n\n\n\n

Then configure\u00a0MySQL Governor\u00a0properly.
The installation is currently supported only on cPanel, Plesk, DirectAdmin, ISPmanager, InterWorx, as well as on servers without control panel.
If you are installing CloudLinux on a server running MySQL already, set your current MySQL version before calling installation script:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –mysql-version=mysqlXX
# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install <\/p><\/blockquote>\n\n\n\n

Please make sure to specify your current MySQL version instead of XX as follows:
\u202255 \u2014 MySQL v5.5
\u202256 \u2014 MySQL v5.6
\u202257 \u2014 MySQL v5.7
\u202280 \u2014 MySQL v8.0 [requires\u00a0MySQL Governor\u00a01.2-37+;
database packages are available in Beta only, so, please use –install-beta flag instead of –install]<\/p>\n\n\n\n

If you are installing\u00a0CloudLinux\u00a0on a server running\u00a0MariaDB\u00a0already, do instead:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –mysql-version=mariadbXX
# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install <\/p><\/blockquote>\n\n\n\n

Please make sure to specify your current\u00a0MariaDB\u00a0version instead of\u00a0XX\u00a0as follows:
\u202255 \u2014 MariaDB v5.5
\u2022100 \u2014 MariaDB v10.0
\u2022101 \u2014 MariaDB v10.1
\u2022102 \u2014 MariaDB v10.2
\u2022103 \u2014 MariaDB v10.3 [requires\u00a0MySQL Governor\u00a01.2-36+; for cPanel –\u00a0MySQL Governor\u00a01.2-41+]<\/p>\n\n\n\n

Installation for\u00a0Percona Server 5.6\u00a0[requires\u00a0MySQL Governor\u00a01.1-22+ or 1.2-21+]:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –mysql-version=percona56
# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install <\/p><\/blockquote>\n\n\n\n

Please note that MySQL\/MariaDB\/Percona will be updated from CloudLinux repositories.<\/p>\n\n\n\n

If you are installing\u00a0MySQL Governor\u00a0on a server without MySQL at all, you have an opportunity to choose desired MySQL version to be installed with\u00a0MySQL Governor\u00a0installation script. Use\u00a0–mysql-version\u00a0flag before calling the installation script:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –mysql-version=MYSQL_VERSION
# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install <\/p><\/blockquote>\n\n\n\n

MYSQL_VERSION\u00a0could be chosen from the list of versions currently supported by\u00a0MySQL Governor:
mysql51 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MySQL v5.1
mysql55 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MySQL v5.5
mysql56 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MySQL v5.6
mysql57 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MySQL v5.7
mysql80 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MySQL v8.0 [requires\u00a0MySQL Governor\u00a01.2-37+; database packages are available in\u00a0Beta\u00a0only, so use\u00a0–install-beta\u00a0flag instead of\u00a0–install]
mariadb55 \u00a0 \u00a0 \u00a0 \u00a0MariaDB v5.5
mariadb100 \u00a0 \u00a0 \u00a0MariaDB v10.0
mariadb101 \u00a0 \u00a0 \u00a0MariaDB v10.1
mariadb102 \u00a0 \u00a0 \u00a0MariaDB v 10.2
mariadb103 \u00a0 \u00a0 \u00a0MariaDB v 10.3 [requires\u00a0MySQL Governor\u00a01.2-36+; for cPanel –\u00a0MySQL Governor\u00a01.2-41+]
percona56 \u00a0 \u00a0 \u00a0 \u00a0Percona Server v 5.6<\/p>\n\n\n\n

Generally,\u00a0stable\u00a0and\u00a0beta\u00a0channels contain different version of MySQL packages –\u00a0beta\u00a0contains newer version than\u00a0stable or the same one. If you would like to install\u00a0beta\u00a0packages, use\u00a0–install-beta\u00a0flag instead of\u00a0–install\u00a0when calling installation script:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install-beta <\/p><\/blockquote>\n\n\n\n

Starting with MySQL Governor version 1.2 when installing MySQL\/MariaDB MySQL Governor asks for a confirmation of a database version to be installed. To avoid such behavior for the automatic installations, please use –yes flag.<\/p>\n\n\n\n

For example:<\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –install –yes <\/p><\/blockquote>\n\n\n\n

Please note that restore of previous packages in case of failed installation would also be confirmed with\u00a0–yes\u00a0flag.<\/p>\n\n\n\n

WARNING!<\/strong> Use –yes flag on your own risk, because it \u00a0 \u00a0 \u00a0 \u00a0confirms installation in any case – even in case if there are troubles during installation (for example, network problems causing incomplete download of packages), everything would be confirmed.<\/p>\n\n\n\n

\n\n\n\n

Removing MySQL Governor <\/h4>\n\n\n\n

To remove MySQL Governor: <\/p>\n\n\n\n

# \/usr\/share\/lve\/dbgovernor\/mysqlgovernor.py –delete <\/p><\/blockquote>\n\n\n\n

The script will install original MySQL server, and remove MySQL Governor. <\/p>\n","protected":false},"excerpt":{"rendered":"

IMPORTANT: Please make full database backup (including system tables) before you will do \u00a0 \u00a0 \u00a0 \u00a0upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong. MySQL Governor is compatible only with MySQL 5.x, 8.0; MariaDB & Percona Server 5.6. To install MySQL Governor on your […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[30,38,33,34,35],"tags":[52,25,53],"class_list":["post-404","post","type-post","status-publish","format-standard","hentry","category-centos","category-cloudlinux","category-cpanel","category-linux","category-plesk","tag-governor","tag-mysql","tag-mysql-governor"],"jetpack_publicize_connections":[],"yoast_head":"\nHow to install MYSQL governor in cloudlinux<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install MYSQL governor in cloudlinux\" \/>\n<meta property=\"og:description\" content=\"IMPORTANT: Please make full database backup (including system tables) before you will do \u00a0 \u00a0 \u00a0 \u00a0upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong. MySQL Governor is compatible only with MySQL 5.x, 8.0; MariaDB & Percona Server 5.6. To install MySQL Governor on your […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-28T02:18:31+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/\",\"name\":\"How to install MYSQL governor in cloudlinux\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2019-04-28T02:18:31+00:00\",\"dateModified\":\"2019-04-28T02:18:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install MySQL Governor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install MYSQL governor in cloudlinux","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/","og_locale":"en_US","og_type":"article","og_title":"How to install MYSQL governor in cloudlinux","og_description":"IMPORTANT: Please make full database backup (including system tables) before you will do \u00a0 \u00a0 \u00a0 \u00a0upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong. MySQL Governor is compatible only with MySQL 5.x, 8.0; MariaDB & Percona Server 5.6. To install MySQL Governor on your […]","og_url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/","og_site_name":"24x7serversupport Blog","article_published_time":"2019-04-28T02:18:31+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/","url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/","name":"How to install MYSQL governor in cloudlinux","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2019-04-28T02:18:31+00:00","dateModified":"2019-04-28T02:18:31+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-governor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to install MySQL Governor"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=404"}],"version-history":[{"count":0,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/404\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}