Our database would not be considered managed unless we have figured out how to get replicas created and managed. Cloud SQL by default does not provide replicas, but we can create them. There are four types of replicas to choose from. Despite of all of this, the reason behind creating such replicas is to increase query capacity for read intensive databases:
Type 1: Read Replicas:
These are low cost low availability replicas of the master instance, which contains root password and changes made to the master. The changes are least likely to be real time. The replicas can also face disruptions due to server outage or sudden upgrade:
- The configuration of the replica instance may be different from the master instance based on the choices we make and it is viable to make read replicas that have lower configurations if the application is not mission...