How do you copy data across different regions for databases? What are the different ways to do it?

hey all, lookin for some real-world insights on multi-region database replication. were setting up a new service that needs low latency reads globally and high availability. were considering options like active-active setups or async replication, but the trade-offs seem complex. what challenges have you faced with consistency, conflict resolution, and failover in these scenarios? any specific database tech or patterns youd recommend or caution against for a multi-region deployment