Trade-offs between Availability and Consistency

Understand the Trade-offs between Availability and Consistency.

Should prefer High Availability over strong consistency as soon as possible to scale horizontally. (the CAP theorem)

▪ Transactional Boundaries Between Microservices

Consider business Transactional Boundaries Between Microservices, that data need to consistent across those microservices. Prepare for compensating transactions in case of fail.

▪ Competence of Development Teams

Consider your team competences about database technologies. Skill set of your development team should cover optimize queries and tune for performance improvements.

https://shopify.engineering/five-common-data-stores-usage