🥇Bitrix thiab MariaDB hloov tshiab mus rau qhov tseeb ruaj khov version

Nyob zoo, cov neeg nyob hauv Khabrovsk! Cia kuv qhia kuv tus kheej, Alexander. Tus thawj tswj hwm ntawm ib qho me me tab sis zoo siab WEB studio. Peb yeej xav kom txhua yam ua haujlwm sai, nyab xeeb thiab nrog cov software tshiab kawg. Txhawm rau ua qhov no, peb txawm tau teeb tsa nagios + PhantomJS pob ntawm lub khoos phis tawj hauv chaw ua haujlwm thiab tshawb xyuas nplooj ntawv nrawm nrawm txhua 30 feeb. Raws li cov nqe lus ntawm kev pabcuam, peb kuj saib xyuas 1C-Bitrix hloov tshiab thiab nruab lawv tsis tu ncua. Thiab tom qab ntawd muaj ib hnub, tom qab hloov tshiab tom ntej, peb pom cov lus hauv pawg tswj hwm uas txij li lub caij ntuj sov xyoo 2019, 1C-Bitrix nres ua haujlwm nrog MySQL 5.5 thiab peb yuav tsum hloov kho. Cov txiv neej los ntawm ISPSystem yog cov zoo nraug thiab niaj hnub nthuav kev ua haujlwm ntawm lub vaj huam sib luag, uas tshwj xeeb ua tsaug rau lawv. Tab sis lub sijhawm no nws tsis tuaj yeem nyem txhua yam nrog tus nas. Tab sis koj tuaj yeem paub tias muaj dab tsi tshwm sim thiab muaj pes tsawg cov plaub hau grey tam sim no nyob hauv kuv hwj txwv hauv qab txiav.

Tsuas muaj ib qho kev xaiv rau nruab "lwm DBMS server" uas tau teeb tsa hauv Docker ntim. Tau kawg, kuv nkag siab tias Docker siv nyiaj ntau heev, tab sis txawm tias nws ua haujlwm zoo npaum li cas, cov nyiaj siv ua haujlwm tseem yuav yog> 0. Thiab ntawm no peb zoo li tau sib ntaus sib tua hauv kaum ntawm vib nas this thiab optimizing txhua qhov chaw ntawm qhov nkag ua ntej tshaj tawm lawv thiab kos npe rau daim ntawv cog lus. Yog li tsis yog kuv txoj kev xaiv.
Ok, cov ntaub ntawv hais li cas? Thaub qab txhua yam, ntxiv cov ntaub ntawv rau yum.repos.d nrog qhov txuas mus rau MariaDB chaw cia khoom, tom qab ntawd

rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-common

Yum yuav tom qab cog lus tias ib tug neeg rho tawm cov pob khoom yam tsis tau paub txog. Tab sis ua ntej ntawm tag nrho cov, cia nws cog lus, nws tsis ua li cas. Thiab qhov thib ob, yog tias koj ua qhov kev tshem tawm ntawm yum, ces nws sim tshem tawm, ua ke nrog MariaDB, txhua yam uas txuas nrog nws los ntawm kev vam khom, thiab qhov no suav nrog PHP thiab ISPManager thiab PHPmyadmin. Yog li ntawd, peb yuav daws nrog cov lus cog tseg tom qab.


yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-common

Feem ntau, txhua yam tau teeb tsa thiab pib. Qhov zoo tshaj plaws yog tias cov ntaub ntawv khaws cia thiab tsis tas yuav rov qab los ntawm cov khoom pov tseg. Kuv tshawb xyuas cov vev xaib - lawv ua haujlwm thiab nrawm. Kuv tau mus rau hauv ob peb qhov chaw admin kom paub tseeb tias tsis muaj dab tsi poob thiab sau rov qab rau tus thawj coj tias txhua yam zoo. Tsawg dua 30 feeb tom qab nws tau pom tias nws tsis OK tag nrho ...

Thaum kuv sim mus rau hauv cheeb tsam admin thiab ntxiv thiab kho txhua yam hauv cov ntsiab lus, cov lus tau tshwm sim

MySQL Query Error: INSERT INTO b_iblock_element_property (ID, IBLOCK_ELEMENT_ID, IBLOCK_PROPERTY_ID, VAL UE, VALUE_NUM) SELECT 10555 ,2201 ,P.ID ,'3607' ,3607.0000 FR OM b_iblock_property P WHERE ID = 184 [[1062] Duplicate entry '10555' for key 'PRIMARY']

Txij li thaum cov ntsiab lus ntawm lub xaib tau ntxiv los ntawm peb tus kheej cov neeg ua haujlwm, cov neeg siv khoom tseem tsis tau paub dab tsi thiab tseem tsis tau pib rhuav tshem peb. Tab sis nws yog ib qho teeb meem ntawm lub sij hawm, vim hais tias cov ntaub ntawv ntawm qhov chaw yuav tsum tau hloov kho, thiab ntau tus neeg tau saib xyuas qhov no lawv tus kheej.

Los ntawm cov ntawv nyeem ntawm qhov yuam kev, peb tuaj yeem txiav txim siab tias Bitrix tab tom sim ntxiv qhov kev nkag tshiab rau hauv cov ntaub ntawv thaum hais txog tib lub ntsiab tseem ceeb uas nyob hauv tsab xov xwm raug kho. Qhov no txhais tau tias muaj laj thawj xav tias qhov teeb meem tshwm sim ntawm Bitrix sab. Peb mus rau lawv lub vev xaib thiab hu rau kev txhawb nqa. Yuav luag tam sim ntawd peb tau txais cov lus teb "qhov teeb meem nyuaj. Muab rau cov engineers laus - tos ..."

Peb yuav tsum tau tos ntev heev (tag nrho cov kev sib tham tau tshwm sim thaum Lub Rau Hli 25.06.2019, 9.07.2019 txog Lub Xya Hli 10.4.6, XNUMX) thiab qhov tshwm sim yog cov lus "qhov teeb meem no tsis cuam tshuam txog kev ua haujlwm ntawm Bitrix CMS, tab sis cuam tshuam nrog kev ua haujlwm ntawm cov ntaub ntawv nws tus kheej hauv mariadb XNUMX thiab, hmoov tsis, nrog rau sab ntawm lub xaib, tsis muaj txoj hauv kev los daws qhov teeb meem no; koj yuav tsum tau hloov mus rau qhov qub version ntawm MariaDB. "

Lawv tuaj txog... Kuv xav txog kev txo qis thaum pib ntawm zaj dab neeg, tab sis nws hais tias dub thiab dawbuas yuav tsis muaj downgrade. Muab pov tseg pov tseg thiab rov xa rov qab rau ntawm lub server tiav. Cov. Nws yog qhov zoo uas kuv tsis tau hloov kho tag nrho cov servers ib zaug. Cov. "tsuas yog" ib puas qhov chaw (xav luag :-)). Cov kev txhawb nqa kuj tau hais tias: "Yuav daws qhov teeb meem thaum siv MariaDB 10.4.6 database, koj yuav tsum tau hu rau MariaDB kev txhawb nqa uas kev lag luam yuav tsis rho tawm cov ntaub ntawv los ntawm cov ntaub ntawv yog tias thov:

$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);”

Cia siab glimmered rau ob peb teev txij li lub sijhawm kuv pib sib txuas lus nrog MariaDB kev txhawb nqa, tab sis tom qab ntawd kuv tau txais tsab ntawv uas lawv tau hais rau kuv kom raug tias kuv tsis yog tus neeg siv khoom lag luam thiab yog li tsis muaj leej twg yuav muaj lub hom phiaj daws kuv qhov teeb meem, tab sis muaj. ib lub rooj sab laj ntawm lawv lub vev xaib thiab muaj koj tuaj yeem sim nrhiav kev xaiv ... Kuv yuav tsis dhuav koj nrog cov ntsiab lus. Tsis muaj kev xaiv nyob ntawd.
Hais txog! Peb yuav daim ntawv tso cai ISP!
- Nyob zoo, kev txhawb nqa? Cov txiv neej, pab!
- Thov txim, peb tsis txhawb scumbags uas hloov ib txwm versions ntawm DBMS. Yog tias koj xav tau, muaj kev xaiv nrog lwm tus neeg rau zaub mov hauv Docker.
- Tab sis yuav ua li cas cov neeg siv thiab databases tuaj txog ntawd? Rau docker?
- Zoo, koj rub lawv nrog koj txhais tes ...
- Yog! Thiab tsis txhob hnov qab tias qhov chaw nres nkoj rau mysql yuav hloov pauv thiab koj yuav tsum mus dhau tag nrho cov teeb tsa thiab rov sau lawv dua.
- Ok, ua tsaug, Kuv mam li xav txog nws ...
Kuv xav txog nws thiab txiav txim siab rau manually demolish 10.4 thiab nruab 10.2 uas tsis muaj teeb meem ntawm lwm cov servers.

Cov txheej txheem tsis txawv ntau ntawm cov txheej txheem hloov tshiab. Kuv tsuas yog yuav tsum tau hloov 10.4 rau 10.2 hauv qhov txuas mus rau qhov chaw cia khoom, rov pib dua thiab rov tsim cov cache rau yum. Zoo, ib qho ntxiv "me me": tom qab tshem tawm 10.4, mus rau /var/lib/mysql thiab rho tawm txhua yam ntawm qhov ntawd. Yog tias tsis muaj cov kauj ruam no tom qab kev txhim kho 10.2, cov kev pabcuam yuav poob tas li thiab koj yuav pom

Не удалось подключиться к базе данных '' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"

Los yog

Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104

Ua ntej importing cov databases, kuv xub teeb lub hauv paus lo lus zais rau mysql uas tau teev tseg hauv ISP configs thiab import mysql database dump. Zoo, ces, txij li thaum peb twb muaj cov neeg siv thiab cov cai, peb tsuas yog import tag nrho cov neeg siv cov ntaub ntawv hauv kab uas siv cov hauv paus account.

Script text rau database dump:

#!/bin/bash
echo 'show databases' | mysql -u root --password="ПаРоЛь_РУТА" --skip-column-names | grep -v information_schema | xargs -I {} -t bash -c 'mysqldump -u root --password="ПаРоЛь_РУТА" {} | gzip > /BACK/back-$(hostname)-{}-$(date +%Y-%m-%d-%H.%M.%S).sql.gz'

Ua ntej importing databases, koj yuav tsum unzip lawv. Yog li peb tsuas yog khiav cov lus txib

gunzip /BACK/*.gz

Thiab qhov kawg: rau qee qhov laj thawj, hyphens raug tso cai hauv lub npe ntawm cov ntaub ntawv (yog tias koj tsim nws ntawm ISPmanager). Tab sis thaum koj tsim lossis sim upload cov pob tseg rau hauv cov ntaub ntawv uas muaj hyphen hauv nws lub npe, koj tau txais cov lus hais tias qhov kev thov syntax tsis raug.

Txhua yam zoo tshaj rau cov uas nyeem kom txog thaum kawg. Kuv thov txim rau qhov feem ntau yuav misplaced commas - lawv yog ib qho teeb meem. Yog tias koj muaj lus pom zoo txog qhov tseem ceeb ntawm qhov tau piav qhia, sau rau hauv cov lus ntawm tus kheej vim kuv ntshai kuv yuav plam qee yam hauv cov lus. Thiab tsis txhob cog lus ntau dhau - qhov no yog kuv thawj tsab xov xwm :)

UPD1:

Kuv yuav luag tsis nco qab hais: thaum kuv tab tom sim nrhiav kev daws teeb meem yam tsis tau txo qis MariaDB, kuv yuav tsum tau hloov kho cov ntaub ntawv tshiab. Nws tau hloov kho zoo li no: tag nrho cov ntaub ntawv tau hloov pauv los ntawm InnoDB rau MyISAM, cov ntaub ntawv tau hloov kho thiab tom qab ntawd hloov mus rau InooDB.
UPD2:

Kuv nyuam qhuav tau txais tsab ntawv los ntawm 1C-Bitrix nrog cov ntsiab lus hauv qab no:

Thov kev kho kom tiav
"Tom qab hloov kho mariadb rau 10.4.6, qhov yuam kev tshwm sim thaum txuag lub ntsiab lus infoblock"
Module: iblock, version: tsis paub
Kev daws: tsis lees paub

Yog li nws pom tau tias tsis tuaj yeem hloov kho rau 10.4 rau tam sim no 🙁

Tau qhov twg los: www.hab.com

Bitrix thiab MariaDB hloov tshiab rau qhov tseeb ruaj khov version

Ntxiv ib saib Отменить ответ