Skip to main content

Horizontal scaling options

jyare aapde horizontal scaling implement karie tyare aapde nakki karva nu rahe k aapde main kai capabilities joie 6e?

Like... Heavy Read, Heavy Write or Heavy Available.

what we want to achieve

Read Bound Workload​

Replication​

Aapde pase replication mate option hoi 6e k aapde performance joie 6e, k flexibility.

Load Balancing​

Tyar pa6i aapdo question hovo joie k aapde multiple computers/servers ne same data ne return karva mate allow karie 6ie k nahi.

Aa case ma aapdi pase 2 powerful options 6e.

  1. HAProxy
  2. PgPool II

Connection Pool​

Jo bau badha database na connection hoi to aapde ek connection pooler ni jarur padse.

Ahiya aapdi pase 2 options 6e.

  1. PgBouncer
  2. PgPool II

Write Bound Workload​

Queuing​

aapde Quiuing ni madad thi traffic growth ne vadhare better rite predict kari sakie 6ie.

Partitioning​

peak table mate aapde partitioning no use kari sakie 6ie.

Sharding​

write bound scaling mate aapde sharding no use kari sakie pan aama alag alag shards ma query mate setup karvu pade 6e.

Multi Master Solution​

Aa ek new concept 6e and vadhare better option bhi 6e.

High Availability​

jo aapdi main priority High Availability 6e k jeni madad thi jo aapdu ek cluster kaam na kartu hoi to bhi ae work kartu rehvu joie to aa case ma High Availability na configurations ne aapde set kari sakie.

Replication​

aapde high replication strategy ni madad thi achieve kari sakie 6ie.

Fail-Over​

jo primary server fail thai to ae case ma aapde thoda tools no use kari ne secondary server take over kari le ae rite configuration kari sakie. aa tools hoi sake 6e.

  1. Repmgr
  2. Patroni
  3. PgPool II