Multi Master

Multi master ae PostgreSQL world ma haju ek new concept 6e.

Aa haju ek theoratical and experimental model 6e but lage 6e k aa future mate promising 6e.

Aa model ma ek karta vadhare nodes write ne accept karse and origin alag hova 6ata, badha nodes pase same data j hase.

haal ma matra ekj commercially available product 6e k j aa dual channel logical replication perform kare 6e. aa product 6e Bidirectional Logical Replication. aa PostgreSQL na 9.4 version thi aa theoretically possible thai sakyu 6e.

Aa Multi Master nu ek bau moto advantage ae 6e k aapde failover framework ni jarur nathi. aa case ma jo koi node available nathi to aapde wait karvu nathi padtu, aapde simple koi bija writable node sathe connect kari sakie 6ie.

Ghani rite aa bau saru 6e pan Multi Master database ghana karno thi recommended nathi. For example, same data record ne, ek time, alag alag server ma, alag alag value sathe change thayel 6e. aa ek prakare git conflict jevu j thai 6e to aapde ae identify karvu pade k kya data change ne aapde accept karvu.

Jyare aapde sequences manage karta hoie, upgrade karta hoie and failover ne test karta hoie tyare ghana complications face karie 6ie.