SQL neeg rau zaub mov replication pub rau cov thawj xibfwb tso tawm cov ntaub ntawv thoob plaws ntau lub servers thoob plaws hauv lub koom haum. Koj tuaj yeem siv cov cai ntawm koj lub koom haum rau ntau yam, xws li:
- Load ntsuas . Replication pub koj disseminate koj cov ntaub ntawv rau ib tug xov tooj ntawm servers thiab ces faib cov lus nug load ntawm cov servers.
- Offline ua . Replication txhawb kev khaws cov ntaub ntawv ntawm koj tus database rau ntawm lub tshuab uas tsis tas txuas rau lub network.
- Redundancy . Replication tso cai rau koj los tsim kom muaj ib qho tsis dhau cov ntaub ntawv database uas npaj txhij tuaj tos cov nyiaj ua haujlwm ntawm lub sijhawm ntawv.
Cov replication scenario muaj ob lub ntsiab Cheebtsam:
- Publishers muaj cov ntaub ntawv los qhia rau lwm cov servers. Cov tswv yim muab ib qho muab tau los kuj muaj ib los sis ntau tshaj tawm.
- Cov neeg muaj npe hauv database uas xav kom tau txais cov tshiab los ntawm Publisher thaum cov ntaub ntawv muab hloov.
Tsis muaj dab tsi los tiv thaiv ib qho system los ntawm qhov ua ob qho ntawm cov kev pabcuam no. Qhov tseeb, qhov no feem ntau yog tsim los ntawm cov txheej txheem teev cov txheej txheem loj database .
SQL neeg rau zaub mov kev them nyiaj yug rau Replication
Microsoft SQL neeg rau zaub mov txhawb peb hom database replication. Tsab ntawv xov xwm no piav qhia txhua yam ntawm cov qauv no, thaum yav tom ntej cov khoom yuav tshawb rau lawv ntxiv. Lawv yog:
- Snapshot replication ua tus txheej txheem nws lub npe implies. Lub publisher tsuas siv lub snapshot ntawm tag nrho cov ntaub database thiab qhia nws nrog cov neeg rau npe. Ntawm chav kawm, qhov no yog ib qho sij hawm heev thiab muaj kev pab cuam. Vim li no, feem ntau cov neeg khiav dej num tsis siv qhov kev cuam tshuam snapshot rau hauv lub hauv paus rov qab rau cov kab ntawv uas hloov ntau zaus. Muaj ob lub scenarios nyob rau hauv uas snapshot replication feem ntau yog siv: Ua ntej, nws yog siv rau cov databases uas tsis tshua hloov. Qhov thib ob, nws yog siv los tsim ib lub hauv paus los tsim kom muaj kev cuam tshuam ntawm cov tshuab thaum yav tom ntej tshiab uas yog siv cov kev siv lag luam lossis kev sib tshuam .
- Transactional replication muaj ntau saj zawg zog tov rau databases uas hloov tsis tu ncua. Nrog transactional replication, tus replication tus neeg saib xyuas saib cov publisher rau cov kev hloov rau cov database thiab xa cov kev hloov no rau cov neeg tuaj koom. Qhov kev kis no tuaj yeem coj qhov chaw tam sim ntawd los yog nyob rau ntawm lub caij nyoog.
- Merge replication pub rau tus neeg ua hauj lwm thiab tus neeg sawv cev rau nws tus kheej los hloov nws cov ntaub ntawv. Ob lub chaw muaj peev xwm ua hauj lwm yam tsis muaj kev sib txuas ua ke. Thaum lawv rov qhib dua, cov neeg saib xyuas kev sib tshuam tshuam ntawm kev sib hloov ntawm ob qho ntawm cov ntaub ntawv thiab kho txhua tus database raws li. Yog tias muaj teeb meem tsis sib haum xeeb, tus neeg sawv cev siv cov txheej txheem daws teeb meem los txiav txim siab txog kev tsim nyog. Merge replication feem ntau yog siv los ntawm laptop cov neeg siv thiab lwm cov neeg uas tsis tuaj yeem txuas nrog cov publisher.
Txhua yam ntawm cov hom kev siv thim rov qab no yog siv lub hom phiaj zoo thiab yog qhov zoo tsim nyog rau kev teev npe tshwj xeeb rau database.
Yog tias koj ua haujlwm nrog SQL neeg rau zaub mov 2016, xaiv koj ib tsab raws li koj cov kev xav tau. Txhua tsab ntawv muaj ntau lub peev xwm txawv thaum nws tawm los txhawb rau kev txhawb nqa:
- Kev them nyiaj yug tus neeg nkaus xwb : Kev Qhia, Kev Qhia Nrog Cov Cuab Yeej los yog Cov Kev Pab Txhawb thiab Web Web muaj peev xwm muaj peev xwm hloov tau, uas muaj peev xwm ua tus sawv cev tam sim no.
- Cov kev pabcuam Full Publisher thiab tus neeg siv yuav : Txheem thiab Enterprise muab kev pabcuam tag nrho, nrog Enterprise xws li Oracle publishing, peer los saib xyuas cov lag luam kev sib txuas lus, thiab cov lag luam luam ua ib qho kev hloov tshiab.
Raws li koj tau undoubtedly pom los ntawm qhov point, SQL neeg rau zaub mov replication muaj peev xwm muab kev lag luam tus thawj xibfwb ib qho cuab yeej haib rau kev tswj thiab scaling databases nyob rau hauv ib qho chaw lag luam.