Kungani i-VPN esheshayo isabambezela ukuqinisekiswa kwe-SQL okuhambisanayo

Vula isikhathi sombuzo kusisekelo bese ubheka ukuthi ukubhala okulula kulindeleni. Uma isizindalwazi singeselinye lamaqembu okutholakala anokuqinisekiswa okuhambisanayo futhi eyesibili ixhunyiwe, ingxenye yalokho kulinda iphuma esakhiweni: amarekhodi e-log aya kwikhophi, aqiniswa lapho, futhi izindaba zalokho kuqiniswa zibuya ngaphambi kokuthi ukuqinisekiswa kuphele. Umkhawulo womthamo awukufinyezi lokho kuhamba nokubuya. Ukuhamba okungezansi kulandela isiqinisekiso kusukela kusikrini kuya kudiski ekude nokubuya.

Qala ohlotsheni lokulinda kusisekelo

Ukubhala okulindile kwikhophi ekude kuvela njengokulinda okuhlobene ne-log hhayi njengokulinda kwe-CPU noma kwesikhiya, futhi ubude besikhathi sokwenziwa kulandela ukuhamba nokubuya esikhundleni senani lemigqa. Ukuqinisekiswa okuningi okuncane kwenza lokho kucace, ngoba ngakunye kukhokha uhambo ngokwahlukana. Umsebenzi owodwa omkhulu ufihla leyo ndleko ngaphakathi kwesiqinisekiso eside.

Hlela umthwalo wakho womsebenzi ngokwemvamisa yokuqinisekiswa ngaphambi kokuphetha noma yini mayelana nokuxhumana.

Funda isimo sekhophi ngaphambi kokufunda inethiwekhi. Izibaluli ezibalulekile umugqa wokuthumela, umugqa we-redo kanye nesimo sokuvumelanisa, futhi ngokuhlanganyela zikhombisa ukuthi eyesibili iyahambisana noma isalele emuva. Umugqa wokuthumela okhulayo ukhomba ekuthuthweni, kuyilapho umugqa we-redo okhulayo ukhomba emsebenzini noma esitolo sesibili uqobo. Lokho kuyizilungiso ezihlukene, futhi akukho nokukodwa okuba ngcono ngokwengeza umkhawulo womthamo.

Landela isiqinisekiso kuze kufike kwesesibili

Kuqinisekiswa okuhambisanayo, isisekelo silinda isiqinisekiso sokuthi i-log efanele iqinisiwe kwesesibili ngaphambi kokubika ukuthi ukuqinisekiswa kuphelile. Ukuqiniswa kusho ukuqina ku-log, hhayi ukuphindwa kumakhasi edatha. Yilo mehluko kanye ochaza ukuthi kungani eyesibili ehambisanayo ingasala emuva ku-redo kuyilapho isaqinisekisa ukuqiniswa.

Hamba indlela ngokulandelana futhi ulinganise isigaba ngasinye esikhundleni sakho konke. Amarekhodi e-log adlula ekuthuthweni, eyesibili iyawabhala futhi iwakhulule, futhi isiqinisekiso sibuya ngayo leyo ndlela. Ukubambezeleka kokuthutha, ukuhlela kwesibili kanye nokubambezeleka kwediski le-log lesibili konke kungena enanini, futhi okokuqala kuphela okungokomnikazi wenethiwekhi. Eyesibili umthamo wayo we-log ugcwele ngenye into inganweba ukuqinisekiswa ngakunye ngenkathi ukuxhumana kuhleli.

SELECT ag.name AS ag_name, drs.database_id, drs.synchronization_state_desc,
       drs.log_send_queue_size, drs.redo_queue_size
FROM sys.dm_hadr_database_replica_states AS drs
JOIN sys.availability_groups AS ag ON ag.group_id = drs.group_id;

Thatha leso sithombe ngaphambi nangemva kokubhala okumelele esikhundleni sokuthatha kanye ngemva kwemini ethule. Umehluko yiwona okutshela ukuthi yimuphi umugqa owasuka ngenkathi ukuqinisekiswa kulindile.

Linganisa indlela, hhayi ukuxhumana

Ukuhlolwa komthamo wokuhamba kulinganisa umthamo phakathi kwamaphoyinti amabili okungewona amakhophi akho, ngaphansi komthwalo ongewona umsebenzi wakho. Cela umnikazi wenethiwekhi ukubambezeleka nokulahleka endleleni yangempela yekhophi ngenkathi ukuhamba kwangempela kuqhubeka, kuzo zombili izinhlangothi. Ukulahleka kubaluleke kakhulu kunomthamo lapha, ngoba ingxenye elahlekile idinga ukuthunyelwa kabusha futhi ukuqinisekiswa ngakunye kulinda isiqinisekiso esisodwa. Ukuxhumana okubonakala kukuhle ekuhlolweni kokulanda kungase kungafaneleki iphethini yokuqinisekiswa ekhuluma kakhulu.

Gcina uphephile ukuphepha kokuthutha kwesizindalwazi kanye nezilawuli zokufinyelela ngenkathi ulinganisa. Ukulinganisa indlela akusoze kwaba yisizathu sokuzidlula.

Hlobanisa izikhathi nezibaluli esikhundleni somuzwa. Uma umugqa wokuthumela uhlala ungenalutho futhi ukuqinisekiswa kusalindile, ukubambezeleka kusesiqinisekisweni noma ekukhululeni kwesibili. Uma umugqa wokuthumela ukhula ngokuqhubekayo, umkhawulo ukuthutha noma umthamo. Bhala ukuthi yikuphi ukubheka okusekele isiphetho ukuze umuntu olandelayo aphindise ukulinganisa hhayi impikiswano.

Yini eye yashintshwa yimodi engahambisani

Ukuqinisekiswa okungahambisani kususa ukulinda isiqinisekiso sokuqiniswa sesibili, yingakho ukubhala kushesha futhi yingakho isimo sakho sokuqina sishintsha. Isisekelo siqinisekisa ukwenziwa ngaphandle kwalokho kuqinisekiswa kude. Eyesibili bese ivunyelwa ukusala emuva, futhi lokho kusala emuva yikho ukuchayeka.

Uma isisekelo silahleka ngaphambi kokuthi i-log ifinyelele umgomo wokushintshwa kwephutha osebenzisekayo, ukuphoqa isevisi iye kuleyo khophi kulahla ukwenziwa okwase kwaziswa uhlelo lokusebenza ukuthi kuqinisekisiwe.

Lesi yisinqumo sendawo yokubuyisela futhi singesomnikazi wesizindalwazi, hhayi esokubuyekezwa kokusebenza. Qala ngokubeka iwindi lokulahleka kwedatha elibekezelelekayo, khetha indlela eliyanelisayo, bese uthuthukisa ngaphakathi kwalowo mkhawulo. Izinketho ezigcina ukuvikelwa okuhambisanayo zihlanganisa ukususa uhambo lokuqinisekiswa olungagwemeka lapho uhlelo lukuvumela, ukulungisa umgoqo wokuthutha noma wesitolo olinganisiwe, kanye nokuhambisa ikhophi ukuze isiqinisekiso sihambe ibanga elifushane. Zilinganise nesidingo sokuqina owakuqala ngaso, esingashintshanga.