ßáÇæÏ áíäßÓ Cloud Linux ßíÝíÉ ÊËÈíÊ install MySQL Governor



ãÞÏãÉ :
ÇÚÑÝ ÇáÇæá äæÚ ÞÇÚÏÉ ÇáÈíÇäÇÊ æ ÇáÇÕÏÇÑ ÇáãËÈÊ áÏíß
íãßäß ãÚÑÝÉ Ðáß ãä whm Ëã phpmyadmin



ÈÚÏ Ðáß ÞÑÑ ÇáÚãá ÇãÇ Úáì MySQL or MariaDB
ãÇÐÇ ÇÎÊÇÑ ¿ ÇÎÊÇÑ Çáì íÔÇÈå ÇáÚãáÇÁ áÏíß æÎÇÕÉ ÇÐÇ ßäÊ åÊäÞá ÇáÚãáÇÁ ãä ÓíÑÝÑ Çáì ÇÎÑ
åÇã ÌÏÇ Çä íßæä äÝÓ ÇáäÙÇã áÇä ÈÚÖ ÇáãæÇÞÚ áÏíß ÞÏ Êßæä ÈÑãÌÉ ÎÇÕÉ
ÞÏ íÝÔá ÇáäÞá áåÐå ÇáãæÇÞÚ ÈÓÈÈ ÇÎÊáÇÝ ØÑÞíÉ ÇáÚãá Ýì ÞæÇÚÏ ÇáÈíÇäÇÊ.
æääÕÍ ÈÜÇáÇÔåÑ MariaDB

------------------------------------------------

ÇáÎØæÉ ÇáÇæáì

ÇÏÎá åÐÇ ÇáÇãÑ áÇÎÐ ÈÇß ßÇãá áÞæÇÚÏ ÇáÈíÇäÇÊ
áÇ ÊÞáÞá åíßæä ãÓÇÍÊÉ ÕÛíÑÉ ÌÏÇ æÝì ãáÝ æÇÍÏ

ßæÏ PHP:
mysqldump --all-databases > /root/all_databases.sql 
Ëã

1. Install the mysql-governor package:

ßæÏ PHP:
yum install governor-mysql 
2. Next the MySQL or MariaDB version will need to be selected:

Ýì ÍÇáÉ MySQL ÇÓÊÎÏã
ßæÏ PHP:

/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mysqlXX
/usr/share/lve/dbgovernor/mysqlgovernor.py --install 
Ýì ÍÇáÉ MariaDB ÇÓÊÎÏã


ßæÏ PHP:

/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadbxxx
/usr/share/lve/dbgovernor/mysqlgovernor.py --install 
$MYSQL_VERSION will be one of the following

:MariaDB:

  • mariadb100
  • mariadb101
  • mariadb102
  • mariadb103


MySQL
:

  • mysql56
  • mysql57
  • mysql80


ãáÍæÙÉ : ÇáÇÑÞÇã ÈÏæä äÞØ, ãËáÇ ãßÊæÈ 10.5 åíßæä ÇáÑÞã 105

---------------------------------------------------

ãËÇá Úãáí:

åÊÖÚ ÇÕÏÇÑ ÞÇÚÏÉ ÇáÈíÇäÇÊ ÇáÎÇÕ Èß ãËá åÐÇ

ßæÏ PHP:
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mysql80 
ãÚ ÊÛííÑ ãÇ íáÒã , ÇáÓíÑÝÑ ÇáÎÇÕ Èß íÚãá maria Çã mysql + ÇáÇÕÏÑ
æääÕÍ ÈÜ maria Ýåì ÇÝÖá

3. After selecting the version you can install:
ßæÏ PHP:
/usr/share/lve/dbgovernor/mysqlgovernor.py --install 
---------------------------------------------------------


ãÔßáÉ
MySQL Governor Showing a Malfunction in LVE Manager?;
MySQL Governor Not Configured Properly

This warning indicates that MySQL governor was not properly configured for your MySQL version. What is required is that you properly set the correct MySQL or MariaDB version for the governor, and then complete the installation of MySQL Governor once again.
Ýì åÐå ÇáÍÇáÉ íæÌÏ ãÔßáÉ ÍÏËÊ ÇËäÇÁ ÇáÊËÈíÊ áã íßÊãá
íÌÈ ÇáÈÍË Úä ÇáÍá Çæ ÇáÊÑÇÌÚ

Íá ÇáãÔßáÉ

ÇÚãá ÑíÓÊÇÑÊ ááÜ sql Ëã äÝÐ ÇáÇãÑ Install ÇáÇÎíÑ ãÑÉ ÇÎÑí

ãáÍæÙÉ : áßì íÊã ÇáÊËÈíÊ ÈäÌÇÍ íÌÈ Çä íÙåÑ complete



ÇÐåÈ ÇáÇä Çáì Cloundlinux manager Ëã MySQL Governor æÇÚãá ÍÝÙ ááÇÚÏÇÏ
Ëã Ýì ÇáÎÇÑÌ ÇÖÛØ Úáì Refresh
æãÝÑæÖ åÊÌÏå íÚãá ãÚß ÈäÌÇÍ



* Êã ÇáÊÍæíá Ïæä Çì ãÔÇßá Çæ ÎØæÑÉ

---------------------------------------------------------
ßíÝíÉ ÇáÊÑÇÌÚ ¿
---------------------------------------------------------

ßæÏ PHP:
/usr/share/lve/dbgovernor/mysqlgovernor.py --delete 
ÇáãÒíÏ ãä ÇáÊÝÇÕáí åäÇ
https://docs.cloudlinux.com/cloudlin.../#installation
https://support.cpanel.net/hc/en-us/...with-mysqldump

ÔÇåÏ ÇíÖÇ
Íá ãÔßáÉ mysqldump: Error 2013: Lost connection to server during query when dumping

ÇáãÑÌÚ:
https://blog.eldernode.com/install-m...nor-on-cpanel/
https://support.cpanel.net/hc/en-us/...MySQL-Governor
https://support.cpanel.net/hc/en-us/...MySQL-Governor
https://docs.cloudlinux.com/cloudlin.../#installation
https://support.cpanel.net/hc/en-us/...gured-Properly