Kalozera wa Nkhani
Dziko la ma database silimaima; lili ngati nkhondo yopanda ufa wa mfuti, komwe kulimbana pakati pa magwiridwe antchito ndi kukhazikika kumachitika tsiku lililonse.
Mu HestiaCP , MariaDB imagwiritsa ntchito InnoDB ngati injini yosungiramo zinthu mwachisawawa.
Komabe, m'zochitika zina, monga matebulo ofotokoza zolemba ndi mapulogalamu owerenga kwambiri, MyISAM nthawi zambiri imapereka liwiro la mafunso mwachangu komanso njira yosungira yopepuka.
Nkhaniyi ikuwonetsani momwe mungasinthire injini yosungira ya MariaDB kukhala MyISAM m'malo a HestiaCP, ndikukupatsani kumvetsetsa bwino zoopsa ndi zabwino zomwe zimabwera.
🔍 N’chifukwa chiyani muyenera kusintha kukhala MyISAM?
Ubwino wa MyISAM uli mu kupepuka kwake komanso liwiro lake.
Mu zochitika zowerenga zokha kapena zowerenga zambiri/zosavuta kulemba, magwiridwe antchito ake a mafunso nthawi zambiri amakhala othamanga kuposa InnoDB.
Malinga ndi zolemba zovomerezeka za MariaDB, "MyISAM imagwira ntchito bwino kwambiri m'mapulogalamu osagwiritsa ntchito ndalama, ndipo ndi yoyenera kwambiri pamatebulo a log ndi cache." (Chitsime: MariaDB Knowledge Base)
Kuphatikiza apo, kapangidwe ka mafayilo a tebulo la MyISAM ndi kosavuta, ndipo kusamutsa ndi kusunga zinthu zakale n'kosavuta kwambiri.
Komabe, zovuta zake ndizodziwikiratu: sizithandiza malonda ndi makiyi akunja, ndipo chitetezo chake cha deta sichili bwino ngati InnoDB.
Izi zikutanthauza kuti ngati mugwiritsa ntchito MyISAM patsamba la e-commerce kapena mu dongosolo lazachuma, mutha kukumana ndi mavuto akulu okhudzana ndi kusasinthasintha kwa deta chifukwa chosowa chithandizo cha malonda.
Chifukwa chake, ngati kusintha ku MyISAM kuyenera kutsimikiziridwa kutengera momwe pulogalamuyo ikuyendera.
🛠️ Njira zosinthira
Tsegulani fayilo yosinthira
Mu HestiaCP environment, fayilo yayikulu yosinthira ya MariaDB ili pa:
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
Ngati mwazolowera kwambiri kusintha /etc/mysql/my.cnf N'zothekanso, koma nthawi zambiri zimalimbikitsidwa kuti... 50-server.cnf Ligai.
Mwa [mysqld] Kapena[mariadbd]Onjezani magawo ku ndime
onekera [mysqld]Kapena[mariadbd]Onjezani zotsatirazi ku ndime:
[mariadbd]
[mysqld]
default-storage-engine=MyISAM
Ngati muli kale ndi magawo ena, ingowonjezerani mzerewu pansipa.
Sungani ndi kutuluka, kenako yambani MariaDB.
Ikani lamulo lotsatira kuti mugwiritse ntchito kasinthidwe:
sudo systemctl restart mariadb
Tsimikizani ngati ikugwira ntchito
Lowani ku MariaDB:
mysql -u root -p
zidachitidwa:
SHOW VARIABLES LIKE 'default_storage_engine';
Zotsatira zake ziyenera kukhala:
+------------------------+--------+
| Variable_name | Value |
+------------------------+--------+
| default_storage_engine | MyISAM |
+------------------------+--------+
Izi zikutanthauza kuti kusinthaku kwachitika bwino.
⚠️ Njira zodzitetezera
Musanayambe kugwiritsa ntchito MyISAM mosangalala, pali mfundo zingapo zofunika kuzikumbukira.
- Zoopsa zogwirizanaMapulogalamu omangidwa mkati mwa HestiaCP (monga...) WordPressGawo la makalata la Roundcube limadalira zochitika za InnoDB ndi makiyi akunja. Kukakamiza kusinthana ku MyISAM kungayambitse mavuto.
- Njira yolangizidwaTchulani kokha pamene mukupanga tebulo.
ENGINE=MyISAMM'malo mosintha mtengo wokhazikika padziko lonse lapansi, mutha kuchita izi kuti mupewe kusokoneza magwiridwe antchito anthawi zonse a mapulogalamu omwe alipo. - Chitetezo chosungiraMusanasinthe chilichonse, onetsetsani kuti mwasunga zosungira mafayilo osinthira ndi database kuti mupewe kuwonongeka kosatha.
Monga tafotokozera mu "Database Systems: The Complete Book," "Kusankha injini yosungiramo zinthu ndi kusinthana; magwiridwe antchito ndi kudalirika sizimakulitsidwa nthawi imodzi." (Chitsime: Garcia-Molina, Ullman, Widom, 2008)
🚀 Chidule ndi Malingaliro
Mu HestiaCP, kusintha injini yosungiramo zinthu ya MariaDB kukhala MyISAM ndi nkhani chabe... [mysqld] Ingowonjezerani mzere wokonzera pa ndime ndikuyambitsanso ntchitoyo.
Koma iyi si ntchito yaukadaulo chabe; ili ngati funso lanzeru : Kodi mukufuna liwiro kapena chitetezo?
Maganizo anga ndi akuti mapulogalamu ambiri amakono amadalira InnoDB, ndipo njira yabwino kwambiri ndikugwiritsa ntchito MyISAM nthawi iliyonse yomwe ikufunika m'malo moisintha padziko lonse lapansi.
Mu matebulo a zolemba, zosungira, ndi ziwerengero, MyISAM ndi lupanga lakuthwa; koma m'mabizinesi omwe amafunikira ndalama zambiri, ikhoza kukhala bomba lowononga nthawi.
Chifukwa chake, ambuye enieni satsatira liwiro mwachimbulimbuli, koma amadziwa momwe angasankhire chida choyenera kwambiri pazochitika zosiyanasiyana.
Ubwino wa ukadaulo sikutanthauza kusonyeza luso, koma kuthetsa mavuto.
Ngati mukuganizira ngati musinthe kukhala MyISAM, dzifunseni kaye kuti: Kodi pulogalamu yanu ikufunika liwiro kapena kukhazikika?
Tikukulimbikitsani kuti muchite mayeso ambiri muzochita zanu ndikusankha ngati mungasinthe kutengera momwe bizinesi yanu ilili.
Ndipotu, dziko la ma database silikunena za zakuda ndi zoyera, koma za zomwe zili zoyenera ndi zomwe sizili zoyenera.
Kusankha injini yoyenera yosungiramo zinthu ndi kusankha tsogolo.
Tikukhulupirira kuti nkhani yakuti "Kodi Mungasinthe Bwanji Injini Yosungira Yokhazikika ya MariaDB kukhala MyISAM mu HestiaCP? Yankho Losavuta la Gawo Limodzi!" yogawidwa pa blog ya Chen Weiliang ( https://www.chenweiliang.com/ ) idzakuthandizani.
Khalani omasuka kugawana ulalo wa nkhaniyi: https://www.chenweiliang.com/cwl-34098.html
