Multi-Region, Multi-Primary, and Eventually Consistent Database Systems
Explore an innovative approach to leveraging eventually consistent multi-primary databases while maintaining strong consistency for application writes. Discover how to implement a "follow the sun" strategy, moving writes across different regions based on time of day, while benefiting from globally replicated reads and avoiding data conflicts. Learn about a clever implementation using service mesh, open policy agent, and other technologies, without requiring database configuration changes. Understand the importance of this pattern for use cases such as financial trading systems with regional write requirements and auctions intolerant to eventually consistent last writer patterns. Gain insights into overcoming challenges associated with multi-region, multi-primary, and eventually consistent database architectures in this 30-minute conference talk presented by Bryan Oliver from Thoughtworks at a CNCF event.