PlanetScale

Changelog

• 4ef3fff34dadc377e530afc13bd108271d80f4fa Add processlist show and processlist kill for Vitess
• 444ca62adf75c993fc1747a56120e22be71de049 Fix TestMoveTablesCancelWithFlags to include required --keep-routing-rules flag
• c6421c0274efb4a031167491353add748aa3b4e7 Merge remote-tracking branch 'planetscale/main' into maxeng-required-movetables-args Signed-off-by: Max Englander max@planetscale.com
• 91ef485e75eaaf951be0dc841ee9726619234682 Remove accidentally committed pscale-test binary
• 38b7f33801175236d8c82ea8b9e008ded7df0bc5 Require --keep-data and --keep-routing-rules for move-tables complete and cancel
• 2d1ec03575012cfed3a898cf3e8ec90ebb87c2bd [Fast lane] Support strategy in deploy requests cli
• fe6e1e12b11db4c1e538bbc3f7b90aa7e35381fa feat: allow to specify name when creating backup
• 297dcf934ef956dd892ad7b4f0ddfb6cd350f5c8 handle csv
• d08705c73c97526e0fc7530d4e7857c0384d0015 handle not found

What's Changed

• Add types/request for vitess show process list by @mscoutermarsh in https://github.com/planetscale/planetscale-go/pull/312

Full Changelog: https://github.com/planetscale/planetscale-go/compare/v0.166.0...v0.167.0

We've updated the Postgres roles page with new search and filter options. You can now:

• Search roles by name or username
• Filter roles by state
• Filter roles by branch

These options are available in the dashboard and through the API, making it easier to find and manage roles across your Postgres databases.

We've released an improvement to organization SSO settings. Organization administrators can now verify ownership of their email domains before configuring single sign-on. Domain verification is managed through WorkOS.

Organization members who sign in with an email on your verified domain are automatically added to your organization.

Read more

What's Changed

• Support strategy in deploy requests cli by @eileencodes in https://github.com/planetscale/planetscale-go/pull/311

New Contributors

• @eileencodes made their first contribution in https://github.com/planetscale/planetscale-go/pull/311

Full Changelog: https://github.com/planetscale/planetscale-go/compare/v0.165.0...v0.166.0

Changelog

• 6973c9a221d316667acb80ff27c455088f834e1a Add throttler subcommands to branch vtctld
• c96bf3aecd626a35a628db98d3d3b29ae2bc2790 Apply SessionVars to initPool
• 8da8c88d0e856ae8a8058d3bfb026c0fb158a990 Merge branch 'main' into apply-session-vars-init-pool

What's Changed

• Add throttler client methods to VtctldService by @nickvanw in https://github.com/planetscale/planetscale-go/pull/310

Full Changelog: https://github.com/planetscale/planetscale-go/compare/v0.164.0...v0.165.0

We shipped an improvement to deploy requests. Now, if the cutover phase of a deploy request is delayed due to long running transactions, a "force cutover now" option will be available. It will aggressively stop running transactions to allow for the schema cutover to happen. If you find yourself regularly needing to force cutover, you can enable the "aggressive cutover" option in your database settings to make this the default behavior for all deploy requests. Read more

Changelog

• a53cbea7ce6720c6b3589b5a8a79ac09f287dbf1 Update move table cancel to use async operation

What's Changed

• ci: pin actions/checkout to SHA by @bwarminski in https://github.com/planetscale/planetscale-go/pull/308
• implement schema recommendation API by @mcrauwel in https://github.com/planetscale/planetscale-go/pull/307
• Update MoveTables Cancel to async by @no-itsbackpack in https://github.com/planetscale/planetscale-go/pull/309

New Contributors

• @bwarminski made their first contribution in https://github.com/planetscale/planetscale-go/pull/308
• @mcrauwel made their first contribution in https://github.com/planetscale/planetscale-go/pull/307

Full Changelog: https://github.com/planetscale/planetscale-go/compare/v0.163.0...v0.164.0

You can now create and delete PlanetScale databases directly from your Terraform configuration. Applying a planetscale_postgres_branch or planetscale_vitess_branch creates the parent database if it doesn't already exist. Destroying the last branch in a database deletes the database. Read more in the docs.

Weekly database reports are now available for PostgreSQL databases. Each week, you'll receive an email recap for your database covering: Anomalies — unusual patterns detected in your database activity Most expensive queries — top queries ranked by total execution time, with query count, p99 latency, and cache hit ratio Schema recommendations — suggested index and schema improvements to optimize performance Traffic control — queries that were throttled or warned during the week Storage — current database size and week-over-week delta CPU and memory — daily average CPU and memory usage You can manage which databases you receive reports for in your user settings.

Changelog

• f7f9979f3626e6c38c1da2f2894a323953020b7c Require tablet-types for switch-traffic
• d2c958750e42ce36372db39518679f9206f1a57c update tests

Changelog

• 66476cf1d71f336f7176a7bcd9616374dcdc6ed5 Add tenant-id to movetabels

Query Insights search now supports negated filter terms for both Postgres and Vitess. Prefix any search term with ! to exclude matching results — for example, !table:users returns all queries that don't touch the users table, and !indexed:true surfaces unindexed queries. Positive and negative terms can be combined freely: p99:>100 !table:sessions finds slow queries that don't involve the sessions table. Negation applies to the token immediately following !, so quoted phrases work too — !"some text" excludes queries matching that phrase, while "!some text" treats the exclamation mark as a literal character when searching for queries that include it in the normalized SQL. Read more about filtering queries with Vitess or filtering queries with Postgres.

What's Changed

• Add a 14 day dependency cooldown to the Dependabot config by @Sinjo in https://github.com/planetscale/planetscale-go/pull/304
• Add tenantid to movetables by @mscoutermarsh in https://github.com/planetscale/planetscale-go/pull/305

New Contributors

• @Sinjo made their first contribution in https://github.com/planetscale/planetscale-go/pull/304

Full Changelog: https://github.com/planetscale/planetscale-go/compare/v0.162.0...v0.163.0

We have added a new GCP region. Now you can deploy Postgres and Vitess databases on GCP in Eemshaven, Netherlands (gcp-europe-west4). For more information about supported regions, see our regions documentation.

Changelog

• eb7c0085a523e08e17a88879bf70ccbc50876b3c Add a 14 day dependency cooldown to the Dependabot config
• f879b92f1542f29bd4b3e8a5a927daca0b39d112 Chain buildx setup into base goreleaser-cross entrypoint
• 7abdf801c8eb15449c9ef5375390ce46fb58469e Create buildx builder inside releaser container
• c343767fcffa1ee241c7e267698e0bdd4b97e7c6 Publish multi-arch Docker image (linux/amd64 + linux/arm64)

You can now configure storage when you create a PlanetScale Postgres database. For Postgres databases using Amazon Elastic Block Storage (EBS), you can now set storage size during database creation. This is available in the web dashboard, the API, and the CLI. API: Create databaseCLI: pscale database create

Changelog

• cfa31fcaf86c19ec1e03e511c1b3aa714591a939 Add --min-storage and --max-storage flags to database and branch creation
• 7f611093330d6e84f7594d1c9cfe15c0061f956d Handle async MoveTables Create
• 1fc64babf5eb5b9ad18216fd23bc3c4cad13836a Update planetscale-go to v0.161.0