Logical replication menene kuma yaushe ake amfani da ita?

Question

Accepted Answer

**Logical replication** tana yin watsi da canje-canjen bayani a matakin **tabiloyi da aka zaɓa** (ta amfani da tsarin watsa/karbi), maimakon kwakwalwa dajoren gida duka byte-for-byte kamar physical (streaming) replication. Wannan ya sa ita mai ƙarfi — zaɓantawa, gida-zuwa-gida, da gaggaɗan tsarin — daidai ne don ƙaura da haɗi.

## Logical da physical replication

```text
PHYSICAL (streaming) → replicates the ENTIRE cluster at the storage/WAL level
  ✓ exact copy, simple   ✗ all-or-nothing, same Postgres version, read-only replica

LOGICAL → replicates specific TABLES' changes via a publish/subscribe model
  ✓ SELECTIVE (choose tables), CROSS-VERSION, to DIFFERENT schemas, replica is WRITABLE
  ✗ more setup, some limitations (DDL not replicated automatically, etc.)
```

## Saita logical replication (pub/sub)

```sql
-- on the SOURCE (publisher): publish specific tables
CREATE PUBLICATION my_pub FOR TABLE users, orders;
-- (or FOR ALL TABLES)

-- on the TARGET (subscriber): subscribe to the publication
CREATE SUBSCRIPTION my_sub
  CONNECTION 'host=source dbname=mydb user=rep'
  PUBLICATION my_pub;
-- → the subscriber receives and applies changes to users and orders
```

**Publication** yana bayyana abin da zai ɗan (tabiloyi da aka zaɓa); **subscription** tana karbi shi. Canjin (INSERT/UPDATE/DELETE) suna aiki daga publisher zuwa subscriber.

## Yaushe logical replication ake amfani da ita

```text
✓ ZERO-DOWNTIME MAJOR UPGRADES — replicate from an old version to a new version, then
  switch over (physical replication can't cross versions) — a key use case
✓ MIGRATIONS — move data to a new server/cluster with minimal downtime
✓ SELECTIVE replication — replicate only certain tables (not the whole database)
✓ INTEGRATIONS — feed specific data to another system (analytics, data warehouse)
✓ Consolidating data from multiple databases into one
✓ The replica is WRITABLE (can have its own additional data/tables)
```

## Me yasa aka fada shi

Logical replication shine ilimi mai daraja game da PostgreSQL don **canjin bayani masu saukin taji da ƙarfi** — musamman ƙaura, sabuntawa, da haɗi — saboda haka fahimta shi shine ilimi mai daraja don aiki da gida dajoren kuma tsarin gida.

Kabar sa na gaske daga physical (streaming) replication shine **saukin taji**: maimakon kwakwalwar dajoren gida duka byte-for-byte (physical), logical replication tana yin watsi da canje-canjen bayani a matakin **tabiloyi da aka zaɓa** ta watsa/karbi, kuma musamman yana aiki **shafar PostgreSQL na tsari-tsari daban-daban** kuma zuwa **tsarin daban-daban**, tare da **subscriber** na iya rubuta.

Wannan saukin taji ya ba da ikon abubuwan amfani da physical replication ba ta iya yin: musamman **zero-downtime major version upgrades** (yin watsi daga tsohuwar Postgres zuwa sabuwar, sannan juyawa — iko mai mahimmanci tun da physical replication ya buƙaci nau'i daya, na yada logical replication shine hanyar da aka saba don sabunta major versions ba tare da dakatar ba), **ƙaura** (jigilar bayani zuwa sabuwar server/cluster tare da ƙaramin dakatar), **zaɓantaccen watsi** (yin watsi da tabiloyi kaɗan kawai), da **haɗi** (ba bayani ta musamman zuwa tsarin nazari, gida gajera, ko sauran bayanai).

Fahimta saita watsa/karbi (watsa-bayani ta bayyana abin da zai ɗan, haɗe-haɗe ta karbi su) da abubuwan da suka dace (musamman sabuntawa da ƙaura) yana nuna ilimi mai daraja game da aiki.

Tun da babbar sabuntawa da ƙaura tare da ƙaramin dakatar shine mahimman wajabin aiki na gaske (kuma logical replication ita ce kayan aikin mahimmanci), kuma tun da zaɓantaccen/gida-zuwa-gida watsi ya ba da ikon haɗi masu daraja, fahimta logical replication — nawa ya banbanta daga physical, saukin tajinsa (shafar nau'i, zaɓantawa, mai ƙarfi), da abubuwan amfani (musamman zero-downtime sabuntawa da ƙaura) — shine ilimi mai daraja don PostgreSQL aiki kuma tsarin gida, musamman daidai ga mahimmancin tattalin arziki na sabuntawa da jigilar bayanai ba tare da dakatar ba, babu mahimman fahimta game da ajojin PostgreSQL kuma aiki.