Guidance for Developers# Designing applications for PGD Assessing an existing application for PGD Using pgd assess Reviewing backup strategies Reviewing replication and CDC setups Preparing your application for PGD Understanding your workload Planning your write strategy Planning your read strategy Designing your schema for replication Accounting for replication behavior Avoiding data anomalies Achieving durability with commit scopes Using predefined scopes Example scenario: primary active group with DR group Fine-tuning with custom scopes Constructing a custom scope Choosing a commit kind Applying a commit scope Example: Combining local majority with cross-region confirmation Example: Requiring all local nodes and two cross-region nodes Example: Handling multiple durability requirements in a payments workload Using connection pooling in your application Understanding the active pool mode Adapting your application for transaction mode Managing session parameters Using prepared statements Developing applications for geo-replication When geo-replication affects your application Make your application geo-replication ready Connect through Connection Manager Choose commit scopes per operation Design your schema to minimize conflicts Configure selective replication Handle retries correctly Run DDL safely
