Ama-ejenti okulingisa e-push ne-pull ngaphesheya kwe-VPN phakathi kweziza

Indawo ye-ejenti, hhayi indawo yedatha, isinqumo esakha ukubhalisa kwe-SQL Server. Imishini eqhuba i-ejenti iyona evula ukuxhumana, isebenza ngaphansi kwe-akhawunti ethile futhi ithwala icala lapho ukuvumelanisa kuma. Ku-VPN phakathi kweziza lowo mehluko uwumklamo, hhayi imininingwane. Dweba ukuxhumana kwe-ejenti ngaphambi kokudweba inethiwekhi.

Iindima ezintathu, hhayi ezimbili

I-Publisher iphethe idatha ye-athikili, i-Distributor iphethe isisekelo sedatha sokusabalalisa, futhi i-Subscriber ithola izinguquko. I-Log Reader Agent isebenza ku-Distributor ukuze ilingise izinkokhelo. I-Distribution Agent iyona eguqukayo indawo yayo ngohlobo lokubhalisa, yingakho inquma umklamo wenethiwekhi. Hlanza lezo zindima ngaphambi kokukhuluma ngemithetho ye-VPN.

Ukubhalisa kwe-push kuqhubisa i-Distribution Agent ku-Distributor, futhi ukubhalisa kwe-pull kuyiqhubisa ku-Subscriber, njengoba imibhalo yokubhalisa yakwa-Microsoft isho. Konke engxoxweni yenethiwekhi kuvela ekutheni iyiphi imishini leyo. Bhala amaqiniso amane ngakunye ukubhalisa: umsingathi we-ejenti, ubunikazi benqubo yayo, ukungena kwesisekelo sedatha okusebenzayo kanye nezinsiza okufanele zifinyelele. Izicucu zomdwebo hhayi zona, la maqiniso asho ukuthi yiluphi uhlangothi okufanele lusebenze.

i-push isho ukuthi i-ejenti ihlala ku-Distributor

Ngokubhalisa kwe-push, i-Distributor ivula ukuxhumana okuya ku-Subscriber ngaphesheya kwe-VPN. Isilaleli, i-firewall nokungena kwe-SQL ngasohlangothini lomhlongi kufanele kwamukele ukuxhumana okuvela kolunye uhlangothi olukude. I-akhawunti yensizakalo ye-Distributor nayo idinga imvume kusisekelo sedatha somhlongi. Hlela leyo ndlela yokungena ngaphambi kokwakha ukubhalisa, ngoba ukuyithola kamuva ngokuvamile kusho ukuyakha kabusha.

Ukulethwa kwesithombe sokuqala kwengeza indlela okungayisebenzisi neze ukulingisa okuzinzile. Uma isithombe sokuqala sibekwe endaweni yokwabelana ngamafayela, i-Distribution Agent ifunda kuleyo ndawo yokwabelana futhi i-akhawunti yomhlongi kufanele ifinyelele leyo ndlela ye-UNC. Ukugeleza kwezinguquko okuthatha amasonto akusho lutho mayelana nokuthi ukuqala kabusha kuzosebenza yini. Yingakho ukwabelana ngesithombe sokuqala kusekuhlelweni kusukela ekuqaleni.

Ungakufundi i-push njengokuhamba ohlangothini olulodwa. I-ejenti idinga izimpendulo, iziqinisekiso kanye nokushintshana kwayo kokuqinisekisa. Indlela kufanele ibe yezinhlangothi ezimbili ezingeni lokuxhumana ngisho nalapho idatha ihamba ohlangothini olulodwa.

i-pull isho ukuthi i-ejenti ihlala ku-Subscriber

Ukubhalisa kwe-pull kuguqula ukuxhumana: i-Subscriber iqhubisa i-Distribution Agent futhi ifinyelela i-Distributor. Lelo lungiselelo lihambisana nenqubomgomo ye-VPN evumela ukuxhumana okuphumayo okuvela egatsheni futhi ivimbe okungena. Ibeka nesinqumo sesheduli ezandleni zalowo onakekela iseva yegatsha. Yikhethe uma iqembu legatsha kufanele libe umnikazi wokuvumelanisa kwalo futhi liqaphele ukwehluleka kwalo.

I-akhawunti yensizakalo ye-SQL Server Agent yomhlongi idinga ukufinyelela kokufunda kusisekelo sedatha sokusabalalisa kanye nasekwabelaneni ngesithombe sokuqala. Leyo akhawunti iwubunikazi obuvela emaphutheni okulingisa, futhi i-akhawunti yensizakalo yasendaweni engenamalungelo esizinda iyahluleka endaweni ebonakala njengokwehluleka kwenethiwekhi kodwa empeleni kungukwehluleka kobufakazi. Hlola i-akhawunti ngaphambi kokulungisa ithumbu. Ukulungisa ukungena ngokuvamile kushesha kunokuqinisekisa ukuthi inethiwekhi ayinalo icala.

Ubunikazi bulandela i-ejenti. Khetha i-push lapho iqembu eliphakathi kufanele libe umnikazi wesheduli nokwehluleka kokubili. Noma yini oyikhethayo, yibhale eceleni kokubhalisa ukuze unjiniyela olandelayo azi lapho eqale khona ukubheka.

Ukushicilela kabusha kuguqula ukusatshalaliswa, hhayi ubunikazi

Umhlongi angalungiselelwa ukushicilela kabusha kwabanye abahlongi, okwenza isisekelo sedatha segatsha esisodwa sikwazi ukukhonza abasebenzisi basendaweni abaningi ngaphandle kokuthi ngamunye adonse nge-WAN. Isisekelo sedatha esiphakathi manje siphethe ukushicilelwa kanye nama-ejenti aso. Siphinde sizuze njengefa izimvume, ukuqapha kanye nohlelo lokubuyisa ebesingenawo ngaphambili. Leyo ndima eyengeziwe iyintengo yokususa ukulethwa kwe-WAN okuphindaphindiwe.

Ukulandelana okubhalwe phansi kubalulekile: qala ukubhalisa okungenayo ngaphambi kokwakha ukushicilelwa okuphansi. Kuthatha njengenyathelo lomjikelezo wokuphila elinokuqinisekisa, hhayi njengamaphepha okweqiwa. Ukukuguqula kubangela uchungechunge olubonakala lulungisiwe kodwa olungalethi lutho.

Shono ngokucacile imodeli yokubhala. Ukulingisa isethi yedatha yokufunda kuphela kumsebenzisi wasendaweni kuwumklamo ohlukile kunokwamukela ukubhala ezizeni eziningi, futhi uchungechunge lwezicucu aludali ukuxazululwa kwezingxabano. Uma igatsha kufanele libhale, leso yisinqumo esihlukile esine-topology yaso. Yenza nokuncika kubonakale: lapho umshicileli kabusha ema, wonke umsebenzisi ongaphansi kwakhe usuphelelwe yisikhathi.

Qinisekisa indawo kusukela ekuqaleni kuze kube sekupheleni

Funda uhlobo lokubhalisa kusisekelo sedatha sokusabalalisa esikhundleni sokwethemba inkumbulo, bese uhlola ukuthi izinguquko ziyafika ngempela:

USE distribution;
SELECT publication, subscriber_db, subscription_type
FROM dbo.MSsubscriptions;
EXEC sp_replmonitorsubscriptionpendingcmds
  @publisher = 'PUB1', @publisher_db = 'Sales',
  @publication = 'SalesPub', @subscriber = 'BR1',
  @subscriber_db = 'Sales';

I-subscription_type enenani elingu-0 yi-push futhi u-1 yi-pull, futhi ayikwazi ukushintshwa endaweni yayo, ngakho ukungafani kusho ukwakha kabusha ukubhalisa hhayi ukukuhlela. Ukubizwa kwemiyalo elindile kukutshela ukuthi i-ejenti ekhethiwe ihambisa umsebenzi noma imane isebenza. Ukubhalisa okubika imiyalo elindile enguziro ngenkathi ithebula lomhlongi lihlala lingenalutho kuwukwehluleka okuhlukile kwalokho okubika umthwalo okhulayo, futhi kokubili kuholela kubanikazi abahlukene.

Qeda ngoshintsho lwangempela: faka noma ubuyekeze umugqa owodwa ku-Publisher, linda umbiko we-ejenti bese ufunda lowo mugqa ku-Subscriber. Kwenza lokho futhi phakathi nokuphazamiseka kwe-VPN okufushane ukuze ubone ukuthi i-ejenti ilulama kanjani. Ukubhalisa okudlula lokho kuhlolwa kunendawo ongayibhala phansi futhi uyivikele.