Ukuphindaphinda kwe-MySQL. Ukuhamba okufutshane

Ngokushesha noma ngaphambi, ngaphambi kwanoma imuphi umphathi, kunenkinga uma amandla amaseva akhe akwanele ukwenza imisebenzi ebekiwe, futhi ukuthengwa kwemishini emisha kungeke kwenzeke ngenxa yobunzima bezezimali, noma ukuthengwa okunjalo kuphakamisa ukungabaza ngokubuyiswa kwayo esikhathini esizayo.

Ekukhanyeni kwezenzakalo ezinjalo, akuyona into engafanele ukufunda ngomqondo onjalo njengokuphindaphindiwe kwedatha. Ulwazi olunjalo luzokwenza kube lula kakhulu ukuphila kwanoma yimuphi umuntu ohilelekile ekusebenzeni izinhlelo ezilayishiwe kakhulu futhi uzokwenza ukulungiswa okuhle kwehadiwe lokusebenza. Ngokuvamile, ukuphindaphinda kwedatha kubandakanya ukuhlanganisa amandla weqoqo lamakhompyutha ukuze kuthuthukiswe ukusebenza komsebenzi nokubekezelelana kwephutha. Umphumela wokuqala ungafinyelelwa ngokuphonsa ingxenye yezinsiza kwisiphakeli sokulinda, futhi owesibili ngokwakha ikhophi yendawo yedatha, okuyinto, uma kunesidingo, izothatha isikhundla se-database eyinhloko.

Indlela elula kunazo zonke futhi ejwayelekile yokuhlela ukuphindaphindiwe ukuphindaphinda kwe-MySQL. Futhi i-MySQL isekela le nqubo nge-version 3.23.15 kanye nokuphindaphinda okukodwa. Kulesi simo, ukulungiswa okukhethekile "okuhle-nenceku" kudalwe, lapho inkosi ingase ibe yiseva lesigqila.

Ukuphindaphinda kwe-MySQL okwamanje kusetshenziswe kanje. I-server eyinhloko idalwe, okuyimfanelo yayo ukuqapha izinguquko kwifayili kanambambili, ekhombisa zonke izinguquko ku-database kanye nomshini wezigqila noma imishini efunda futhi ikhiphe imibuzo kusuka kuleli fayela. Iseva lesigqila ihlale ixhunyiwe kumphathi, ngakho konke izinguquko ezenzeka enkosini kuya encekwini, futhi akukho simo sokungafani nokungaqondile kwedatha.

Ukuphindaphinda kwe-MySQL Isungulwe ngezigaba eziningana.

1. Umphathi wesistimu kufanele aqinisekise ukuthi yonke imishini yakhe ine-version yakamuva ye-MySQL efakiwe.
2. Kumele udale umsebenzisi omusha kuseva enkulu, ngaphansi kokuphindaphindiwe kwe-MySQL (kumele kube neveli lelungelo le-FILE kanye nelungelo lokuxhumana nezigqila).
3. Okulandelayo, udinga ukumisa i-MySQL kumaseva wenkosi nezinceku futhi ukopishe yonke idatha ehlobene nokuphindaphinda. Kuzinhlelo ze-Unix, lokhu kungenziwa ngomyalo we-tar, okwenza ingobo yomlando yokulondoloza yerekhodi lonke. I-WinZip ifanele kubasebenzisi be-Windows.
4. Engeza imigqa elandelayo engxenyeni ye-mysqld: iseva-id = inombolo ehlukile, i-log-bin. Zonke izinguquko zenziwe kwifayili ye-My.conf kwi-server enkulu, ngemva kwalokho kumele ilayishwe ngokweqile.
5. Kuzigqila efayeleni elifanayo, udinga ukungeza isitayela sekhodi esilandelayo:

I-master-host =

I-master-user =

I-Master-password =

I-Master-port =

I-server-id =

* Emabhaketheni angunxantathu udinga ukufaka idatha yakho, hhayi umbhalo ongenhla.

Ekugcineni, kopisha yonke imininingwane kumaseva omgqila bese uqala kabusha yonke imishini.

Ngemuva kwezinyathelo ezinjalo, ukuphindaphinda kungacatshangwa kufakwe futhi kulungiselelwe, okusho ukuthi manje iseva yakho eyinhloko ngeke ihlukane nomthwalo ophezulu futhi uma ukwehluleka kwanoma iyiphi ithebula kuyo kungabuyiselwa kalula kusuka kwenye ikhompyutha. Ngenxa yalokho, kungenzeka ukukhohlwa iminyaka eminingana ngokuthenga i- hardware entsha yezinhlelo ezilayishiwe kakhulu futhi ukwaneliswe ngomsebenzi osungulwe wemishini ekhona.