What is streaming replication?

Data Replication ae unexpected events jevi k crashing ma safety ensure kare 6e and massive load na case ma high availability provide kare 6e.

Replica server ne updated rakhva mate, PostgreSQL ek Streaming kari ne standard feature provide kare 6e. aa feature WAL (Write-Ahead Logging) files ne contineusly bija replica server ma ship and apply karva mate use thai 6e.

Streaming saru karta pehla chalo jani laie k Streaming thi aapda system ne su capability male 6e?

1. Failover jyare primary server fail thay 6e tyare stadby replica server takeover kari le 6e. Matlab k failure thai ae case ma bhi aapdi pase ek highly available system hase.

2. Load Balancing Read Only queries multiple server ma distribute thai jay 6e. PostgreSQL streaming replication master slave configuration ni madad thi set thai 6e. Master, j primary instance tarike pan odkhai 6e ae read and write server hoi 6e, jyare slaves ae read only servers hoi 6e. Standard PostgreSQL server pase distribution feature nathi k jenathi load ne consider kari sakay and koi query ne kya send karvi aevu koi mechanism nathi hotu. Aana mate aapde PgPool-ii and HAProxy jeva open source tools no upyog kari sakie 6ie je open source tools 6e. Aa tools, bau sari rite load ne distribute kari sake 6e.

Streaming replication vacche no lag ae bau short hoi 6e pan ae network speed, database ni activity and standby settings par pan aadhar rakhe 6e k aa lag ketlo hase.

Replicated changes ek transaction jelto nano bhi hoi sake 6e. jethi primary instance par darek standby no load minimal rahe 6e, jethi aapde single primary ane dozens server ne standby rakhi sakie.