I-MySQL iyisistimu yokuphathwa kwedatha evulekile yomthombo ovulekile (i-RDMS) ephethwe yi-Oracle. Sekuyiminyaka eminingi kube ukukhetha okuzenzakalelayo kwezinhlelo zokusebenza ezisekelwe kuwebhu futhi kusalokhu kudumile uma kuqhathaniswa nezinye izinjini zesizindalwazi.
I-MySQL yakhelwe futhi yalungiselelwa izinhlelo zokusebenza zewebhu - yakha ingxenye ebalulekile yezinhlelo zokusebenza ezisekelwe kuwebhu ezifana ne-Facebook, Twitter, Wikipedia, YouTube, nezinye eziningi.
Ingabe isayithi lakho noma uhlelo lwewebhu luxhaswe yi-MySQL? Kulesi sihloko esinemininingwane, sizochaza
Funda kabanzi →Esimweni esingesihle sokukhohlwa noma ukulahlekelwa iphasiwedi yakho yempande ye-MySQL, ngokuqinisekile uzodinga indlela yokuyibuyisela ngandlela thile. Okufanele sikwazi ukuthi iphasiwedi igcinwa kuthebula labasebenzisi. Lokhu kusho ukuthi sidinga ukuthola indlela yokudlula ukuqinisekiswa kwe-MySQL, ukuze sikwazi ukubuyekeza irekhodi lephasiwedi.
Ngenhlanhla kukhona okulula ukukufeza futhi lesi sifundo sizokuqondisa ohlelweni lokubuyisela noma ukusetha kabusha iphasiwedi yezimpande kunguqulo ye-MySQL 8.0.
Njengokubhaliwe kwe-MySQL kunezindlela ezimbili zokusetha kabusha iphasiw
Funda kabanzi →Abafundi abaningi be-TecMint bayazi nge-LAMP, kodwa bancane abantu abayaziyo isitaki se-LEMP, esithatha indawo yeseva yewebhu ye-Apache ngesisindo esilula se-Nginx. Iseva yewebhu ngayinye inobuhle nobubi bayo futhi kuya ngesimo sakho esithile ongakhetha ukusisebenzisa.
Kulesi sifundo, sizokukhombisa ukuthi usifaka kanjani isitaki se-LEMP - Linux, Nginx, MySQL/MariaDB, PHP ohlelweni lwe-RHEL 8.
Qaphela: Lesi sifundo sithatha kuqala ukuthi unokubhaliselwe okusebenzayo kwe-RHEL 8 nokuthi unokufinyelela okuyizimpande kusistimu yakho ye-RHEL.
Ukudlulisa noma Ukuthutha isizindalwazi se-MySQL/MariaDB phakathi kwamaseva ngokuvamile kuthatha izinyathelo ezimbalwa kuphela ezilula, kodwa ukudluliswa kwedatha kungathatha isikhathi kuye ngevolumu yedatha ongathanda ukuyidlulisela.
Kulesi sihloko, uzofunda indlela yokudlulisa noma ukuthutha yonke imininingwane yakho ye-MySQL/MariaDB kusuka kuseva ye-Linux endala kuya kuseva entsha, uyingenise ngempumelelo futhi uqinisekise ukuthi idatha ikhona.
I-MySQL iwumthombo ovulekile wohlelo lokuphatha isizindalwazi esihlobene (RDBMS) olukhishwe ngaphansi kwe-GNU (General Public License). Isetshenziselwa ukusebenzisa imininingwane eminingi kunoma iyiphi iseva eyodwa ngokunikeza ukufinyelela kwabasebenzisi abaningi kusizindalwazi ngasinye esidaliwe.
Lesi sihloko sizokuhamba ngenqubo yokufaka nokubuyekeza inguqulo yakamuva ye-MySQL 8.0 ku-RHEL/CentOS 8/7/6/ kanye ne-Fedora isebenzisa inqolobane ye-MySQL Yum nge-YUM utility.
1. Sizosebenzisa inqolobane esemthethweni yesofthiwe
Funda kabanzi →I-Netdata iwumthombo wamahhala ovulekile, olula futhi ongalawuleki, ukusebenza kohlelo lwesikhathi sangempela kanye nesicelo sokuqapha impilo sezinhlelo ezifana ne-Unix ezifana neLinux, FreeBSD neMacOS. Iqoqa amamethrikhi ahlukahlukene futhi iwabone ngeso lengqondo, okukuvumela ukuthi ubuke ukusebenza kusistimu yakho. Isekela ama-plugin ahlukahlukene okuqapha isimo samanje sesistimu, izinhlelo zokusebenza ezisebenzayo, nezinsizakalo ezifana neseva yedatha ye-MySQL/MariaDB, nokunye okuningi.
Iseva yomphakathi ye-MySQL iwumthombo ovulekile wamahhala, uhlelo oludumile noluphambanayo lwesizindalwazi solwazi. Isekela kokubili i-SQL ne-NoSQL, futhi inokwakheka kwenjini yokugcina okuxhumekayo. Ukwengeza, futhi iza nezixhumi eziningi zesizindalwazi sezilimi ezihlukene zokuhlela, ezikuvumela ukuthi uthuthukise izinhlelo zokusebenza usebenzisa noma yiziphi izilimi ezaziwayo, nezinye izici eziningi.
Inamacala amaningi okusebenzisa ngaphansi kwesitoreji semibhalo, ifu, izinhlelo zokutholakala okuphezulu, i-IoT (I-inthanethi Yezinto), i-hadoop, idatha enkulu, ukugcinwa kwedatha, isit
Funda kabanzi →I-Mytop iwumthombo ovulekile kanye nohlelo lokuqapha lwamahhala lwedathabheyisi ye-MySQL kanye ne-MariaDB yabhalwa u-Jeremy Zawodny esebenzisa ulimi lwe-Perl. Ifana kakhulu ngokubukeka nokuzwakala kwethuluzi elidume kakhulu lokuqapha uhlelo lwe-Linux elibizwa nge-top.
Uhlelo lwe-Mytop lunikeza isixhumi esibonakalayo segobolondo somugqa womyalo ukuze kuqashwe imicu yesikhathi sangempela ye-MySQL/MariaDB, imibuzo ngomzuzwana, uhlu lwezinqubo nokusebenza kolwazi olugciniwe futhi lunikeza umbono kumphathi wesizindalwazi ukuze alungiselele kangcono iseva ukuze isingathe umthwalo osindayo.
Funda kabanzi →Kulo mhlahlandlela sizofunda ukuthi singashintsha kanjani imbobo ezenzakalelayo eboshelwa isizindalwazi se-MySQL/MariaDB ku-CentOS 7 kanye nokusabalalisa kwe-Linux okusekelwe ku-Debian. Imbobo ezenzakalelayo iseva yedatha ye-MySQL esebenza ngaphansi kwe-Linux futhi i-Unix ingu-3306/TCP.
Ukuze uguqule imbobo yedatha ye-MySQL/MariaDB ezenzakalelayo ku-Linux, vula ifayela lokumisa leseva ye-MySQL ukuze lihlelwe ngokukhipha umyalo ongezansi.
# vi /etc/my.cnf.d/server.cnf [On CentOS/RHEL] # vi /etc/mysql/mariadb.conf.d/50-server.cnf [On Debian/Ubuntu] Funda kabanzi →Kulesi sihloko, ngizokukhombisa ukuthi ungabheka kanjani usayizi wedathabhethi ye-MySQL/MariaDB namatafula ngegobolondo le-MySQL. Uzofunda ukuthi unganquma kanjani usayizi wangempela wefayela lesizindalwazi kudiski kanye nosayizi wedatha eliwethulayo kusizindalwazi.
Ngokuzenzakalelayo i-MySQL/MariaDB igcina yonke idatha ohlelweni lwamafayela, futhi usayizi wedatha ekhona kuzinqolobane ingase ihluke kusayizi wangempela wedatha ye-Mysql kudiski esizoyibona kamuva.
Ngaphezu kwalokho, i-MySQL isebenzisa isizindalwazi esibonakalayo se-information_schema ukuze igcine ulwazi olumayelan
Funda kabanzi →