Skip to content

Upgrade Cloud SQL Proxy to v2 for tests #13123

New issue
New issue
Open
#13194
Open
Upgrade Cloud SQL Proxy to v2 for tests#13123
#13194
Assignees
jackwotherspoon
Labels
priority: p2Moderately-important priority. Fix may not be included in next release.samplesIssues that are directly related to samples.type: cleanupAn internal cleanup or hygiene concern.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.
@jackwotherspoon

Description

@jackwotherspoon
jackwotherspoon
opened on Jan 31, 2025
Contributor

The testing infrastructure starts the Cloud SQL Proxy (v1) prior to running tests:

python-docs-samples/.kokoro/tests/run_tests.sh

Lines 134 to 145 in 8570053

# Run Cloud SQL proxy (background process exit when script does)
wget --quiet https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 \
-O ${HOME}/cloud_sql_proxy && chmod +x ${HOME}/cloud_sql_proxy
${HOME}/cloud_sql_proxy -instances="${MYSQL_INSTANCE}"=tcp:3306,"${MYSQL_INSTANCE}" -dir "${HOME}" &>> \
${HOME}/cloud_sql_proxy.log &
echo -e "\Cloud SQL proxy started for MySQL."
${HOME}/cloud_sql_proxy -instances="${POSTGRES_INSTANCE}"=tcp:5432,"${POSTGRES_INSTANCE}" -dir "${HOME}" &>> \
${HOME}/cloud_sql_proxy-postgres.log &
echo -e "\Cloud SQL proxy started for Postgres."
${HOME}/cloud_sql_proxy -instances="${SQLSERVER_INSTANCE}"=tcp:1433 &>> \
${HOME}/cloud_sql_proxy-sqlserver.log &
echo -e "\Cloud SQL proxy started for SQL Server."

The Cloud SQL Proxy (v2) was released on Jan 17, 2023. Latest is now v2.15.0 and is highly recommended over v1 usage.

The v2 has numerous new features and improvements over v1 such as debug logging,
lazy refresh, PSC connections, non-GDU environments, metrics and tracing, etc.

There is a migration guide that can be used to help with the CLI changes required to migrate.

Should also clean up any stale usage of v1 Proxy in this repo, which can be found by looking
for cloud_sql_proxy as the v2 Proxy binary is cloud-sql-proxy.

Activity

jackwotherspoon
added
priority: p2Moderately-important priority. Fix may not be included in next release.
type: cleanupAn internal cleanup or hygiene concern.
type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.
on Jan 31, 2025
jackwotherspoon
self-assigned this
on Jan 31, 2025
product-auto-label
added
samplesIssues that are directly related to samples.
on Jan 31, 2025
jackwotherspoon
linked a pull request that will close this issue on Feb 27, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

priority: p2Moderately-important priority. Fix may not be included in next release.samplesIssues that are directly related to samples.type: cleanupAn internal cleanup or hygiene concern.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

    Development

    Participants

    @jackwotherspoon

    Issue actions
      Upgrade Cloud SQL Proxy to v2 for tests · Issue #13123 · GoogleCloudPlatform/python-docs-samples