XIO

xWire

Posts from every feed QUEST has found across the web — blogs, news, podcasts, channels and more.

Changelog — PlanetScale

The latest PlanetScale features and product launches.

MCP server: Branch metrics

The PlanetScale MCP server can now check your database's metrics. planetscale_get_branch_metrics pulls CPU, memory, disk, replication lag, and connections into your AI assistant, so you can see those numbers without leaving your editor.It works for Vitess, Postgres, and Neki. The default summary covers the last hour and includes current disk and connection numbers. Memory utilization includes page cache, so the summary also includes RSS and cache. Query-level stats stay on Insights.Ask…

Retry a partially failed deploy request

Vitess deploy request's now have the ability to recover from partial failures. If part of a migration has failed, the deploy request page will now provide the option to retry the failing tables instead of starting the entire deploy over.Retry will restart the migration for only the failed tables. Tables that already healthy will keep their existing progress.From the CLI:pscale deploy-request retry <database> <number> Read more

Limit MCP query access for an organization

Organization administrators can now limit the database query access members grant to MCP clients. In organization settings, MCP query access can be set to no query access, read-only queries, or read and write queries.This applies the next time someone authorizes an MCP client. A member's role still limits which permissions they can grant, and clients that were already authorized keep the access they have. Query permissions the organization does not allow will show as unavailable on the…

Postgres dedicated read replicas

PlanetScale Postgres now supports independently configurable dedicated read replicas.Create one or more dedicated read replicas in the primary region or another region from the same cloud provider. Configure the cluster size, replica count, storage, and supported Postgres parameters independently from the primary cluster.Manage dedicated read replicas from the dashboard, API, CLI, or Terraform.Read the dedicated read replicas documentation

Change Vitess keyspace parameters from the CLI

We've added pscale keyspace parameters to the CLI. You can now view and change the VTTablet and MySQL parameters of a Vitess keyspace from your terminal.pscale keyspace parameters set mydb main mydb --org acme \ --parameters vttablet.vreplication-parallel-insert-workers=4 \ --parameters mysqld.wait_timeout=600 pscale keyspace parameters list shows each parameter with its current and default values. pscale keyspace parameters changes list shows each change as it rolls out. Pass --reset to set a…

New reparent metrics for Prometheus

We've added two Prometheus metrics that show when a shard's primary changed, and why:planetscale_vitess_planned_reparents_total counts planned reparents, such as the ones that happen during maintenance or when you request one.planetscale_vitess_emergency_reparents_total counts emergency reparents, where a replica was promoted to recover from a failed primary.Both count successes and failures, split by the planetscale_reparent_result label. The planetscale_component label tells you which…

Schema recommendation webhooks for Postgres

branch.schema_recommendation webhooks will now fire for Postgres databases when PlanetScale creates a new schema recommendation.Set a custom Authorization header on the webhook and those deliveries can start a Cursor or Devin agent automatically. PlanetScale sends the authorization_header value as the HTTP Authorization header on every delivery. That works with Cursor Automations, background agents, and Devin sessions.View all webhook eventsRead more about the Authorization header

Set a development branch limit

You can now control how many development branches a database is allowed to have. The default is 100.You'll find the setting on the Settings page for your database. If you hit the limit, delete unused development branches or raise the cap before creating more. You can set the limit from 1 to 5,000.Vitess system limitsPostgres branching

TIN 1.0.4: word stemming and score tie-breaking

TIN 1.0.4 is now available for PlanetScale Postgres.Word stemming. Create a TIN index with WITH (stemmer = 'en') to match inflected words as the same term. A query for runs also matches run and running. Stemming is optional, per index, and supports 18 Snowball languages. See index options.Score tie-breaking. Ranked searches can keep a bounded top-k scan when you add more ORDER BY keys after tin.score(ctid). Use a unique key such as id so equal-score rows stay in a stable order. See scoring.To…

Import your MySQL database with the pscale CLI

You can now import an existing MySQL database into PlanetScale Vitess with no downtime from the pscale CLI. Connect your database to a production branch as an external keyspace, then move its tables into PlanetScale with a Vitess MoveTables workflow. Your database keeps serving traffic while the data copies and replicates, and you switch reads, then writes, when you're ready.pscale keyspace create-external mydb main mydb_source \ --host db.example.com \ --source-database mydb \ --username…

New move-tables commands replace pscale workflow

Run Vitess MoveTables workflows from the pscale CLI with pscale branch vtctl move-tables:list shows the workflows on a branch, across every keyspacecreate starts copying tables into a target keyspacestatus shows copy progress and which keyspace is serving trafficstart and stop resume or pause a workflowswitch-traffic and reverse-traffic move reads and writes to the target keyspace, or backcomplete finishes a workflow, and cancel abandons one that's still in progressVerify your data before you…

See and revoke installed OAuth apps

Organization administrators can now review the third-party OAuth apps that have access to their organization. Open Settings > OAuth applications, then the Installed tab. You'll see each app, how many people authorized it, and when it was last authorized.Open an app to see the permissions it currently has on your organization, databases, and branches, along with who authorized it. Revoke access removes that app's access to this organization only. It does not change its access to other…

New container restart metrics for Prometheus

We've added two Prometheus metrics for container restarts and deprecated planetscale_pods_container_restarts_total.The old counter had a bug. Its planetscale_restart_reason label described only the container's most recent termination, not the restarts being counted. When that label changed, or a failover changed the role label, the series split and rate() and increase() reported restarts that never happened or missed ones that did. The counter also didn't exist until a container's first…

Per-shard sizing for Vitess

We've added the ability to adjust VTTablet sizes for individual shards in a Vitess keyspace. Enable per-shard sizing on the keyspace Shards tab, then set a cluster size on any shard. Shards you don't change will keep using the keyspace default.This lets you give a shard more CPU and memory than the rest of the keyspace, or more local storage on Metal, instead of resizing every shard at once. Enabling per-shard sizing will not change key ranges, VSchema, or routing.Read more

Create and resize external Vitess keyspaces

You can now attach an existing MySQL database as an external keyspace on a Vitess production branch. PlanetScale runs an external tablet against that source so you can query it through Vitess without importing the data first.External keyspaces can be created from the Clusters page on production branches and through the CLI using the command below:pscale keyspace create-external mydb main commerce \ --host db.example.com \ --source-database commerce \ --username import \ --password secret \…

Manage Neki extensions with Terraform and the CLI

You can now manage Neki extensions by name in Terraform and the pscale CLI, and change their settings in the same update.TerraformEnable pgvector with extensions and configure it with parameters:resource "planetscale_neki_configuration_profile" "analytics" { organization = "acme" database = "app" branch = "main" name = "analytics" extensions = ["vector"] parameters = { pgconf = { "hnsw.ef_search" = "100" } } } The list replaces the currently enabled extensions. Omit extensions to leave them…

Lead: run full-text search queries in your CI

We've just released a second full-text search extension for Postgres, called Lead. This one's open source, so you can run it in your CI, dev, and staging environments, even fully offline. It has the same features as TIN, the full-featured, highly performant full-text search extension we announced yesterday. But beware: expect Lead to become slow as indexed text grows beyond a few MB. It's great for tests. Stick with TIN for production.

Control shard rollout concurrency per keyspace

You can now control how many shards in a Vitess keyspace PlanetScale updates concurrently during a configuration rollout.Keyspaces use a default concurrency of 1. Set a value from 1 to 32 to shorten rollouts for keyspaces with many shards while choosing how many shards change at the same time.View or update the setting with the pscale CLI:pscale keyspace settings <database> <branch> <keyspace> pscale keyspace update-settings <database> <branch> <keyspace> --max-rollout=4 The setting is also…

Run Vitess MoveTables from the pscale CLI

You can now run Vitess MoveTables workflows from pscale with pscale branch vtctld move-tables. Use it to copy tables between keyspaces, watch copy and traffic state, switch replica then primary traffic, and complete or cancel the workflow.JSON output includes a helpful next_steps field with a suggested next command.pscale branch vtctld move-tables list mydb main --org acme --format json pscale branch vtctld move-tables status mydb main --org acme --workflow commerce2customer --target-keyspace…