Google Cloud SQL provides read replica eventual consistency. The time that it takes a replica to catch up to the master is called Replication lag.
How long is replication lag? That depends entirely on how busy the master and replicas are. You can determine this value by reading the Seconds_behind_Master metric (MySQL). See this link for PostgreSQL.
A good ...
When it comes to limits with Google Cloud Spanner, the official documentation points out the concurrent connections are limited up to 100 per session.
Commit size (including indexes)/ 100 MB
Concurrent reads per session/ 100
Mutations per commit (including indexes)/ 20,000
Concurrent Partitioned DML statements per database/ 20,000
Configuring the ...
There is a way in which you can get this desired architecture.
I will list out the steps to be able to do it.
Basically what you want is port forwarding from one IP, which is publicly accessible, to multiple IPs, which are not publicly available, through which you can connect to the Cloud SQL backend server.
To do that -
Create two Cloud SQL instances of ...