Qhov txawv ntawm Daim iav thiab Replication

Cov txheej txheem:

Qhov txawv ntawm Daim iav thiab Replication
Qhov txawv ntawm Daim iav thiab Replication

Video: Qhov txawv ntawm Daim iav thiab Replication

Video: Qhov txawv ntawm Daim iav thiab Replication
Video: coj sawv daws mus saib lawv khawb vaj pov cov nyiaj nyob zos noom taj xeev khuam 2024, Kaum ib hlis
Anonim

Qhov sib txawv tseem ceeb ntawm mirroring thiab replication yog qhov mirroring tshwm sim ntawm cov ntaub ntawv thaum replication tshwm sim ntawm cov ntaub ntawv thiab cov khoom siv database. Lwm qhov sib txawv tseem ceeb ntawm mirroring thiab replication yog qhov mirroring tsis txhawb kev faib ib puag ncig tab sis, replication txhawb kev faib database ib puag ncig.

Daim iav thiab rov ua dua yog ob txoj hauv kev hauv DBMS uas txhim kho cov ntaub ntawv muaj thiab kev ntseeg tau. Mirroring cuam tshuam cov luam theej ntawm cov ntaub ntawv tsis tu ncua thaum rov ua dua suav nrog cov ntaub ntawv thiab cov khoom siv database xws li cov lus pom thiab lwm yam.

Daim iav yog dab tsi?

Database mirroring cuam tshuam nrog duplicate cov ntaub ntawv khaws cia hauv lub tshuab lossis lub server rau lwm tus neeg rau zaub mov. Tus thawj database yog tus thawj database. Cov ntaub ntawv theej yog daim iav database. Lub kaw lus luam tag nrho cov kev hloov pauv ua rau tus thawj tswj hwm cov ntsiab lus rau daim iav. Hauv lwm lo lus, tus thawj tswj hwm tus thawj tswj hwm tau hloov pauv hloov pauv hloov tshiab rau ntawm daim iav server database. Yog tias qhov ua tsis tiav, lub kaw lus tuaj yeem rov qab tau cov ntaub ntawv los ntawm kev luam tawm ntawm ib lub database mus rau lwm qhov. Yog li ntawd, yog tias qhov ua tsis tiav, daim iav database pib ua haujlwm zoo ib yam li tus thawj tswj hwm database.

Qhov txawv ntawm Mirroring thiab Replication
Qhov txawv ntawm Mirroring thiab Replication
Qhov txawv ntawm Mirroring thiab Replication
Qhov txawv ntawm Mirroring thiab Replication

Daim duab 01: DBMS

Tsis tas li ntawd, kev siv cov ntaub ntawv tsom iav yog kim thiab kev hloov kho tas li tuaj yeem ua rau kom latency thiab ua haujlwm qeeb. Feem ntau, neeg rau zaub mov tsis tuaj yeem ua rau cov ntaub ntawv poob tab sis cov ntaub ntawv mirroring yog ib qho kev daws teeb meem zoo dua los daws qhov teeb meem no.

Dab tsi yog Replication?

Data replication yog nquag luam cov ntaub ntawv thiab cov ntaub ntawv khoom los ntawm ib lub database mus rau lwm lub database. Feem ntau, tus neeg rau zaub mov uas muab cov ntaub ntawv rov ua dua rau lwm tus servers yog tus tshaj tawm. Tus neeg rau zaub mov uas tau txais cov ntaub ntawv rov qab los ntawm tus tshaj tawm yog tus neeg siv khoom.

Muaj peb hom database replications. Lawv yog cov snapshot, sib koom ua ke thiab pauv hloov pauv. Ua ntej, hauv snapshot replication, cov ntaub ntawv ntawm ib lub server luam rau lwm tus neeg rau zaub mov database lossis lwm cov ntaub ntawv hauv tib lub server. Secondly, nyob rau hauv merging replication, cov ntaub ntawv los ntawm ntau databases muab tso rau hauv ib tug database. Thirdly, hauv kev hloov pauv hloov pauv, pib, cov neeg siv tau txais cov ntawv luam tag nrho thiab tom qab ntawd tau txais cov hloov tshiab tas li raws li cov ntaub ntawv hloov pauv.

Zuag qhia tag nrho, Database replication muab ib qho chaw faib database uas pab cov neeg siv nkag tau cov ntaub ntawv ntsig txog lawv txoj haujlwm. Ib qho chaw khaws ntaub ntawv uas muab cov ntaub ntawv tsom iav thiab rov ua dua yog MSSQL Server.

Qhov txawv ntawm daim iav thiab rov ua dua yog dab tsi?

Mirroring yog txheej txheem ntawm kev tsim thiab tswj cov ntawv luam ntawm cov ntaub ntawv. Ntawm qhov tod tes, Replication yog cov txheej txheem txuas ntxiv luam cov ntaub ntawv hloov pauv ntawm ib lub database mus rau lwm qhov database. Mirroring yog ua nyob rau hauv lub database thaum replication yog ua nyob rau hauv ob qho tib si cov ntaub ntawv thiab database khoom.

Cov ntaub ntawv mirrored yog nyob rau lwm lub tshuab. Ntawm qhov tsis sib xws, cov ntaub ntawv rov ua dua thiab cov ntaub ntawv cov khoom nyob hauv lwm cov ntaub ntawv. Nrog kev txhawj xeeb txog kev txhawb nqa cov ntaub ntawv faib tawm, mirroring tsis txhawb nqa ib puag ncig. Txawm li cas los xij, replication txhawb kev faib cov ntaub ntawv ib puag ncig. Zuag qhia tag nrho, mirroring yog suav hais tias kim nyob rau hauv kev sib piv rau replication, uas yog tsis tshua kim.

Qhov txawv ntawm Mirroring thiab Replication hauv Tabular Form
Qhov txawv ntawm Mirroring thiab Replication hauv Tabular Form
Qhov txawv ntawm Mirroring thiab Replication hauv Tabular Form
Qhov txawv ntawm Mirroring thiab Replication hauv Tabular Form

Summary – Mirroring vs Replication

Kev tsom iav thiab rov ua dua yog ob txoj hauv kev uas pab txhim kho cov ntaub ntawv muaj thiab kev ntseeg siab hauv DBMS. Qhov txawv ntawm mirroring thiab replication yog qhov mirroring tshwm sim ntawm database thaum replication tshwm sim ntawm cov ntaub ntawv thiab database khoom.

Pom zoo: