Cloud-Native Microservices With Kubernetes - 2nd Edition

A Common Topology for Relational Databases

Relational databases are widely used in modern applications to store and manage structured data. A common topology for deploying relational databases in a production environment is the primary-replica (sometimes called master-slave) architecture. In this architecture, one database instance is designated as the primary (or master) node, which handles read and write operations. One or more replica (or slave) nodes are set up to replicate data from the primary node and handle read operations. This is usually done by following these steps:

• The primary node receives write requests from the application and updates its data accordingly.
• The primary node then asynchronously replicates the changes to its replica nodes using a replication mechanism (e.g., WAL shipping, streaming replication, etc.).