Bitrix ืื•ืŸ MariaDB ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืฆื• ื“ื™ ืœืขืฆื˜ืข ืกื˜ืึทื‘ื™ืœ ื•ื•ืขืจืกื™ืข

ืึท ื’ื•ื˜ืŸ ื˜ืึธื’, ื˜ื™ื™ืขืจืข ื›ืึทื‘ืจืึธื•ื•ืกืงื™ืฉืข ืื™ื™ื ื•ื•ืื•ื™ื ืขืจ! ืœืืžื™ืš ืžื™ืš ืคืืจืฉื˜ืขืœืŸ, ืืœืขืงืกืื ื“ืขืจ. ืกื™ืกื˜ืขื ืึทื“ืžื™ื ื™ืกื˜ืจืึทื˜ืึธืจ ืคื•ืŸ ืื™ื™ืŸ ืงืœื™ื™ืŸ ืึธื‘ืขืจ ืฉื˜ืึธืœืฅ ื•ื•ืขื‘ ืกื˜ื•ื“ื™ืข. ืžื™ืจ ื˜ืึทืงืข ื•ื•ื™ืœืŸ ืึทืœืฅ ืฆื• ืึทืจื‘ืขื˜ืŸ ื’ืขืฉื•ื•ื™ื ื“, ื‘ืขืฉืึธืœืขื ืื•ืŸ ืžื™ื˜ ื“ื™ ืœืขืฆื˜ืข ื•ื•ื™ื™ื›ื•ื•ืืจื’. ืฆื• ื˜ืึธืŸ ื“ืึธืก, ืžื™ืจ ืืคื™ืœื• ืื™ื ืกื˜ืึทืœื™ืจืŸ ื“ื™ ืคึผืขืงืœ Nagios + PhantomJS ืื•ื™ืฃ ื“ื™ ื™ื ื˜ืจืึท-ืึธืคื™ืก ืงืึธืžืคึผื™ื•ื˜ืขืจ ืื•ืŸ ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ื™ ืœืึธื•ื“ื™ื ื’ ื’ื™ื›ืงื™ื™ึทื˜ ืคื•ืŸ ื“ื™ ื‘ืœืึทื˜ ื™ืขื“ืขืจ 30 ืžื™ื ื•ื˜. ืœื•ื™ื˜ ื“ื™ ื˜ืขืจืžื™ื ืขืŸ ืคื•ืŸ ื“ื™ื ืกื˜, ืžื™ืจ ืื•ื™ืš ืžืึธื ื™ื˜ืึธืจ 1C-Bitrix ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื•ื ื’ืขืŸ ืื•ืŸ ื™ื ืกื˜ืึทืœื™ืจืŸ ื–ื™ื™ ืงืขืกื™ื™ื“ืขืจ. ืื•ืŸ ืื™ื™ืŸ ื˜ืึธื’, ื ืึธืš ื“ืขืจ ื•ื•ื™ื™ึทื˜ืขืจ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ, ืžื™ืจ ื–ืขืŸ ืึท ืึธื ื–ืึธื’ ืื™ืŸ ื“ื™ ืึทื“ืžื™ืŸ ื˜ืึทืคืœื™ืข ืึทื– ื–ื™ื ื˜ ื“ื™ ื–ื•ืžืขืจ ืคื•ืŸ 2019, 1C-Bitrix ืกื˜ืึทืคึผืก ืืจื‘ืขื˜ืŸ ืžื™ื˜ MySQL 5.5 ืื•ืŸ ืžื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ. ื“ื™ ื’ื™ื™ื– ืคื•ืŸ ISPSystem ื–ืขื ืขืŸ ืฉื™ื™ืŸ ืื•ืŸ ืงืขืกื™ื™ื“ืขืจ ื™ืงืกืคึผืึทื ื“ ื“ื™ ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ืคื•ืŸ ื“ื™ ื˜ืึทืคืœื™ืข, ืคึฟืึทืจ ื•ื•ืึธืก ืกืคึผืขืฆื™ืขืœ ื“ืึทื ืง ืฆื• ื–ื™ื™. ืื‘ืขืจ ื“ืึธืก ืžืึธืœ ืขืก ืื™ื– ื ื™ื˜ ืžืขื’ืœืขืš ืฆื• ื’ื™ื˜ ืึทืœืฅ ืžื™ื˜ ื“ื™ ืžื•ื™ื–. ืื™ืจ ืงืขื ื˜ ื–ื™ืš ืึธื‘ืขืจ ื“ืขืจื•ื•ื™ืกืŸ ื•ื•ืึธืก ืื™ื– ื’ืขืฉืขืŸ ืื•ืŸ ื•ื•ื™ืคึฟืœ ื’ืจื•ื™ืข ื”ืึธืจ ื–ืฒึทื ืขืŸ ืื™ืฆื˜ ืื™ืŸ ืžืฒึทืŸ ื‘ืขืจื“ ืื•ื ื˜ืขืจ ื“ืขืจ ืฉื ื™ื˜.

ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ื‘ืœื•ื™ื– ืึทืŸ ืึธืคึผืฆื™ืข ืฆื• ื™ื ืกื˜ืึทืœื™ืจืŸ ืึทืŸ "ืึธืœื˜ืขืจื ืึทื˜ื™ื•ื• DBMS ืกืขืจื•ื•ืขืจ" ื•ื•ืึธืก ืื™ื– ืื™ื ืกื˜ืึทืœื™ืจืŸ ืื™ืŸ ืึท ื“ืึธืงืงืขืจ ืงืึทื ื˜ื™ื™ื ืขืจ. ื“ืึธืš, ืื™ืš ืคึฟืึทืจืฉื˜ื™ื™ืŸ ืึทื– ื“ืึธืงืขืจ ืื™ื– ื–ื™ื™ืขืจ ืฉืคึผืึธืจืขื•ื•ื“ื™ืง ืžื™ื˜ ืจืขืกื•ืจืกืŸ, ืึธื‘ืขืจ ืงื™ื™ืŸ ืขื ื™ืŸ ื•ื•ื™ ื’ืจื•ื™ืก ืขืก ืึทืจื‘ืขื˜, ื“ื™ ืึธื•ื•ื•ืขืจื›ืขื“ ื•ื•ืขื˜ ื ืึธืš ื–ื™ื™ืŸ> 0. ืื•ืŸ ื“ืึธ ืžื™ืจ ื•ื™ืกืงื•ืžืขืŸ ืฆื• ืงืขืžืคืŸ ืื™ืŸ ืฆืขื ื˜ ืกืขืงื•ื ื“ืขืก ืื•ืŸ ืึธืคึผื˜ื™ืžื™ื–ื™ืจืŸ ืึทืœืข ื–ื™ื™ื˜ืœืขืš ืื™ืŸ ื“ื™ ืึทืจื™ื™ึทื ื’ืึทื ื’ ืื™ื™ื“ืขืจ ื–ื™ื™ ืึทืจื•ื™ืกื’ืขื‘ืŸ ืื•ืŸ ืื•ื ื˜ืขืจืฉืจื™ื™ื‘ืŸ ืึทืŸ ื”ืขืกืงืขื. ืึทื–ื•ื™ ื ื™ืฉื˜ ืžื™ื™ืŸ ืึธืคึผืฆื™ืข.
ืืงืขื™, ื•ื•ืืก ื–ืื’ื˜ ื“ื™ ื“ืืงื•ืžืขื ื˜ืืฆื™ืข? ื‘ืึทืงืงื•ืคึผ ืึทืœืฅ, ืœื™ื™ื’ ืึท ื˜ืขืงืข ืฆื• yum.repos.d ืžื™ื˜ ืึท ืœื™ื ืง ืฆื• ื“ื™ MariaDB ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™, ื“ืขืžืึธืœื˜

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

ื™ืื ื•ื•ืขื˜ ื ืื›ื“ืขื ืฉื•ื•ืขืจืŸ ืื– ืื™ื™ื ืขืจ ื”ืื˜ ืื•ื™ืกื’ืขืžืขืงื˜ ื“ื™ ืคืขืงืœืขืš ืืŸ ื–ื™ื™ืŸ ื•ื•ื™ืกืŸ. ืื‘ืขืจ ืงื•ื“ื ื›ืœ, ื–ืืœ ืขืจ ืฉื•ื•ืขืจืŸ, ืขืก ืื™ื– ื’ื•ื˜. ืื•ืŸ ืฆื•ื•ื™ื™ื˜ื ืก, ืื•ื™ื‘ ืื™ืจ ื˜ืึธืŸ ื“ื™ ื“ื™ืœื™ืฉืึทืŸ ื“ื•ืจืš ื™ืึทื, ืขืก ืคืจื•ื•ื•ื˜ ืฆื• ื‘ืึทื–ื™ื™ึทื˜ื™ืงืŸ, ืฆื•ื–ืึทืžืขืŸ ืžื™ื˜ MariaDB, ืึทืœืฅ ื•ื•ืึธืก ืื™ื– ืคืืจื‘ื•ื ื“ืŸ ืฆื• ืื™ื ื“ื•ืจืš ื“ืขืคึผืขื ื“ืขื ืกื™, ืื•ืŸ ื“ืึธืก ื›ื•ืœืœ PHP ืื•ืŸ ISPManager ืื•ืŸ PHPmyadmin. ื“ืขืจื™ื‘ืขืจ, ืžื™ืจ ื•ื•ืขืœืŸ ื”ืึทื ื“ืœืขืŸ ืžื™ื˜ ื“ื™ ืฉื•ื•ืขืจืŸ ืฉืคึผืขื˜ืขืจ.


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

ืื™ืŸ ืึทืœื’ืขืžื™ื™ืŸ, ืึทืœืฅ ืื™ื– ืื™ื ืกื˜ืึทืœื™ืจืŸ ืื•ืŸ ืกื˜ืึทืจื˜ืขื“. ื“ื™ ืคื™ื™ึทืŸ ื–ืึทืš ืื™ื– ืึทื– ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื–ืขื ืขืŸ ืคึผื™ืงื˜ ืึทืจื•ื™ืฃ ืื•ืŸ ืขืก ืื™ื– ื ื™ื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื•ืžืงืขืจืŸ ื–ื™ื™ ืคื•ืŸ ื“ืึทืžืคึผืก. ืื™ืš ืึธืคึผื’ืขืฉื˜ืขืœื˜ ื“ื™ ื–ื™ื™ื˜ืœืขืš - ื–ื™ื™ ืึทืจื‘ืขื˜ ืื•ืŸ ื–ืขื ืขืŸ ืฉื ืขืœ. ืื™ืš ื’ืขื’ืื ื’ืขืŸ ืื™ืŸ ืึท ืคึผืึธืจ ืคื•ืŸ ืึทื“ืžื™ื ื™ืกื˜ืจืึทื˜ืึธืจ ื’ืขื‘ื™ื˜ืŸ ืฆื• ืžืึทื›ืŸ ื–ื™ื›ืขืจ ืึทื– ื’ืึธืจื ื™ืฉื˜ ืื™ื– ื’ืขืคืืœืŸ ืึทื•ื•ืขืง ืื•ืŸ ื’ืขืฉืจื™ื‘ืŸ ืฆื•ืจื™ืง ืฆื• ื“ืขืจ ื“ื™ืจืขืงื˜ืึธืจ ืึทื– ืึทืœืฅ ืื™ื– ื’ื•ื˜. ื•ื•ื™ื™ื ื™ืงืขืจ ื•ื•ื™ 30 ืžื™ื ื•ื˜ ืฉืคึผืขื˜ืขืจ ืขืก ืคืืจืงืขืจื˜ ืื•ื™ืก ืึทื– ืขืก ืื™ื– ื ื™ืฉื˜ ื’ื•ื˜ ...

ื•ื•ืขืŸ ืื™ืš ื’ืขืคืจื•ื•ื•ื˜ ืฆื• ื’ื™ื™ืŸ ืื™ืŸ ื“ื™ ืึทื“ืžื™ื ื™ืกื˜ืจืึทื˜ืึธืจ ื’ืขื’ื ื˜ ืื•ืŸ ืœื™ื™ื’ืŸ ืื•ืŸ ืจืขื“ืึทื’ื™ืจืŸ ืขืคึผืขืก ืื™ืŸ ื“ื™ ืื™ื ื”ืึทืœื˜, ืึท ืึธื ื–ืึธื’ ืคึผืึทืคึผื˜ ืึทืจื•ื™ืฃ

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']

ื–ื™ื ื˜ ื“ื™ ืื™ื ื”ืึทืœื˜ ืื•ื™ืฃ ื“ืขื ืคึผืœืึทืฅ ืื™ื– ืฆื•ื’ืขืœื™ื™ื’ื˜ ื“ื•ืจืš ืื•ื ื“ื–ืขืจ ืื™ื™ื’ืขื ืข ืขืžืคึผืœื•ื™ื™ื–, ื“ื™ ืงืœื™ื™ืึทื ืฅ ื”ืึธื‘ืŸ ื ื™ืฉื˜ ื•ื•ื™ืกืŸ ืขืคึผืขืก ื ืึธืš ืื•ืŸ ื”ืึธื‘ืŸ ื ื™ืฉื˜ ื ืึธืš ืื ื’ืขื”ื•ื™ื‘ืŸ ืฆื• ืจื™ื™ึทืกืŸ ืื•ื ื“ื–. ืื‘ืขืจ ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ืึท ืขื ื™ืŸ ืคื•ืŸ ืฆื™ื™ื˜, ื•ื•ื™ื™ึทืœ ื“ื™ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืื•ื™ืฃ ื“ื™ ื–ื™ื™ื˜ืœืขืš ื“ืึทืจืฃ ื–ื™ื™ืŸ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื˜, ืื•ืŸ ืคื™ืœืข ืงืœื™ื™ืึทื ืฅ ืขื ื’ ืžืึธื ื™ื˜ืึธืจ ื“ืขื ื–ื™ืš.

ืคึฟื•ืŸ ื“ืขื ื˜ืขืงืกื˜ ืคื•ืŸ ื“ืขื ื˜ืขื•ืช, ืžื™ืจ ืงืขื ืขืŸ ืคืึทืจืขื ื“ื™ืงืŸ ืึทื– Bitrix ืื™ื– ื˜ืจื™ื™ื ื’ ืฆื• ืœื™ื™ื’ืŸ ืึท ื ื™ื™ึทืข ืคึผืึธื–ื™ืฆื™ืข ืฆื• ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื•ืŸ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื–ืขืœื‘ืข ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ืื™ืŸ ื“ืขื ืึทืจื˜ื™ืงืœ. ื“ืขื ืžื™ื˜ืœ ืขืก ืื™ื– ืกื™ื‘ื” ืฆื• ื›ืึธืฉืขื“ ืึทื– ื“ื™ ืคึผืจืึธื‘ืœืขื ืขืจื™ื™ื–ืึทื– ืื•ื™ืฃ ื“ื™ ื‘ื™ื˜ืจื™ืงืก ื–ื™ื™ึทื˜. ืžื™ืจ ื’ื™ื™ืŸ ืฆื• ื–ื™ื™ืขืจ ื•ื•ืขื‘ื–ื™ื™ื˜ืœ ืื•ืŸ ืงืึธื ื˜ืึทืงื˜ ืฉื˜ื™ืฆืŸ. ื›ึผืžืขื˜ ื’ืœื™ื™ืš ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ ื“ื™ ืขื ื˜ืคืขืจ "ืงืึธืžืคึผืœื™ืฆื™ืจื˜ ืคึผืจืึธื‘ืœืขื. ื’ืขื’ืขื‘ืŸ ืขืก ืฆื• ืขืœื˜ืขืจ ืขื ื“ื–ืฉืึทื ื™ืจื– - ื•ื•ืึทืจื˜ืŸ ... "

ืžื™ืจ ื”ืึธื‘ืŸ ืฆื• ื•ื•ืึทืจื˜ืŸ ื’ืึทื ืฅ ืึท ืœืึทื ื’ ืฆื™ื™ึทื˜ (ื“ื™ ื’ืื ืฆืข ื“ื™ืึทืœืึธื’ ืื™ื– ื’ืขื•ื•ืขืŸ ืคึฟื•ืŸ 25.06.2019 ื™ื•ื ื™ 9.07.2019 ืฆื• 10.4.6 ื™ื•ืœื™ XNUMX) ืื•ืŸ ื“ืขืจ ืจืขื–ื•ืœื˜ืึทื˜ ืื™ื– ื’ืขื•ื•ืขืŸ ื“ืขืจ ืึธื ื–ืึธื’ "ื“ืขืจ ืคึผืจืึธื‘ืœืขื ืื™ื– ื ื™ืฉื˜ ืฉื™ื™ึทื›ื•ืช ืฆื• ื“ื™ ืึธืคึผืขืจืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹ื“ื™ Bitrix CMS, ืึธื‘ืขืจ ืื™ื– ืฉื™ื™ืš ืฆื• ื“ื™ ืึธืคึผืขืจืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื–ื™ืš ืื™ืŸ mariadb XNUMX ืื•ืŸ, ืœื™ื™ื“ืขืจ, ืžื™ื˜ ืื•ื™ืฃ ื“ื™ ืคึผืœืึทืฅ ื–ื™ื™ึทื˜, ืขืก ืื™ื– ืงื™ื™ืŸ ื•ื•ืขื’ ืฆื• ืกืึธืœื•ื•ืข ื“ืขื ืคึผืจืึธื‘ืœืขื; ืื™ืจ ื•ื•ืขื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ืฆื• ื“ื™ ืึทืœื˜ ื•ื•ืขืจืกื™ืข ืคื•ืŸ โ€‹โ€‹MariaDB.

ื– ืฒ ื–ืฒื ืข ืŸ ืื ื’ืขืงื•ืžืข ืŸ... ื›ืณื”ืื‘ ื’ืขื˜ืจืื›ื˜ ืฐืขื’ืŸ ื“ืขืจื ื™ื“ืขืจื•ื ื’ ื‘ืฒื ืื ื”ืฒื‘ ืคื•ืŸ ื“ืขืจ ืžืขืฉื”, ืื‘ืขืจ ืขืก ื–ืื’ื˜ ืขืก ืื™ืŸ ืฉื•ื•ืึทืจืฅ ืื•ืŸ ื•ื•ื™ื™ึทืกืึทื– ืขืก ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืงื™ื™ืŸ ื“ืึทื•ื ื’ืจื™ื™ื“. ื“ืึทืžืคึผ ื“ืึทืžืคึผืก ืื•ืŸ ืฉื™ื™ึทืขืš-ืฆืขื•ื•ื™ืงืœืขืŸ ืื•ื™ืฃ ืึท ื’ืึธืจ ืื™ื ืกื˜ืึทืœื™ืจืŸ ืกืขืจื•ื•ืขืจ. ื™ืขื ืข. ืขืก ืื™ื– ื’ื•ื˜ ืึทื– ืื™ืš ื”ืื˜ ื ื™ืฉื˜ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืึทืœืข ื“ื™ ืกืขืจื•ื•ืขืจืก ืื™ืŸ ืึทืžืึธืœ. ื™ืขื ืข. "ื ืึธืจ" ืึท ื”ื•ื ื“ืขืจื˜ ื–ื™ื™ื˜ืœืขืš (ื ืขืจื•ื•ืขื– ืœืึทื›ืŸ :-)). ื“ื™ ืฉื˜ื™ืฆืŸ ื”ืึธื˜ ืื•ื™ืš ื’ืขื–ืึธื’ื˜: "ืฆื• ืกืึธืœื•ื•ืข ื“ืขื ืคึผืจืึธื‘ืœืขื ื•ื•ืขืŸ ืื™ืจ ื ื•ืฆืŸ ื“ื™ MariaDB 10.4.6 ื“ืึทื˜ืึทื‘ื™ื™ืก, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืงืึธื ื˜ืึทืงื˜ MariaDB ื˜ืขื›ื ื™ืฉ ืฉื˜ื™ืฆืŸ ืึทื– ื“ื™ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ื•ื•ืขื˜ ื ื™ืฉื˜ ื•ื™ืกืžืขืงืŸ ืึท ืจืขืงืึธืจื“ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื•ื™ื‘ ื“ื™ ื‘ืงืฉื” ืื™ื– ื’ืขืžืื›ื˜:

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

ื”ืึธืคืขื ื•ื ื’ ื’ืœื™ืžืขืจื“ ืคึฟืึทืจ ืึท ืคึผืึธืจ ืคื•ืŸ ืฉืขื” ืคื•ืŸ ื“ืขื ืžืึธืžืขื ื˜ ืื™ืš ืกื˜ืึทืจื˜ืขื“ ืงืึทืžื™ื•ื ืึทืงื™ื™ื˜ื™ื ื’ ืžื™ื˜ MariaDB ืฉื˜ื™ืฆืŸ, ืึธื‘ืขืจ ื“ืึทืŸ ืื™ืš ื‘ืืงื•ืžืขืŸ ืึท ื‘ืจื™ื•ื• ืื™ืŸ ื•ื•ืึธืก ื–ื™ื™ ื”ืึธื‘ืŸ ืžื™ืจ ื’ืขื–ืึธื’ื˜ ื–ื™ื™ืขืจ ืจื™ื›ื˜ื™ืง ืึทื– ืื™ืš ื‘ื™ืŸ ื ื™ืฉื˜ ืึท ื’ืขืฉืขืคื˜ ื‘ืึทื ื™ืฆืขืจ ืื•ืŸ ื“ืขืจื™ื‘ืขืจ ืงื™ื™ืŸ ืื™ื™ื ืขืจ ื•ื•ืขื˜ ืฆื™ืœืŸ ืกืึธืœื•ื•ืข ืžื™ื™ืŸ ืคึผืจืึธื‘ืœืขื, ืึธื‘ืขืจ ืขืก ืื™ื– ืึท ืคืึธืจื•ื ืื•ื™ืฃ ื–ื™ื™ืขืจ ื•ื•ืขื‘ื–ื™ื™ื˜ืœ ืื•ืŸ ื“ืึธืจื˜ ืื™ืจ ืงืขื ืขืŸ ืคึผืจื•ื‘ื™ืจืŸ ืฆื• ืงื•ืงืŸ ืคึฟืึทืจ ืึธืคึผืฆื™ืขืก ... ืื™ืš ื•ื•ืขืœ ื ื™ืฉื˜ ื ื•ื“ื ืข ืื™ืจ ืžื™ื˜ ื“ืขื˜ืึทื™ืœืก. ืขืก ื–ืขื ืขืŸ ืงื™ื™ืŸ ืึธืคึผืฆื™ืขืก ื“ืึธืจื˜.
ื•ื•ืขื’ืŸ! ืžื™ืจ ื’ืขืงื•ื™ืคื˜ ืึทืŸ ISP ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ!
- ื”ืขืœื, ืฉื˜ื™ืฆืŸ? ื’ื•ื™ืก, ื”ื™ืœืฃ!
- ืื ื˜ืฉื•ืœื“ื™ื’ื˜, ืžื™ืจ ืฉื˜ื™ืฆืŸ ื ื™ืฉื˜ ืกืงื•ืžื‘ืึทื’ืก ื•ื•ืึธืก ื˜ื•ื™ืฉืŸ ื’ืขื‘ื•ื™ืจืŸ ื•ื•ืขืจืกื™ืขืก ืคื•ืŸ ื“ื™ DBMS. ืื•ื™ื‘ ืื™ืจ ื•ื•ื™ืœื˜, ืขืก ืื™ื– ืึทืŸ ืึธืคึผืฆื™ืข ืžื™ื˜ ืึทืŸ ืึธืœื˜ืขืจื ืึทื˜ื™ื•ื• ืกืขืจื•ื•ืขืจ ืื™ืŸ ื“ืึธืงืงืขืจ.
โ€” ืื‘ืขืจ ื•ื•ื™ ื•ื•ืขืœืŸ ื‘ืื ื•ืฆืขืจ ืื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก ืงื•ืžืขืŸ ืื”ื™ืŸ? ืฆื• ื“ืึธืงืงืขืจ?
โ€” ื ื•, ืฉืœืขืคืกื˜ื• ื–ืฒ ืื”ื™ืŸ ืžื™ื˜ ื“ื™ ื”ืขื ื˜...
โ€” ื™ื ! ืื•ืŸ ื˜ืึธืŸ ื ื™ื˜ ืคืึทืจื’ืขืกืŸ ืึทื– ื“ื™ ืคึผืึธืจื˜ ืคึฟืึทืจ mysql ื•ื•ืขื˜ ื˜ื•ื™ืฉืŸ ืื•ืŸ ืื™ืจ ื•ื•ืขื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื’ื™ื™ืŸ ื“ื•ืจืš ืึทืœืข ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทื ื– ืื•ืŸ ืจื™ืจื™ื™ื˜ ื–ื™ื™.
- ืึธื•ืงื™ื™, ื“ืึทื ืงืขืŸ, ืื™ืš ื•ื•ืขื˜ ื˜ืจืึทื›ื˜ืŸ ื•ื•ืขื’ืŸ ืื™ื ...
ืื™ืš ื’ืขื“ืึทื ืง ื•ื•ืขื’ืŸ ืื™ื ืื•ืŸ ื‘ืึทืฉืœืึธืกืŸ ืฆื• ืžืึทื ื™ื•ืึทืœื™ ื“ื™ืžืึทืœื™ืฉ 10.4 ืื•ืŸ ื™ื ืกื˜ืึทืœื™ืจืŸ 10.2 ืžื™ื˜ ื•ื•ืึธืก ืขืก ื–ืขื ืขืŸ ืงื™ื™ืŸ ืคืจืื‘ืœืขืžืขืŸ ืื•ื™ืฃ ืื ื“ืขืจืข ืกืขืจื•ื•ืขืจืก.

ื“ืขืจ ืคึผืจืึธืฆืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ื ื™ื˜ ืคื™ืœ ืึทื ื“ืขืจืฉ ืคื•ืŸ ื“ื™ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืคึผืจืึธืฆืขืก. ืื™ืš ื ืึธืจ ื”ืึธื‘ืŸ ืฆื• ื˜ื•ื™ืฉืŸ 10.4 ืฆื• 10.2 ืื™ืŸ ื“ื™ ืœื™ื ืง ืฆื• ื“ื™ ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™, ื‘ืึทืฉื˜ืขื˜ื™ืง ืื•ืŸ ืฉื™ื™ึทืขืš-ืฉืึทืคึฟืŸ ื“ื™ ืงืึทืฉ ืคึฟืึทืจ ื™ื•ื. ื ื•, ื ืึธืš ืึท "ืงืœื™ื™ืŸ ื–ืึทืš": ื ืึธืš ืจื™ืžื•ื•ื•ื™ื ื’ 10.4, ื’ื™ื™ืŸ ืฆื• /var/lib/mysql ืื•ืŸ ื•ื™ืกืžืขืงืŸ ืึทืœืฅ ืคึฟื•ืŸ ื“ืึธืจื˜. ืึธืŸ ื“ืขื ืฉืจื™ื˜ ื ืึธืš ื™ื ืกื˜ืึธืœื™ื ื’ 10.2, ื“ื™ ื“ื™ื ืกื˜ ื•ื•ืขื˜ ืงืขืกื™ื™ื“ืขืจ ืงืจืึทืš ืื•ืŸ ืื™ืจ ื•ื•ืขื˜ ื–ืขืŸ

ะะต ัƒะดะฐะปะพััŒ ะฟะพะดะบะปัŽั‡ะธั‚ัŒัั ะบ ะฑะฐะทะต ะดะฐะฝะฝั‹ั… '' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"

ืึธื“ืขืจ

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

ืื™ื™ื“ืขืจ ื™ืžืคึผืึธืจื˜ื™ื ื’ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ืื™ืš ืขืจืฉื˜ืขืจ ืฉื˜ืขืœืŸ ื“ื™ ื•ื•ืึธืจืฆืœ ืคึผืึทืจืึธืœ ืคึฟืึทืจ mysql ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ISP ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทื ื– ืื•ืŸ ื™ืžืคึผืึธืจื˜ื™ื“ ื“ื™ mysql ื“ืึทื˜ืึทื‘ื™ื™ืก ื“ืึทืžืคึผ. ื ื•, ื–ื™ื ื˜ ืžื™ืจ ืฉื•ื™ืŸ ื”ืึธื‘ืŸ ื™ื•ื–ืขืจื– ืื•ืŸ ืจืขื›ื˜, ืžื™ืจ ืคืฉื•ื˜ ืึทืจื™ื™ึทื ืคื™ืจ ืึทืœืข ื“ื™ ื‘ืึทื ื™ืฆืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืื™ืŸ ืึท ืจื•ื“ืขืจืŸ ืžื™ื˜ ื“ื™ ื•ื•ืึธืจืฆืœ ื—ืฉื‘ื•ืŸ.

ืฉืจื™ืคื˜ ื˜ืขืงืกื˜ ืคึฟืึทืจ ื“ื™ื™ื˜ืึทื‘ื™ื™ืก ื“ืึทืžืคึผ:

#!/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'

ืื™ื™ื“ืขืจ ื™ืžืคึผืึธืจื˜ื™ื ื’ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืึทื ื–ื™ืคึผ ื–ื™ื™. ืึทื–ื•ื™ ืžื™ืจ ื ืึธืจ ืœื•ื™ืคืŸ ื“ื™ ื‘ืึทืคึฟืขืœ

gunzip /BACK/*.gz

ืื•ืŸ ืœืขืกืึธืฃ: ืคึฟืึทืจ ืขื˜ืœืขื›ืข ืกื™ื‘ื”, ื‘ื™ืคืขื ืก ื–ืขื ืขืŸ ืขืจืœื•ื™ื‘ื˜ ืื™ืŸ ื“ื™ ื ืึธืžืขืŸ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก (ืื•ื™ื‘ ืื™ืจ ืžืึทื›ืŸ ืขืก ื“ื•ืจืš ISPmanager). ืึธื‘ืขืจ ื•ื•ืขืŸ ืื™ืจ ืฉืึทืคึฟืŸ ืึธื“ืขืจ ืคึผืจื•ื‘ื™ืจืŸ ืฆื• ืฆื•ืคึฟืขืœื™ืงืขืจ ืึท ื“ืึทืžืคึผ ืฆื• ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ืึธืก ื”ืื˜ ืึท ื”ื™ืคืขืŸ ืื™ืŸ ื–ื™ื™ืŸ ื ืึธืžืขืŸ, ืื™ืจ ื‘ืึทืงื•ืžืขืŸ ืึท ืึธื ื–ืึธื’ ืึทื– ื“ื™ ื‘ืขื˜ืŸ ืกื™ื ื˜ืึทืงืก ืื™ื– ืคืึทืœืฉ.

ืึทืœืข ื“ื™ ื‘ืขืกื˜ืขืจ ืฆื• ื“ื™ ื•ื•ืืก ืœื™ื™ืขื ืขืŸ ืฆื• ื“ื™ ืกื•ืฃ. ืื™ืš ืึทื ื˜ืฉื•ืœื“ื™ืงืŸ ืคึฟืึทืจ ื“ื™ ืžืขืจืกื˜ ืžืกืชึผืžื ืžื™ืกืคึผืœื™ื™ืกื˜ ืงืึธืžืžืึทืก - ื–ื™ื™ ื–ืขื ืขืŸ ืึท ืคึผืจืึธื‘ืœืขื. ืื•ื™ื‘ ืื™ืจ ื”ืึธื˜ ืงื™ื™ืŸ ืคึฟื™ืจืœื™ื™ื’ืŸ ื•ื•ืขื’ืŸ ื“ื™ ืขืกืึทื ืก ืคื•ืŸ ื•ื•ืึธืก ืื™ื– ื“ื™ืกืงืจื™ื™ื‘ื“, ืฉืจื™ื™ึทื‘ืŸ ืื™ืŸ ืึท ืคืขืจื–ืขื ืœืขื›ืข ืึธื ื–ืึธื’ ื•ื•ื™ื™ึทืœ ืื™ืš ื‘ื™ืŸ ื“ืขืจืฉืจืึธืงืŸ ืื™ืš ื•ื•ืขื˜ ืคืึทืจืคื™ืจืŸ ืขืคึผืขืก ืื™ืŸ ื“ื™ ื‘ืึทืžืขืจืงื•ื ื’ืขืŸ. ืื•ืŸ ื˜ืึธืŸ ื ื™ื˜ ืฉื•ื•ืขืจืŸ ืฆื• ืคื™ืœ - ื“ืึธืก ืื™ื– ืžื™ื™ืŸ ืขืจืฉื˜ืขืจ ืึทืจื˜ื™ืงืœ :)

UPD1:

ืื™ืš ื›ึผืžืขื˜ ืคืืจื’ืขืกืŸ ืฆื• ื“ืขืจืžืึธื ืขืŸ: ื‘ืฉืขืช ืื™ืš ืื™ื– ื’ืขื•ื•ืขืŸ ื˜ืจื™ื™ื ื’ ืฆื• ื’ืขืคึฟื™ื ืขืŸ ืึท ืœื™ื™ื–ื•ื ื’ ืฆื• ื“ืขื ืคึผืจืึธื‘ืœืขื ืึธืŸ ื“ืึทื•ื ื’ืจื™ื™ื“ MariaDB, ืื™ืš ื’ืขื”ืื˜ ืฆื• ืขืคืขืก ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ื“ื™ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข. ืขืก ืื™ื– ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื˜ ื•ื•ื™ ื“ืึธืก: ื“ื™ ื’ืื ืฆืข ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ืงืึธื ื•ื•ืขืจื˜ืขื“ ืคึฟื•ืŸ InnoDB ืฆื• MyISAM, ื“ื™ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืื™ื– ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื˜ ืื•ืŸ ื“ืขืจื ืึธืš ืงืึธื ื•ื•ืขืจื˜ืขื“ ืฆื•ืจื™ืง ืฆื• InoodB.
UPD2:

ืื™ืš ืคึผื•ื ืงื˜ ื‘ืืงื•ืžืขืŸ ืึท ื‘ืจื™ื•ื• ืคื•ืŸ 1C-Bitrix ืžื™ื˜ ื“ื™ ืคืืœื’ืขื ื“ืข ืื™ื ื”ืึทืœื˜:

ื‘ืขื˜ืŸ ืคึฟืึทืจ ืจืขื•ื•ื™ื–ื™ืข ื’ืขืขื ื“ื™ืงื˜
"ื ืึธืš ืึทืคึผื’ืจื™ื™ื“ื™ื ื’ mariadb ืฆื• 10.4.6, ืึท ื˜ืขื•ืช ืคืืจื’ืขืงื•ืžืขืŸ ื•ื•ืขืŸ ืฉืคึผืึธืจืŸ ืึทืŸ ื™ื ืคืึธื‘ืœืึทืง ืขืœืขืžืขื ื˜"
ืžืึธื“ื•ืœืข: iblock, ื•ื•ืขืจืกื™ืข: ืื•ืžื‘ืึทืงืึทื ื˜
ืœื™ื™ื–ื•ื ื’: ืคืืจื•ื•ืืจืคืŸ

ืึทื–ื•ื™ ืขืก ืื™ื– ืžืฉืžืขื•ืช ืื•ืžืžืขื’ืœืขืš ืฆื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืฆื• 10.4 ืคึฟืึทืจ ืื™ืฆื˜ ๐Ÿ™

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’