E faʻafefea ona faʻafouina / faʻaleleia VestaCP / CWP / CentOS 7 i le lomiga lata mai o MariaDB?

I lenei aʻoaʻoga o le a taʻitaʻia oe pe faʻafefeaFaleoloa 7, faʻaleleia / faʻapipiʻi MariaDB i le lomiga lata mai o MariaDB.

O lenei aʻoaʻoga e faʻaoga foi ile CWP maVestaCPpo'o so'o se isi vaega fa'atonu VPS e fetaui lelei.

O le lomiga lata mai o MariaDB ua matua mautu nei ma tele vaega ua faʻaopoopoina ma faʻaleleia i lenei faʻasalalauga.

E te mafaiaiineiSiaki le lisi o suiga uma.

ua matou faaaogainaWordPress, Joomla, xenforo, IPS Forum ma nisi faʻalagolago e faʻalagolago iMySQL O le fa'amaumauga a le PHP a le DB e siaki mo le fa'amatalaga lata mai a MariaDB, o lea e saogalemu le fa'aleleia i lenei fa'amatalaga.

O le a le MariaDB?

O se faʻamatalaga puupuu e uiga ia MariaDB:

• MariaDB ua mamanuina eMySQLsui tuusao.
• Fa'atasi ai ma le tele o fa'ailoga: masini fou e teu ai, fa'aitiitia fa'aletonu ma sili atu le fa'atinoga.
• MariaDB na atiina ae e le tele o uluai tagata atiaʻe MySQL, o loʻo faigaluega nei mo le MariaDB Foundation ma le MariaDB Corporation, faʻapea foʻi ma le toʻatele o tagata lautele.

Ina ia faʻaleleia, mulimuli i laasaga faigofie nei e faʻaleleia ai i le lomiga fou.

Laasaga 1: Aveese MariaDB lomiga tuai

• Aveese le lomiga tuai o MariaDB, e pei o le: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

A'o le'i fa'apipi'i, e fautuaina e te toe fa'afo'i muamuaMySQL database.

Muamua, faaleoleo lau fa'aoga my.cnf o iai nei▼

cp /etc/my.cnf /etc/my.cnf.bak

• Ole taimi nei e manaʻomia ona aveese le faʻasologa o le mariadb 7 faʻapipiʻi ile centos 5.5:

Mo MariaDB 5.5 ▼

service mariadb stop / service mysql stop
rpm -e --nodeps galera
yum remove mariadb mariadb-server

• I le taimi nei MariaDB 5.5 o le a aveesea atoa, ae o le database o le a le aveesea, aua le popole.

Mo faʻamatalaga i luga atu o MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

service mysql stop 
rpm -e --nodeps galera
yum remove MariaDB-server MariaDB-client

• I le taimi nei, MariaDB 10.0/10.1/10.2/10.3 o le a faʻaumatia atoa, ae o le database o le a le tapeina, aua le popole.

Laasaga 2: Faʻapipiʻi le lomiga lata mai o MariaDB

• Mai le MariaDB 5.5/10.0/10.1/10.2/10.3 versions, faʻapipiʻi / faʻafouina i le MariaDB lomiga lata mai.

Fa'apipi'i le lomiga lata mai o le Mariadb official repo ▼

yum install nano epel-release -y

Faʻasaʻo / fatu le faila Repo/etc/yum.repos.d

Afai o loʻo i ai le tape pe faʻasaʻo faila faila o loʻo i ai nei, ia mautinoa e leai sau isi faila faila MariaDB ▼

mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak
nano /etc/yum.repos.d/mariadb.repo

Ona faapipii lea o mea nei, ma sefe▼

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/11.5.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

• O le 11.5.1 o le numera aupito lata mai lea pe a faʻafouina lenei tusiga.
• Ina ia maua le numera fou, fa'amolemole asiasi:http://yum.mariadb.org/

A maeʻa lena, matou te faʻapipiʻi le lomiga lata mai o Mariadb▼

yum clean all
yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
yum update -y

Laveai la'u.cnf faila ▼

rm -rf /etc/my.cnf
cp /etc/my.cnf.bak /etc/my.cnf

Ona, faʻagaoioia Mariadb e taʻavale, ma amata le auaunaga:

systemctl enable mariadb
service mysql start

Laasaga 3: Faʻaleleia le faʻamaumauga o loʻo iai nei

A maeʻa faʻapipiʻi, matou te manaʻomia le faʻaleleia o le database o loʻo i ai nei e ala i le faʻatonuga ▼

mysql_upgrade

• Afai e leai se mea e tupu, ua e faʻaleleia MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 i le lomiga lata mai o MariaDB.

Afai o lo'o e taina le fa'atonuga mysql_upgrade A fa'afou le fa'amaumauga, o lo'o fa'aalia mai le fe'au sese ▼

[root@ ~]# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed

Fa'amolemole fa'aaoga mea neimysql_upgrade fa'atonuga e fa'aleleia ▼

mysql_upgrade -u root --datadir=/var/lib/mysql/ --basedir=/ --password=123456

• Fa'amolemole sui le "123456" i luga i lau MySQL po'o Mariadb database root password.

Mulimuli ane, e mafai ona e faʻamaonia le MySQL poʻo le Mariadb database version e ala i le faʻaogaina o lenei poloaiga mai le SSH ▼

mysql -V

Lapataiga

Afai o lau MariaDB database o loʻo i ai se faʻamatalaga sese tutusa▼

警告：数据库错误 Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50560, now running 100406. Please use mysql_upgrade to fix this error 查询 SHOW FUNCTION STATUS

Mo fofo i MariaDB database mea sese, faamolemole kiliki le sootaga i lalo e matamata▼

🔗Foia le lapataiga: Fa'amatalaga sese E sese le numera o koluma o mysql.proc.