Sawubona, Khabrovites othandekayo! Ngivumele ngizethule, Alexander. Umqondisi wesistimu we-WEB-studio eyodwa encane kodwa eziqhenyayo. Sifuna ngempela ukuthi yonke into isebenze ngokushesha, ngokuphepha nangesofthiwe entsha. Ukwenza lokhu, saze saphakamisa inqwaba ye-nagios + PhantomJS kukhompuyutha yangaphakathi ehhovisi futhi sihlola isivinini sokulayisha ikhasi njalo ngemizuzu engama-30. Ngokwemigomo yesevisi, siphinde siqaphe izibuyekezo ze-1C-Bitrix futhi sizifake njalo. Bese kuthi ngolunye usuku, ngemuva kwesibuyekezo esilandelayo, sibona umlayezo kuphaneli yomqondisi othi kusukela ehlobo lika-2019, i-1C-Bitrix iyayeka ukusebenza nge-MySQL 5.5 futhi idinga ukubuyekezwa. Abafana abavela ku-ISPSystem bahle futhi bavame ukwandisa ukusebenza kwephaneli, okuyinto ebonga ngokukhethekile kubo. Kodwa kulokhu akwenzekanga ukuchofoza yonke into ngegundane. Kodwa kwenzekani futhi zingaki izinwele ezimpunga manje ezisentshebeni yami zingatholakala ngaphansi kokusikwa.
Kube khona kuphela inketho yokufaka "enye iseva ye-DBMS" efakwe esitsheni se-Docker. Yebo, ngiyaqonda ukuthi i-Docker iyonga kakhulu ngezinsiza, kodwa noma ngabe isebenza kahle kangakanani, i-overhead isazoba > 0. Futhi nakhu, njengokungathi, silwa ngemizuzwana eyishumi futhi silungiselela wonke amasayithi emnyango ngaphambi kokushicilela nokusayina isivumelwano. Ngakho hhayi ukukhetha kwami.
Kulungile, yini ekumadokhumenti? Yenza ikhophi yasenqolobaneni yonke into, engeza ifayela elinesixhumanisi sekhosombe lika-MariaDB kokuthi yum.repos.d, bese
rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-commonNgemuva kwalokho u-Yum uzofunga ukuthi othile ukhiphe amaphakheji ngaphandle kokwazi kwakhe. Kodwa okokuqala - makafunge, kulungile. Futhi okwesibili, uma wenza ukususa nge-yum, bese izama ukudiliza, kanye no-MariaDB, yonke into ehlobene nayo ngokuncika, futhi lena yi-PHP ne-ISPManager ne-PHPmyadmin. Ngakho sizobhekana nezimbungulu kamuva.
yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-commonNgokuvamile, yonke into yamiswa futhi yaqalwa. Into enhle ukuthi izisekelo zathathwa futhi kwakungadingekile ukuzibuyisela ekulahleni. Ngihlole amasayithi - ayasebenza futhi ngokushesha. Ngiye kumaphaneli ambalwa wokuphatha ukuze ngiqinisekise ukuthi akukho lutho oluwayo futhi ngazikhipha ohlwini lomqondisi ukuthi konke kuhamba kahle. Esikhathini esingaphansi kwemizuzu engama-30, kwavela ukuthi akulungile neze ...
Lapho ngizama ukuya kuphaneli yomqondisi futhi ngengeza ukuhlela noma yini kokuqukethwe, umlayezo wawa
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']Njengoba okuqukethwe kusayithi kwenezelwa ngabasebenzi bethu, amakhasimende abengazi lutho futhi ayengakaqali ukusihlukanisa. Kodwa kwakuyindaba yesikhathi, ngoba ulwazi olukumasayithi ludinga ukubuyekezwa, futhi amaklayenti amaningi alandela lokhu eduze kakhulu.
Kusukela kumbhalo wephutha, singaphetha ngokuthi i-Bitrix izama ukwengeza irekhodi elisha kusizindalwazi, kuyilapho icacisa ukhiye oyinhloko ofanayo nalowo i-athikili ehlelwayo eyayinawo. Ngakho kunesizathu sokusola ukuthi inkinga yenzeka ngasohlangothini lwe-Bitrix. Iya kuwebhusayithi yabo futhi uthinte abosekelo. Cishe ngokushesha sithola impendulo βinkinga enzima. Inikeze onjiniyela abakhulu - linda ... "
Kwadingeka ngilinde isikhathi eside (yonke inkhulumomphendvulwano yenzeka kusukela ngomhlaka-25.06.2019/9.07.2019/10.4.6 kuya ku-XNUMX/XNUMX/XNUMX) futhi umphumela waba umlayezo othi βle nkinga ayihlobene nokusebenza kwe-Bitrix CMS, kodwa ihlobene. ekusebenzeni kwesizindalwazi uqobo ku-mariadb XNUMX futhi, ngeshwa, ohlangothini lwesayithi le nkinga yokuxazulula okungenzeka ayikho, kuzodingeka ukuthi uthuthele enguqulweni yakudala ye-MariaDB."
Ngahamba ngomkhumbi ... Ngacabanga ngokwehlisa izinga ekuqaleni kwendaba, kodwa ukuthi angeke kube khona ukwehliswa. Hlanganisa ukulahlwa futhi ukhiphe kabusha kuseva esanda kufakwa. Labo. kuhle ukuthi angizange ngibuyekeze wonke amaseva ngesikhathi esisodwa. Labo. βkuphelaβ amasayithi ayikhulu (i-nervous chuckle :-)). Baphinde bathi ukweseka: βUkuze uxazulule inkinga lapho usebenzisa isizindalwazi se-MariaDB 10.4.6, uzodinga ukuthintana nokwesekwa kwezobuchwepheshe kwe-MariaDB ukuthi okwenziwayo ngeke kususe irekhodi kusizindalwazi uma isicelo senziwe:
$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);β
Ithemba lakhanya amahora ambalwa kusukela ngesikhathi siqala ukuxhumana nokusekelwa kwe-MariaDB, kodwa ngabe sengithola incwadi lapho ngaziswe khona kahle ukuthi angiyena umsebenzisi wezohwebo ngakho-ke akekho ongaxazulula inkinga yami ngenhloso, kodwa kukhona inkundla kusizindalwazi sabo futhi ungazama ukubheka izinketho lapho β¦ ngeke ngikukhathaze ngemininingwane. Azikho izinketho lapho.
MAYELANA! Sithenge ilayisensi ye-ISP!
Sawubona, sisekela? Madoda, sizani!
- Uxolo, asizisekeli izigebengu ezishintsha izinguqulo zomdabu ze-DBMS. Uma ufuna, kukhona inketho ngenye iseva ku-docker.
- Kodwa abasebenzisi kanye nesizindalwazi bazofika kanjani lapho? Ku-docker?
- Awu, ubadonsele lapho ngezandla zakho ...
- Yebo! Futhi ungakhohlwa ukuthi ichweba le-mysql lizoshintsha futhi uzodinga ukudlula futhi ubhale kabusha zonke izilungiselelo.
Kulungile ngiyabonga, ngizocabanga ngakho...
Ngacabanga futhi nganquma ukudiliza i-10.4 ngezibambo futhi ngifake i-10.2 okungazange kube nezinkinga ngayo kwamanye amaseva.
Inqubo ibingehluke kakhulu kunqubo yokuthuthukisa. Kuphela bekudingekile ukushintsha u-10.4 kuye ku-10.2 kusixhumanisi esiya endaweni yokugcina, ukusetha kabusha futhi udale kabusha inqolobane ye-yum. Nokho, "i-trifle" eyodwa ngaphezulu: ngemva kokukhipha i-10.4, siya ku-/var/lib/mysql bese sisusa yonke into lapho. Ngaphandle kwalesi sinyathelo, ngemuva kokufaka i-10.2, isevisi izohlala iphahlazeka futhi uzobona
ΠΠ΅ ΡΠ΄Π°Π»ΠΎΡΡ ΠΏΠΎΠ΄ΠΊΠ»ΡΡΠΈΡΡΡΡ ΠΊ Π±Π°Π·Π΅ Π΄Π°Π½Π½ΡΡ
'' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"Noma
Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104Ngaphambi kokungenisa izingosi zolwazi, ngiqale ngisethe iphasiwedi yempande ye-mysql eyayishiwo ku-ISP configs futhi ngangenisa indawo yokulahlwa yedatha ye-mysql. Ngakho-ke, njengoba sekunabasebenzisi namalungelo, sivele singenise yonke imininingwane yabasebenzisi ilandelana nge-akhawunti yempande.
Umbhalo weskripthi wokulahlwa kwesizindalwazi:
#!/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'Ngaphambi kokungenisa imininingo egciniwe, udinga ukuyivula. Ngakho vele ugijime umyalo
gunzip /BACK/*.gzFuthi into yokugcina: ngesizathu esithile, amakhonco avunyelwe kumagama esizindalwazi (uma uwadala usebenzisa i-ISPmanager). Kodwa lapho udala noma uzama ukulayisha ukulahlwa kusizindalwazi esine-hyphen egameni, uthola umlayezo wokuthi i-syntax yombuzo ayilungile.
Funda kuze kube sekugcineni kwazo zonke izibusiso. Ngiyaxolisa ngamakhoma okungenzeka awahlukanisiwe - asenkingeni. Uma kunezifiso zesiphakamiso esichazwe ngokuyisisekelo - bhala ngomuntu siqu ngoba kumazwana ngiyesaba ukuphuthelwa okuthile. Futhi ungafungi kakhulu - lesi yisihloko sami sokuqala π
UPD1:
Ngicishe ngakhohlwa ukusho: ngenkathi ngizama ukuthola isisombululo senkinga ngaphandle kokwehlisa uMariaDB, bekufanele ngandlela thize ngibuyekeze imininingwane. Ibuyekezwe kanje: yonke imininingwane egciniwe iguqulwa isuka ku-InnoDB iye ku-MyISAM, i-infa iyabuyekezwa bese iguqulwa ibuyiselwe ku-InooDB.
UPD2:
Ngisanda kuthola incwadi evela ku-1C-Bitrix enokuqukethwe okulandelayo:
Isicelo sokubuyekeza siqediwe
"Ngemva kokubuyekeza i-mariadb iye ku-10.4.6, kwenzeke iphutha ngesikhathi silondoloza isici se-infoblock"
Imojula: iblock, inguqulo: ayaziwa
Isixazululo: kwaliwe
Ngakho-ke okwamanje, ngokusobala akunakwenzeka ukuthi ubuyekezele ku-10.4 π
Source: www.habr.com