Ukuphindaphinda kwe-MySQL ngemuva kokunqamuka kwe-VPN: qala ngokufunda izigaba zombili
Indlela enqanyuliwe akuzona izinkokhelo ezilahlekile. Funda umamukeli nomsebenzisi ngokwehlukana, bese uhlola ukuthi umthombo usagcina ini.
Ukuqapha ukuphindaphinda kuba bomvu lapho i-VPN iwa, futhi umzwelo wokuqala ukusetha kabusha isikhundla. Yilo mzwelo owenza ukuphazamiseka kwenethiwekhi kube inkinga yedatha. Indlela ewile ayisho lutho mayelana nalokho okwamukelwe noma okusetshenziswe yikhophi, futhi lezo yizigaba ezimbili ezinemimo emibili. Zifunde ngokwehlukana ngaphambi kokushintsha noma yini.
Izigaba ezimbili, izimpendulo ezimbili ezihlukene
Ikhophi evamile engahambisani nesikhathi yenza imisebenzi emibili. Umamukeli uxhuma emthonjeni, udonsa izehlakalo futhi uzibhala endaweni kurejista yokudlulisa. Umsebenzisi ufunda leyo rejista futhi enze izehlakalo kukhophi. Lapho indlela inqamuka, umamukeli uyama ngokushesha kuyilapho umsebenzisi eqhubeka nokusebenza kokusalelile okusekuqaleni kuseyidiskhi. Ngakho ukuphazamiseka okukodwa kukhiqiza imibuzo emibili ehlukene: ingabe uxhumano lubuyile, futhi ingabe umsebenzi oqoqiwe usetshenzisiwe? Ukuzithatha njengombuzo owodwa kusho ukulinganisa imimo emibili ibe yimpendulo edukisayo.
Ukuphulukiswa komamukeli kukutshela ukuthi indlela iyasebenza. Akusho lutho mayelana nokuthi umsebenzisi usalele emuva kangakanani, noma ukuthi wahlangabezana nephutha ngesikhathi exhunyiwe.
Funda isiteshi ngesitatimende esifanele
Ku-MySQL 8.4, i-SHOW REPLICA STATUS ibuyisela umugqa owodwa kusiteshi ngasinye esilungisiwe, ngakho funda umugqa wesiteshi osiqondile hhayi owokuqala ohlwini. I-Replica_IO_Running ihlukanisa umamukeli oxhunyiwe kulo oxhumayo noma omisiwe, futhi i-Replica_SQL_Running ichaza umsebenzisi. Funda namakholomu amaphutha aseceleni, ngoba umamukeli oxhuma futhi ehluleka ngokushesha ushiya umlayezo ongenakuboniswa yiliphi ifulegi lesimo. Izinguqulo ezindala zisebenzisa amanye amagama amakholomu, ngakho ungahumushi iresiphi endala ngokuhumusha amagama emiyalo kuphela.
Hlola futhi ubunikazi bomthombo kanye nanoma yiziphi izihlungi ezilungisiwe. Ikhophi eqondise emthonjeni ongafanele, noma ehlungiwe ngokuncane kunalokho ocabanga, ibika impilo ngesikhathi iphindaphinda into ehlukile kunalokho okulindele.
Kungani inombolo yokubambezeleka enguziro ingaqamba amanga
Inani lokubambezeleka liqhathanisa isigxivizo sesikhathi somcimbi wokugcina osetshenzisiwe nesikhathi samanje. Lapho umamukeli umile ihora, umsebenzisi angase aqede okusalelile futhi afinyelele ekupheleni kwalokho akutholile, bese leyo nombolo yehla yaba uziro nakuba ikhophi isemuva ngehora emthonjeni. Isilinganiso silinganisa umugqa womsebenzisi, hhayi ubusha bekhophi.
Esikhundleni salokho qhathanisa izinkokhelo ezenziwe nalokho umthombo onakho. Lokho kuqhathanisa kuyaphila ngisho nomamukeli omile.
Isikhathi sokugcina sibeka iwindi langempela lokululama
Ukuze ufinyelele, umthombo kufanele usagcine izinkokhelo ezidingwa yikhophi. Uma sezikhutshiwe, ikhophi ayikwazi ukuzithola, futhi noma ngabe uxhuma kangaki akukushintshi lokho.
Ngokubeka kwendawo kwe-GTID okuzenzakalelayo, ukwehluleka kucacile: ikhophi icela umlando umthombo ongasawoqcinisi futhi iyala ukuqhubeka. Izinketho khona-ke ukuthola izehlakalo ezingekho emthonjeni osanazo, noma ukwakha kabusha kusuka kusipele futhi uyeke ifinyelele. Ukweqa igebe akukona ukufinyelela, futhi kushiya ikhophi edatha yayo ingaphelele ngokuthule. Hlela iwindi ngokuqhathanisa isikhathi esilindelekile sokuphazamiseka nokugcinwa kwerejista kanambambili emthonjeni kanye nezinga lokushintsha, ngoba lezo zinombolo ezintathu zinquma ukuthi ukuphazamiseka kungalulameka nhlobo yini.
Qinisekisa ukufinyelela, hhayi umbala wesikhombisi
Buyisela indlela, kuhlanganise nokuxazululwa kwamagama nokuphepha kokuthutha, bese ubheka ukuthi isiteshi esikhona siyaxhuma futhi ngokwenqubomgomo yaso. Sinike isikhathi esithile ngaphambi kokungenelela, futhi urekhode intuthuko yokwamukela nokusebenzisa kuzo zombili iziphetho zaleso sikhathi. Isiteshi esiqala kabusha nesiteshi esisheshayo izitholakele ezihlukene.
Qinisekisa ukuthi umsebenzisi ufinyelele isikhundla samanje somthombo, hhayi kuphela ukuphela kokusalelile kwakudala. Hlola ukuthi akukho phutha elilindile kumsebenzisi, ngoba umcimbi owodwa ohlulekile umisa intuthuko kuyilapho umamukeli eqhubeka nokubika uxhumano. Bese urekhoda ubufakazi: igama lesiteshi, izimo zezigaba zombili, isikhundla esenziwe kanye nesikhathi. Isikhombisi esiluhlaza isimangalo; isikhundla iqiniso.