Tsiku labwino, okondedwa okhala ku Khabrovsk! Ndiroleni ndidzidziwitse ndekha, Alexander. Woyang'anira kachitidwe ka situdiyo imodzi yaying'ono koma yonyada ya WEB. Tikufuna kuti chilichonse chizigwira ntchito mwachangu, mosamala komanso ndi mapulogalamu aposachedwa. Kuti tichite izi, tidayikanso mtolo wa nagios+PhantomJS pakompyuta yamkati yaofesi ndikuwona kuthamanga kwa tsambalo mphindi 30 zilizonse. Malinga ndi zomwe zikugwiritsidwa ntchito, timayang'aniranso zosintha za 1C-Bitrix ndikuziyika pafupipafupi. Ndiyeno tsiku lina, pambuyo pa zosintha zina, tikuwona uthenga mu gulu la admin kuti kuyambira chilimwe cha 2019, 1C-Bitrix imasiya kugwira ntchito ndi MySQL 5.5 ndipo tiyenera kusintha. Anyamata ochokera ku ISPSystem ndi okongola komanso amakulitsa magwiridwe antchito a gululo, omwe amawathokoza mwapadera. Koma nthawi ino sikunatheke kudina chilichonse ndi mbewa. Koma mutha kudziwa zomwe zidachitika komanso ndi imvi zingati zomwe zili mu ndevu zanga zomwe zidadulidwa.
Panali njira yokhayo kukhazikitsa "seva ina ya DBMS" yomwe imayikidwa mu chidebe cha Docker. Zachidziwikire, ndikumvetsetsa kuti Docker ndiyopanda ndalama zambiri ndi zinthu, koma zilibe kanthu momwe zimagwirira ntchito, kupitilira apo kudzakhala> 0. Ndipo apa tikuwoneka kuti tikumenyana mumasekondi khumi ndikukonza malo onse pakhomo tisanawasindikize ndikusaina mgwirizano. Chifukwa chake sichosankha changa.
Chabwino, zolembedwazo zikuti chiyani? Sungani zonse, onjezani fayilo ku yum.repos.d yokhala ndi ulalo kunkhokwe ya MariaDB, ndiye
rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-commonPambuyo pake Yum adzalumbira kuti wina adachotsa phukusi popanda kudziwa. Koma choyamba, mulole iye alumbire, zili bwino. Ndipo chachiwiri, ngati mutachotsa kudzera mu yum, ndiye amayesa kuchotsa, pamodzi ndi MariaDB, chirichonse chomwe chikugwirizana nacho mwa kudalira, ndipo izi zikuphatikizapo PHP ndi ISPManager ndi PHPmyadmin. Chifukwa chake, tidzakambirana za matendawa pambuyo pake.
yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-commonNthawi zambiri, zonse zidayikidwa ndikuyambika. Chosangalatsa ndichakuti ma database adatoledwa ndipo panalibe chifukwa chowabwezeretsa kuchokera ku zinyalala. Ndidayang'ana mawebusayiti - amagwira ntchito komanso akuthamanga. Ndinapita kumadera angapo a admin kuti ndiwonetsetse kuti palibe chomwe chagwa ndikulembera kwa wotsogolera kuti zonse zili bwino. Pasanathe mphindi 30 zidapezeka kuti sizili bwino ...
Nditayesa kupita kudera la admin ndikuwonjezera ndikusintha chilichonse chomwe chili muzolembazo, uthenga unatuluka
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']Popeza zomwe zili patsambali zikuwonjezedwa ndi antchito athu, makasitomala samadziwa kalikonse ndipo sanayambebe kutilekanitsa. Koma inali nkhani ya nthawi, chifukwa zambiri zamasamba ziyenera kusinthidwa, ndipo makasitomala ambiri amayang'anitsitsa izi okha.
Kuchokera pamawu a cholakwikacho, titha kunena kuti Bitrix ββakuyesera kuwonjezera cholowa chatsopano pankhokwe pomwe akufotokoza fungulo lomwelo lomwe linali m'nkhani yomwe ikukonzedwa. Izi zikutanthauza kuti pali chifukwa chokayikira kuti vuto limabwera kumbali ya Bitrix. Timapita patsamba lawo ndikulumikizana ndi chithandizo. Pafupifupi nthawi yomweyo timapeza yankho "vuto lovuta. Ndipatseni mainjiniya akuluakulu - dikirani. ββ¦
Tidadikirira nthawi yayitali (makambirano onse adachitika kuyambira Juni 25.06.2019, 9.07.2019 mpaka Julayi 10.4.6, XNUMX) ndipo zotsatira zake zinali uthenga "vutoli silikukhudzana ndi magwiridwe antchito a Bitrix CMS, koma likugwirizana ndi Kugwira ntchito kwa database yokha mu mariadb XNUMX ndipo, mwatsoka, ndi Pamalo atsamba, palibe njira yothetsera vutoli; muyenera kusinthira ku mtundu wakale wa MariaDB. "
Iwo anafika ... Ndinaganiza za kutsitsa koyambirira kwa nkhaniyi, koma kuti sipangakhale kutsitsa. Taya zinyalala ndi kuyikanso pa seva yokhazikitsidwa kwathunthu. Iwo. Ndibwino kuti sindinasinthe ma seva onse nthawi imodzi. Iwo. "okha" masamba zana (kuseka mwamantha :-)). Thandizolo linanenanso kuti: "Kuti muthetse vutoli mukamagwiritsa ntchito database ya MariaDB 10.4.6, muyenera kulumikizana ndi thandizo laukadaulo la MariaDB kuti malondawo asachotsere mbiri kuchokera ku database ngati pempho laperekedwa:
$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);β
Chiyembekezo chidawoneka kwa maola angapo kuyambira pomwe ndidayamba kulumikizana ndi thandizo la MariaDB, koma ndidalandira kalata yomwe adandiuza molondola kuti sindine wogwiritsa ntchito malonda chifukwa chake palibe amene angathetse vuto langa mwadala, koma pali bwalo patsamba lawo ndipo mutha kuyesa kuyang'ana zosankha ... sindidzakuvutitsani ndi tsatanetsatane. Palibe zosankha pamenepo.
ZA! Tinagula chilolezo cha ISP!
- Hello, thandizo? Anyamata, thandizo!
- Pepani, sitigwirizana ndi scumbags omwe amasintha mtundu wa DBMS. Ngati mukufuna, pali mwayi wokhala ndi seva ina ku Docker.
- Koma ogwiritsa ntchito ndi nkhokwe zifika bwanji kumeneko? Ku docker?
- Chabwino, mumawakokera pamenepo ndi manja anu ...
- Inde! Ndipo musaiwale kuti doko la mysql lidzasintha ndipo muyenera kudutsa ma configs onse ndikulembanso.
- Chabwino, zikomo, ndikuganiza ...
Ndinaganiza za izi ndipo ndinaganiza zogwetsa pamanja 10.4 ndikuyika 10.2 yomwe panalibe zovuta pamaseva ena.
Njirayi sinali yosiyana kwambiri ndi ndondomeko yosinthira. Ndinangofunika kusintha 10.4 kukhala 10.2 mu ulalo wosungirako, kukonzanso ndikupanganso cache ya yum. Chabwino, "chinthu chaching'ono" china: mutachotsa 10.4, pitani ku /var/lib/mysql ndikuchotsa chilichonse pamenepo. Popanda sitepe iyi mutatha kukhazikitsa 10.2, ntchitoyi idzawonongeka nthawi zonse ndipo mudzawona
ΠΠ΅ ΡΠ΄Π°Π»ΠΎΡΡ ΠΏΠΎΠ΄ΠΊΠ»ΡΡΠΈΡΡΡΡ ΠΊ Π±Π°Π·Π΅ Π΄Π°Π½Π½ΡΡ
'' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"Kapena
Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104Ndisanalowetse nkhokwe, ndidayamba ndikuyika mawu achinsinsi a mysql omwe adafotokozedwa mu ISP configs ndikulowetsa malo a database a mysql. Chabwino, ndiye, popeza tili ndi ogwiritsa ntchito kale ndi ufulu, timangolowetsa zolemba zonse motsatana pogwiritsa ntchito mizu ya akaunti.
Script yotayidwa mu database:
#!/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'Musanalowetse ma database, muyenera kuwatsegula. Kotero ife timangoyendetsa lamulo
gunzip /BACK/*.gzNdipo pomaliza: pazifukwa zina, ma hyphens amaloledwa m'dzina la database (ngati mupanga kudzera pa ISPmanager). Koma mukamapanga kapena kuyesa kuyika zotayira ku database yomwe ili ndi hyphen m'dzina lake, mumalandira uthenga woti mawu opemphawo ndi olakwika.
Zabwino zonse kwa amene awerenga mpaka kumapeto. Ndikupepesa chifukwa cha comma yomwe yasokonekera - ndizovuta. Ngati muli ndi malingaliro okhudzana ndi zomwe zafotokozedwa, lembani uthenga wanu chifukwa ndikuwopa kuti ndiphonya china chake mu ndemanga. Ndipo osalumbira kwambiri - iyi ndi nkhani yanga yoyamba :)
UPD1:
Ndinatsala pang'ono kuiwala kutchula: pamene ndikuyesera kupeza njira yothetsera vutoli popanda kutsitsa MariaDB, ndinayenera kukonzanso zambiri. Idasinthidwa motere: database yonse imasinthidwa kuchokera ku InnoDB kupita ku MyISAM, zambiri zimasinthidwa ndikusinthidwa ku InooDB.
UPD2:
Ndangolandira kalata yochokera ku 1C-Bitrix yokhala ndi izi:
Pempho lowunikiridwalo latha
"Mutakweza mariadb kukhala 10.4.6, cholakwika chidachitika posunga infoblock"
Module: iblock, mtundu: wosadziwika
Yankho: kukanidwa
Chifukwa chake zikuwoneka kuti sizingatheke kusinthira ku 10.4 pakadali pano π
Source: www.habr.com