Iingcebiso eziluncedo zokuJonga iNgxaki yeempazamo eziqhelekileyo kwiMySQL
I-MySQL yinkqubo yolawulo lwesiseko sedatha evulekileyo esetyenziswa ngokubanzi (i-RDMS) ephethwe yi-Oracle. Sekudlule iminyaka ibe lukhetho olungagqibekanga lwezicelo ezisekelwe kwiwebhu kwaye isahlala idumile xa kuthelekiswa nezinye iinjini zedatha.
I-MySQL yenzelwe kwaye ilungiselelwe usetyenziso lwewebhu - yenza inxalenye ebalulekileyo yezicelo ezisekelwe kwiwebhu ezifana ne-Facebook, Twitter, Wikipedia, YouTube, kunye nabanye abaninzi.
Ngaba indawo yakho okanye isicelo sewebhu sinikwe amandla yiMySQL? Kweli nqaku lineenkcukacha, siya kuchaza indlela yokusombulula iingxaki k
Funda ngokugqithisileyo →Uliseta kwakhona njani igama eliyimfihlo lengcambu kwiMySQL 8.0
Kwisiganeko esingathandekiyo sokulibala okanye ukulahlekelwa igama eliyimfihlo le-MySQL yakho, ngokuqinisekileyo uya kufuna indlela yokuyibuyisela ngandlela thile. Into ekufuneka siyazi kukuba igama eliyimfihlo ligcinwe kwitafile yabasebenzisi. Oku kuthetha ukuba kufuneka sifumane indlela yokudlula ukuqinisekiswa kwe-MySQL, ngoko sinokuhlaziya irekhodi lephasiwedi.
Ngethamsanqa kukho kulula ukuyifumana kwaye esi sifundo siya kukukhokela kwinkqubo yokubuyisela okanye ukuseta kwakhona igama eligqithisiweyo lengcambu kwi-MySQL 8.0 version.
Njengokubhaliweyo kweMySQL kukho iindlela
Funda ngokugqithisileyo →Uyifaka njani i-Nginx, i-MySQL/MariaDB kunye ne-PHP kwi-RHEL 8
Uninzi lwabafundi beTecMint bayazi malunga neLAMP, kodwa abantu abancinci bayazi nge-LEMP stack, ethatha indawo ye-Apache web server kunye nobunzima bokukhanya kweNginx. Umncedisi wewebhu ngamnye uneenzuzo kunye neengxaki kwaye kuxhomekeke kwimeko yakho ethile onokukhetha ukuyisebenzisa.
Kule tutorial, siza kukubonisa indlela yokufaka i-LEMP stack - Linux, Nginx, MySQL/MariaDB, PHP kwi-RHEL 8 inkqubo.
Qaphela: Esi sifundo sicingela ukuba unobhaliso olusebenzayo lwe-RHEL 8 kwaye unofikelelo lweengcambu kwinkqubo yakho ye-RHEL.
Inyathelo 1: Faka i-Nginx Web Server
1.
Funda ngokugqithisileyo →Uzigqithisela njani zonke iiDatha zeMySQL ukusuka kuNdala ukuya kwiSeva eNtsha
Ukudlulisa okanye ukuhambisa i-database ye-MySQL/MariaDB phakathi kweeseva ngokuqhelekileyo kuthatha amanyathelo ambalwa kuphela, kodwa ukuhanjiswa kwedatha kunokuthatha ixesha ngokuxhomekeke kumthamo wedatha ongathanda ukuyidlulisela.
Kule nqaku, uya kufunda indlela yokudlulisa okanye ukufuduka zonke iinkcukacha zakho ze-MySQL/MariaDB kwi-server endala ye-Linux kwi-server entsha, ungenise ngempumelelo kwaye uqinisekise ukuba idatha ikhona.
- Qinisekisa ukuba unenguqulelo efanayo ye-MySQL efakwe kuzo zombini iiseva ngonikezelo olufanayo.
- Qinisekisa ukuba unesithu Funda ngokugqithisileyo →
Uyifaka njani i-MySQL 8.0 kwi-RHEL/CentOS 8/7 kunye ne-Fedora 35
I-MySQL yinkqubo evulekileyo yolawulo lwesiseko sedatha yobudlelwane (RDBMS) ekhutshwe phantsi kwe-GNU (iLayisensi yoLuntu ngokubanzi). Isetyenziselwa ukuqhuba oovimba beenkcukacha ezininzi nakuwuphi na umncedisi omnye ngokubonelela ukufikelela kwabasebenzisi abaninzi kwisiseko sedatha ngasinye esidaliweyo.
Eli nqaku liza kuhamba kuwe inkqubo yokufaka kunye nokuhlaziya inguqulo yakamuva ye-MySQL 8.0 kwi-RHEL/CentOS 8/7/6/ kunye ne-Fedora usebenzisa i-MySQL Yum yokugcina nge-YUM utility.
Inyathelo 1: Ukongeza iMySQL Yum Repository
1. Siza kusebenzisa i-software ye-MySQL Y
Funda ngokugqithisileyo →Ubekwa esweni njani iMySQL/MariaDB Database usebenzisa iNetdata kwiCentOS 7
I-Netdata ngumthombo ovulekileyo wasimahla, olula kwaye unobungozi, ukusebenza kwenkqubo yexesha lokwenyani kunye nesicelo sokubekwa kweliso kwezempilo kwiinkqubo ezinjenge-Unix ezifana neLinux, iFreeBSD kunye neMacOS. Iqokelela iimetriki ezahlukeneyo kwaye ibonakale, ikuvumela ukuba ubukele imisebenzi kwinkqubo yakho. Ixhasa iiplagi ezahlukeneyo zokujonga imeko yenkqubo yangoku, usetyenziso olusebenzayo, kunye neenkonzo ezinje ngeMySQL/MariaDB iseva yedatabase, kunye nokunye okuninzi.
- Indlela yokubeka iliso kwiNtsebenzo ye-Apache usebenzisa i-Netdata kwi-CentOS 7
- In Funda ngokugqithisileyo →
Uyifaka njani iMySQL 8.0 kwi-Ubuntu 18.04
Umncedisi woluntu we-MySQL ngumthombo ovulekileyo wasimahla, odumileyo kunye nenkqubo yolawulo lwesiseko seqonga. Ixhasa zombini i-SQL kunye ne-NoSQL, kwaye ine-injini yokugcina i-injini yoyilo. Ukongeza, iza neziqhagamshelo zedatha ezininzi kwiilwimi ezahlukeneyo zokucwangcisa, ikuvumela ukuba uphuhlise usetyenziso usebenzisa naziphi na iilwimi ezaziwayo, kunye nezinye izinto ezininzi.
Inamatyala amaninzi okusebenzisa phantsi kokugcinwa kwamaxwebhu, ifu, iinkqubo zokufumaneka okuphezulu, i-IoT (i-Intanethi yezinto), i-hadoop, idatha enkulu, ukugcinwa kwedatha, i-LAMP okanye i-LEMP st
Funda ngokugqithisileyo →I-Mytop-Isixhobo esiluncedo sokuJonga iMySQL/MariaDB eSebenza kwiLinux
I-Mytop ngumthombo ovulekileyo kunye nenkqubo yokubeka iliso yasimahla ye-MySQL kunye ne-MariaDB yogcino lwedatha yabhalwa nguJeremy Zawodny esebenzisa ulwimi lwePerl. Iyafana kakhulu ngenkangeleko kunye nokuziva kwesona sixhobo sidumileyo sokujonga inkqubo yeLinux ebizwa ngokuba phezulu.
Inkqubo ye-Mytop inikezela nge-shell-line shell interface ukujonga ixesha langempela imicu ye-MySQL/MariaDB, imibuzo ngesekhondi, uluhlu lwenkqubo kunye nokusebenza kogcino lwedatha kwaye inika ingcamango yomlawuli wedatha ukuba enze ngcono umncedisi ukuba aphathe umthwalo onzima.
Ngokungagqibe
Funda ngokugqithisileyo →Uyitshintsha njani iPort MySQL/MariaDB ehlala ikho kwiLinux
Kwesi sikhokelo siza kufunda indlela yokutshintsha i-port engagqibekanga ebophelela i-database ye-MySQL/MariaDB kwi-CentOS 7 kunye ne-Debian-based Linux distributions. Izibuko elingagqibekanga elisebenza phantsi kwe-Linux kunye ne-Unix yi-3306/TCP.
Ukuze utshintshe i-port yedatha ye-MySQL/MariaDB engagqibekanga kwi-Linux, vula ifayile yoqwalaselo yeseva ye-MySQL ukuze ihlelwe ngokukhupha lo myalelo ungezantsi.
# vi /etc/my.cnf.d/server.cnf [On CentOS/RHEL] # vi /etc/mysql/mariadb.conf.d/50-server.cnf [On Debian/Ubuntu]Khangela i-stat yomgca iq
Funda ngokugqithisileyo →Ujongwa njani ubungakanani beDatha yeMySQL kwiLinux
Kule nqaku, ndiza kukubonisa indlela yokujonga ubungakanani beenkcukacha ze-MySQL/MariaDB kunye neetafile nge-shell ye-MySQL. Uya kufunda indlela yokumisela ubungakanani bokwenyani befayile yedatha kwidiski kunye nobungakanani bedatha ekhoyo kwisiseko sedatha.
Ngokungagqibekanga i-MySQL/MariaDB igcina yonke idatha kwisixokelelwano sefayile, kwaye ubungakanani bedatha ekhoyo kwiinkcukacha zogcino-lwazi bunokwahluka kubungakanani bokwenene bedatha yeMysql kwidiski esiza kuyibona kamva.
Ukongeza, i-MySQL isebenzisa i-database ye-information_schema yokugcina ulwazi malunga nedatha y
Funda ngokugqithisileyo →