📄️ 🤖 Replication & High Availability
Production environments ma high availability ane data redundancy critical che.
📄️ Scaling PostgreSQL
Chalo mani laie k aapde je business ma 6ie ae bau vadhare successful thai gyo. roj na millions of orders aave 6e. aapda system ma anek products 6e and customers pan roj na vadhe 6e.
📄️ Horizontal scaling options
jyare aapde horizontal scaling implement karie tyare aapde nakki karva nu rahe k aapde main kai capabilities joie 6e?
📄️ CAP Theorum
Jo tame database no use tamara business mate karo 6o, to su aeni quality same rehse jo tamaro business 10x or 100x chalto hoi?
🗃️ Streaming Replication
3 items
🗃️ PgBouncer
4 items
🗃️ Logical Replication
5 items
📄️ PostgreSQL vs NoSQL
Cassandra
📄️ Use Case: Consistency and Availability
Aapde su choose karvu joie? Consistency or Availability?
📄️ Use Case: Availability and Partition Tolerent
jo instagram ma koi user koini image ne like kare 6e to ae user na likes na record ma aa image nu id add thai jase and aa image na record ma pan ae user nu id add thai jase. aa case ma, jo aa banne mathi ek operation fail thai 6e to data consistency nahi rahe. Pan ahi aa koi critical vastu nathi.
📄️ Read vs Write bound workload
Assume karo k aapde vadhare ne vadhare request male 6e ane database bau vadhare slow response mokle 6e.
📄️ Statistics
Jo aapdi pase matra basic system metrics hase, jem k CPU, Memory and Disk, to aa case ma ae janvu sakya nathi k traffic kai type no aave 6e.
📄️ Scaling for Reads
Jyare aapde statistics ne dhyaan ma rakhi ne better read performance achieve karva mate read bound scaling karvu pade tyare, vadhare ne vadhare servers set karva ae bau vadhare common 6e.
📄️ Load Balancing
Replicas par load ne distribute/spread karva mate, aapde ek middle layer ne application nodes and read replicas vachee set karvu required 6e. Aane load balancer kehvay 6e. aa rite aapde load ne ek karta vadhare replicas vacche set kari sakie 6ie. aa set ne Replica Read Pool pan kehva ma aave 6e. aa implementation karva mate jo aapde aapdu potanu solution create karta hoi athva to network based balancer set karta hoi athva aapde public cloud environment ma hoi to pan je technology no use thay 6e aema 6e HAProxy ane PgPool II.
📄️ Connection Pooling
Scalability ma haju ek better use case 6e k jyare number of connections bau vadhare vadhi jaay.
📄️ Scaling for Write
Queuing
📄️ Multi Master
Multi master ae PostgreSQL world ma haju ek new concept 6e.
📄️ Alag alag prakar ni practice
- pgstatstatement extention integration.