Building a highly available database for a multi-region architecture involves leveraging public cloud infrastructures like AWS, Azure, and GCP, which consist of geographically distributed availability zones to ensure high system resilience and failover tolerance. Multi-region architectures are crucial for mission-critical applications, demanding high availability and continuity of operations with minimal downtime and data loss. CockroachDB offers a unique solution as a cloud-native, globally-distributed SQL database that actively replicates transactional writes across multiple cloud regions, allowing for nearly zero recovery time (RTO) and zero data loss (RPO). Setting up a resilient multi-region CockroachDB database involves starting nodes in various cloud regions, adding database regions to ensure resilience against region failures, and setting a region survival goal to optimize replica distribution, ensuring that the database remains available even if a primary region fails. CockroachDB's architecture allows application clients to continue operations seamlessly, maintaining data integrity and availability across diverse geographical locations.