DBaaS, cloud and transparent query routing
More often than not replicas are deployed for high availability and or read scaling If the primary fails one of the replicas is promoted to primary If there are lots of reads and that s almost always the case replicas …