Ukuphindaphinda kwe-SQL Server kuvumela abalawuli beenkcukacha ukuba bahanjiswe idatha kumaseva amaninzi kuwo wonke umbutho. Unokufisa ukuphumeza ukuphindaphinda kwintlangano yakho ngezizathu eziliqela, njenge:
- Ukulayisha ukulinganisa . Ukuphendulela kukuvumela ukuba usasaze idatha yakho kwinani lamaseva uze usasaze umthwalo wombuzo phakathi kwala mavava.
- Ukucinywa kokungaxhasi . I-Replication isekela ukutshintsha idatha esuka kwisiseko sakho kumatshini ongekho ngaso sonke isikhathi exhunywe kwinethiwekhi.
- Redundancy . Ukuphendulela kukuvumela ukuba wakhe umncedisi wesiseko se-database ekulungele ukuthayatha umthwalo wokucwangcisa kwesaziso somzuzu.
Nayiphi na imeko yokuziphendulela inezinto ezimbini ezibalulekileyo:
- Abapapashi banedatha yokunikela kwamanye amaseva. Isikimu sokuphindaphinda sinokuba nomvakalisi omnye okanye ngaphezulu.
- Ababhalisayo ngamaseva eenkcukacha ezifisa ukufumana izibuyekezo ezivela kuMshicileli xa idatha iguquliwe.
Akukho nto inqanda inkqubo enye ukuba isebenze kuzo zombini ezi zinto. Enyanisweni, oku kudla ngoyilo lweenkqubo ezinkulu ezikhoyo zesiseko seenkcukacha .
Inkxaso yeSquL Server yokuphendula
I-Microsoft SQL Server isekela iintlobo ezintathu zokuphindaphinda kwedatha. Eli nqaku linika isingeniso esifutshane kulowo nalowo mzekelo, ngelixa amanqaku amva aya kuhlola ngeenkcukacha ezingaphezulu. Bazi:
- Izenzo zokuphindaphinda kwi-Snaphot ngendlela egama layo lichaza ngayo. Umshicileli uthatha nje umfanekiso we-database yonke ephindaphindiweyo kwaye uyabelana nabo nababhalisile. Ngokuqinisekileyo, eli lixesha elide kunye nenkqubo enamandla. Ngenxa yesi sizathu, abaninzi abalawuli abasebenzisi ukuphindaphinda kwe-snapshot kwixesha eliphindaphindiweyo lweenkcukacha ezitshintsha rhoqo. Kukho iziganeko ezimbini apho ukuphindaphinda ngokuphindaphindiweyo kusetyenziswa ngokuqhelekileyo: Okokuqala, isetyenziswe kwiinkcukacha zolwazi ezingaqhelekanga. Okwesibini, isetyenziselwa ukusekela isiseko sokuqalisa ukuphindaphinda phakathi kweenkqubo ngelixa ukuhlaziywa kwangomso kusasazwa ngokusetyenziswa okanye ukudibanisa ukuphindaphinda .
- Ukuphindaphinda ukunikezelwa kwesibonelelo kunika isisombululo esiphezulu kwisimo seenkcukacha esitshintsha rhoqo. Ngokuphindaphindiweyo, i-agent yokuziphendulela ilungisa umvakalisi ngokutshintshwa kwi-database kwaye idlulisela olo tshintsho kubabhalisi. Olu tshintsho luyakwenzeka ngokukhawuleza okanye ngexesha elifanelekileyo.
- Ukudibanisa ukuphindaphinda kuvumela umshicileli kunye nombhalisi ukuzimela ngokuzimela kwiinguqulelo. Zombini zombutho zinokusebenza ngaphandle koxhumano oluxhumo lwenethiwekhi. Xa baxhunyelelwa kwakhona, i-agent yokuziphendulela ihlolisisa utshintsho kwiiseti zombini yedatha kwaye iguqula nganye idatha ngokufanelekileyo. Ukuba kukho utshintshi, ummeli usebenzisa i-algorithm yesigqibo sokusombulula ingxabano ukucacisa idatha efanelekileyo. Ukudibanisa ukuphindaphinda ngokuqhelekileyo kusetyenziswa ngabasebenzisi bekhomputha kunye nabanye abangenakuhlala bexhumeke kumvakalisi.
Ngalunye lwezi zixhobo zokuphindaphinda zenza injongo ebalulekileyo kwaye zifanelekile kwiimeko ezithile zeenkcukacha.
Ukuba usebenza neSQL Server 2016, khetha ukhetho lwakho olusekelwe kwizidingo zakho zokuziphindaphinda. Uhlobo ngalunye lunamakhono ahlukeneyo xa kuziwa ekuncedeni ukuphindaphinda:
- Ukuxhaswa kuphela kwabakwi-Subscriber : Express, Express ngeZiko okanye Iinkonzo eziPhambili kunye neeWebhu zeeWebhu zinikezela amandla okuphindaphinda, okukwazi ukwenza njengomphathi wokuziphendulela kuphela.
- Inkxaso epheleleyo yoMshicileli kunye neBhalisi : I- Standard kunye ne- Enterprise inikeza inkxaso epheleleyo, kunye ne-Enterprise nayo ibandakanya ukushicilelwa kwe-Oracle, oontanga nokuphindaphinda ukutshintshana, kunye nokuphindaphinda okwenziwa ngokuphindaphindiweyo njengento ebhalisiweyo.
Njengoko ungaqinisekanga ukuba uyaziqonda ngeli nqaku, ubuchule bokuphindaphinda kwe-SQL Server buhlinzeka ngabalawuli beenkcukacha zixhobo esinamandla ekulawuleni nasekukhuleni ulwazi olusesikweni kwimeko yezoshishino.