Video: Dab tsi yog slony replication?
2024 Tus sau: Lynn Donovan | [email protected]. Kawg hloov kho: 2023-12-15 23:47
Los ntawm Wikipedia, phau ntawv dawb encyclopedia. Slony -Kuv yog asynchronous master- qhev rov ua dua system rau PostgreSQL DBMS, muab kev txhawb nqa rau cascading thiab tsis ua haujlwm. Asynchronous txhais tau hais tias thaum cov ntaub ntawv sib pauv tau cog lus rau tus tswv server, nws tseem tsis tau lees paub tias muaj nyob hauv cov qhev.
Ib yam li ib tug yuav nug, streaming replication yog dab tsi?
Streaming Replication (SR) muab lub peev xwm los txuas ntxiv nkoj thiab siv WAL XLOG cov ntaub ntawv rau qee tus naj npawb ntawm cov servers nyob rau hauv thiaj li yuav khaws lawv tam sim no. Qhov no feature tau ntxiv rau PostgreSQL 9.0 ib. Cov kev sib tham hauv qab no yog tus tsim tawm taw qhia uas muaj qee cov ntaub ntawv tsis tu ncua.
Tsis tas li ntawd, Bucardo yog dab tsi? Bucardo yog ib qho kev rov ua dua tshiab rau ob lossis ntau dua Postgres databases. Tshwj xeeb, nws yog asynchronous, multi-master, master-slave table-based replication system. Nws yog sau nyob rau hauv Perl, thiab siv nws kim heev ntawm triggers, PL/PgSQL, thiab PL/PerlU.
Yog li ntawd, PostgreSQL puas txhawb nqa rov ua dua?
Features nyob rau hauv lub Core ntawm PostgreSQL Kub Standby / streaming Replication yog muaj li ntawm PostgreSQL 9.0 thiab muab asynchronous binary rov ua dua rau ib qho lossis ntau dua standbys. Standbys kuj tseem tuaj yeem ua qhov kub standbys txhais tau tias lawv ua tau yuav queried raws li ib tug nyeem nkaus xwb database.
Dab tsi yog qhov kev rov ua dua tshiab hauv PostgreSQL?
Logical replication yog ib txoj kev rov ua dua cov ntaub ntawv khoom thiab lawv cov kev hloov pauv, raws li lawv rov ua dua tus kheej (feem ntau yog tus yuam sij tseem ceeb). Peb siv lub sij hawm logical sib piv rau lub cev rov ua dua , uas siv cov chaw nyob thaiv qhov tseeb thiab byte-by-byte rov ua dua.
Pom zoo:
Cross region replication in AWS yog dab tsi?
Hla Region Replication. Cross Region Replication yog ib qho feature uas replicates cov ntaub ntawv los ntawm ib lub thoob mus rau lwm lub thoob uas yuav nyob rau hauv ib cheeb tsam sib txawv. Nws muab asynchronous luam ntawm cov khoom hla thoob. Piv txwv tias X yog lub thoob qhov chaw thiab Y yog lub thoob qhov chaw
Multi master replication nyob rau hauv Active Directory yog dab tsi?
Multi-master replication yog ib txoj hauv kev ntawm database replication uas tso cai rau cov ntaub ntawv khaws cia los ntawm ib pawg ntawm cov khoos phis tawj, thiab hloov kho los ntawm txhua tus tswv cuab ntawm pab pawg. Txhua tus tswv cuab teb rau cov lus nug ntawm cov neeg siv khoom. Tus tswv yog tib lub server ua haujlwm rau cov neeg siv khoom sib cuam tshuam
Dab tsi yog replication hauv Redis?
Rov ua dua. Redis replication yog ib qho yooj yim heev rau siv thiab teeb tsa tus tswv-qib replication uas tso cai rau qhev Redis servers ua cov ntawv luam ntawm tus tswv servers. Cov hauv qab no yog qee qhov tseeb tseem ceeb ntawm Redis replication: Redis siv asynchronous replication. Replication kuj tseem tsis thaiv ntawm tus qhev sab
Dab tsi yog replication hauv server?
Database replication yog qhov nquag siv hluav taws xob luam ntawm cov ntaub ntawv los ntawm cov ntaub ntawv hauv ib lub khoos phis tawj lossis lub server mus rau cov ntaub ntawv hauv lwm qhov - kom txhua tus neeg siv qhia tib qib ntawm cov ntaub ntawv
Dab tsi yog geo replication hauv Azure?
Active geo-replication yog Azure SQL Database feature uas tso cai rau koj los tsim cov ntaub ntawv thib ob uas nyeem tau ntawm ib tus neeg databases ntawm SQL Database neeg rau zaub mov hauv tib lossis sib txawv cov ntaub ntawv chaw ( cheeb tsam ). SQL Database kuj txhawb pab pawg neeg tsis ua haujlwm. Yog xav paub ntxiv, saib siv pab pawg auto-failover