Buyisela ukulayisha kusuka ku-SQL Server kuye ku-Oracle ngemuva kokuwa kwe-VPN

Ukudluliswa phakathi kwengqoqo zedatha kuyafa lapho i-VPN iwa, futhi «yigijime futhi» akulona uhlelo lokubuyisela. Ukukhishwa emthonjeni kungenzeka kuqediwe, imiyalo ingase isivele yenza i-commit, noma impendulo ingase ilahleke endleleni yokubuya. Lezi zimo ezintathu zidinga izinyathelo ezihlukene, futhi iklayenti elazi kuphela «iphutha» alikwazi ukuzihlukanisa.

Isixazululo singesakhiwo: nikeza ukugijima ngakunye ubunikazi bebatch obuhlala njalo, futhi vumela izinqolobane zedatha ukuthi ziphendule imibuzo esikhundleni sokuvumela iklayenti ukuthi liqage.

Yini ngempela eqinisekiswa yisinqolobane sedatha

I-SQL Server ne-Oracle zombili zinikeza i-atomiki ngaphakathi kwetransaksi. Akukho okunikeza i-atomiki phakathi kwazo zombili. Ukuxhumana okulahlekile akulimazi isinqolobane sedatha futhi akuphoqeleli ukuhlehliswa ngesandla, ngoba iseva isixazulula itransaksi yayo ngaphandle kwakho. Okwephukayo wulwazi lomshayeli mayelana nomphumela.

I-commit ngokwehlukana kusho i-commit ngokwehlukana. I-VPN ethwala kokubili ukuxhumana ayihlanganisi ama-commit amabili abe yiyunithi eyodwa yomsebenzi.

I-commit ongakaze uyizwe

Indlela eyodwa yokwehluleka ijezisa umqondo wokuphinda uzame ongenalwazi: iseva yenza i-commit, futhi isiqinisekiso asisoze safinyelela kumshayeli. I-Oracle ikubhala lokhu njengenkinga yomphumela ongaziwa futhi inikeza i-Transaction Guard ngayo embhalweni wetransaksi. Iphutha lokuxhumana akubona ubufakazi bokuthi i-commit ethunyelwe yehlulekile, futhi ukukuthatha njengobufakazi yiyo indlela ibatch eshicilelwa ngayo kabili. Lo mehluko ubaluleke kakhulu endleleni yokuphinda uzame, lapho umsebenzi enomlayezo wephutha futhi engenaso esinye isignali angasebenza ngaso.

Ngakho-ke isinyathelo sokubuyisela kufanele sifunde umphumela kumiyalo esikhundleni sokuwuqagela embhalweni wephutha.

Nikeza ukudluliswa ubunikazi bebatch

Ukugijima ngakunye kuthola i-ID yebatch engashintshi, futhi imiyalo ibhala lokho ekwenzile ngaleyo ID. Umjikelezo wempilo unezinyathelo ezine, futhi ubukeka bufana noma ngabe ungubani umthengisi:

1. Khipha ibatch yomthombo ekhonjiwe futhi engashintshi enesikimu nomngcele obhaliwe.
2. Dlulisa iye endaweni yokulungiselela yemiyalo futhi uthole okuqukethwe okungaphelele noma okuphikisanayo ngaphambi kokukubiza ngokuthi kulungile.
3. Sebenzisa ngaphansi kwemithetho yemiyalo uqobo yobunye noma yokukhiya futhi ubhale ukuqedwa kulelo transaksi lendawo.
4. Vumelanisa umphumela ohlala njalo ngeprotokholi esekelwayo ngaphambi kokuqinisekisa noma ukuphinda uzame.

Ukuphinda uzame kusebenzisa i-ID efanayo. I-ID entsha esivivinyweni ngasinye yephula ukuvinjelwa kokuphindaphinda okusanda kwakhiwa, okubonakala kucaca kuze kube yilapho isembozo sokuphinda sizale esinye ngokuzenzakalela.

I-ID iphinde ikunikeze into ongavumelanisa ngayo kamuva, isikhathi eside ngemva kokunyamalala kwenqubo yeklayenti.

Funa ibatch, bese uyisebenzisa

Isinyathelo sokusetshenziswa kufanele sifune i-ID yebatch, senze izinguquko zebhizinisi, futhi sibhale ukuqedwa kutransaksi eyodwa yendawo. Ukwenza ukuhlola nokufaka njengezitatimende ezihlukene kubuyisela umjaho obuwufuna ukuqeda. Uma abasebenzi ababili bencintisana, kuwina ukufuna okukodwa impela futhi omunye uyatshelwa.

Ukungabikho kombhalo wokuqedwa akubona ubufakazi bokuthi itransaksi eqhubekayo ngeke yenze i-commit. Ukufuna kufanele kulandelanise imizamo encintisanayo, noma iprotokholi kufanele ifunde umphumela ohlala njalo ngaphambi kwanoma yisiphi isinqumo.

Ngalokho kulandelanisa sebenzisa indlela yesinqolobane sedatha esekelwayo esikhundleni somjikelezo wokuhlola-bese-uphinda kukhodi yohlelo.

Lokho umklamo ongakwazi ukukuthembisa

Ukulungiselela kwenza umsebenzi ukuthi uqalwe kabusha futhi kunciphisa ukuncika esikhathini eside esisodwa. Akudali i-commit eyodwa ye-atomiki kuyo yonke i-SQL Server, i-Oracle nanoma yimuphi umphumela wangaphandle owenziwa umsebenzi. Uma ibhizinisi likudinga ngempela, klama futhi uqinisekise itransaksi edabulekile esekelwayo noma inqubo yokuvumelanisa, kuhlanganise nokuthi ubani ongumnikazi womsebenzi onomphumela ongaqinisekile. Noma yini ebuthaka kunalokho ingeyencwadi yokuvumelanisa, hhayi ikhodi yokudlulisa.

Yamukela ukuphazamiseka ezindaweni ezintathu: ngesikhathi sokudlulisa, ngesikhathi sokusetshenziswa, nangemva kwe-commit kodwa ngaphambi kokuqinisekisa. Bese uhlola umphumela webhizinisi esikhundleni somlayezo weklayenti, futhi vumela incwadi yebatch ukuthi isho ukuthi umsebenzi awuphelele, u-commit, noma awukaxazululwa.