<p>I have multiple SQL Read-only replicas setup on my GCP environment. I have two requirements.</p>
<ol>
<li><p>Loadbalance select queries from my app pod to multiple read-only replicas.</p>
</li>
<li><p>Read-Replicas can increase/decrease and i want to keep this logic separate from application.</p>
</li>
</ol>

Ali Ahmad
<p>According to the <a href="https://cloud.google.com/sql/faq#rr_lb" rel="nofollow noreferrer">Cloud SQL documentation</a>:</p>
<blockquote>
<p><strong>Does Cloud SQL provide load balancing for requests to read replicas?</strong></p>
<p>Cloud SQL does not automatically provide or configure load balancing. You can use <a href="https://cloud.google.com/sql/docs/mysql/manage-connections" rel="nofollow noreferrer">connection pooling</a> to distribute read requests between read replicas by switching between multiple connection endpoints.</p>
</blockquote>
<p>Thus there isn't a build-in way to achieve the logic you are searching for in Cloud SQL. This means that it might need to be programmed on the logic of the application that you use to manage your connections to Cloud SQL.</p>
