Dab tsi yog slony replication?
Dab tsi yog slony replication?

Video: Dab tsi yog slony replication?

Video: Dab tsi yog slony replication?
Video: Yog hmoov dab tsi - Gao Nou Kue ft. Mang Vang (Official Music Video) New song 2020 2024, Kaum ib hlis
Anonim

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: