Webhooks are now generally available
Webhooks have graduated from beta and are now generally available. Since the beginning of beta we've added an additional event which will trigger whenever a new Insights anomaly event is detected.
The latest PlanetScale features and product launches.
Webhooks have graduated from beta and are now generally available. Since the beginning of beta we've added an additional event which will trigger whenever a new Insights anomaly event is detected.
Our Hobby plan has now been retired. All remaining databases on the Hobby plan have been slept. To access your data, you must either upgrade to Scaler Pro or wake your database from your dashboard. Waking your database will give you 24 hours to dump your data. Please view our Hobby plan deprecation documentation for more information.
You can now enable webhooks for database anomalies. With this new hook you can notify your team when PlanetScale has detected slower than expected queries on your database.
The webhook event is branch.anomaly
and includes the full database branch information in the payload.
Deploy requests will now remember your auto-apply
setting. If you turn it off, all future deploy requests will default to the setting being off.
We’ve released an improvement to the billing page. You can now set spend alerts for your PlanetScale Organization.
To enable monthly spend alerts, go to your organization billing page, click "Enable spend alerts", and enter the maximum spend amount. Organization admins will receive an email once monthly spend hits 75% and 100%.
Our Hobby plan will be retired on April 8th, 2024. As of March 6th, 2024, you are no longer able to create new Hobby databases. Please view our Hobby plan deprecation documentation for more information.
We are now publishing the CPU and memory usage of each database branch's primary node to Datadog. You can graph these metrics by using the planetscale.primary.cpu_usage
and planetscale.primary.memory_usage
metric names within your Datadog widgets and notebooks.
Today, we’re releasing schema recommendations inside of PlanetScale Insights.
With schema recommendations, you will automatically receive recommendations to improve database performance, reduce memory and storage, and improve your schema based on production database traffic.
Schema recommendations uses query-level telemetry to generate tailored recommendations in the form of DDL statements that can be applied directly to a database branch and then deployed to production.
To enable foreign key constraints in any unsharded PlanetScale database, go to your database’s ”Settings” page and check the box to Allow foreign key constraints.
On the database’s ”Dashboard” page, you will see a loading spinner that says it is “Enabling foreign key constraints.” Once it no longer shows, you can use foreign key constraints in your PlanetScale database!
For most cases, foreign key constraints should work as expected in PlanetScale. There are a few cases to be aware of that are unsupported or result in less ideal behavior. You can read more in the limitations section of the foreign key constraints documentation.
If you don’t have an existing PlanetScale database and have an existing internet-accessible MySQL or MariaDB databases that use foreign key constraints, you can also import it into PlanetScale using our database import tool.
You can now enable safe migrations on development branches. With safe migrations enabled on a branch, you’ll gain zero-downtime schema migrations, schema reverts, and protection against accidental schema changes. Also, now you can use a development branch with safe migrations enabled to set up a workflow with a “staging” branch. Previously, only production branches could have safe migrations enabled.
OAuth applications are now available to all PlanetScale users in a public beta. An OAuth application in PlanetScale allows you to get authorization from your users for which organizations and databases the PlanetScale API can interact with.
If you are interested in building on top of PlanetScale and allowing your users to authenticate with PlanetScale to gain management access to their organizations and databases, you can create your OAuth application in your PlanetScale organization’s Settings > OAuth applications page.
We are committed to remaining the best database for serverless and real-world applications that require massive scale. To support this effort, we are deprecating the Scaler plan. Beginning February 12th 2024, you will no longer be able to create a new Scaler database clusters.
Read the announcement blog post for more information.
You can now use foreign key constraints inside of your PlanetScale databases. You can also import existing internet-accessible MySQL or MariaDB databases that use foreign key constraints to PlanetScale.
To opt-in an existing database, go to your database’s ”Settings” page and enroll on the ”Beta features” page. See the full documentation for more details about the beta.
Today, we released a new addition to PlanetScale Insights — Anomalies. Anomalies are defined as events where a percentage of slow-running queries substantially increases over a period of time.
The new Anomalies tab in Insights warns you of any anomalies that have occurred in the last 24 hours, with additional information about:
You can now extract data from PlanetScale and use it as a data source in your extract, load, and data transformation (ELT) processes with Fivetran.
It is available today in private preview to Fivetran users. You can request access to the PlanetScale connector from within Fivetran. See our Fivetran integration documentation for more info.
We have added webhooks to PlanetScale. With webhooks, you can trigger an HTTP POST callback to a configured URL when a specific event occurs within your PlanetScale organization. You can use webhooks from PlanetScale to build custom integrations, notifications, and automate other workflows.
Starting today, you'll receive a weekly email for your most active PlanetScale database that recaps from the previous week:
Initially, all users will be subscribed to weekly reports for the most active database in their organizations. You can unsubscribe directly from the email or in your user settings.
We are pleased to announce that PlanetScale Managed on AWS has been issued an Attestation of Compliance (AoC) and Report on Compliance (RoC), certifying our compliance with the PCI DSS 4.0 as a Level 1 Service Provider.
To learn more, check out the blog post.
PlanetScale Insights graphs just got an update! You can now zoom in on graphs for a more detailed look at branch metrics during a selected period.
For more information about Insights, see our Insights documentation.
Starting today, you can add an extra layer of security in connecting to your database by defining which IP addresses can connect to each database branch. Giving your organization the tools you need to operate your databases securely is a top priority, and IP restrictions, launching today in beta, are one additional way to provide an extra layer of security.
You can now view the details of your database’s passwords on a new page, including renaming a password, setting IP ranges that can connect to the database with the IP restrictions feature, copying and pasting pre-generated code, and more.
Find the page in your database’s “Settings” tab > “Passwords” section > select the password you want to see the details for.
Google Cloud Platform (GCP) regions in PlanetScale are now generally available in select regions, and read-only regions are now available in all supported GCP regions. As of today, there are 15 different regions across AWS and GCP where you can deploy your PlanetScale database.
For supported regions, see our regions documentation and see our read-only regions documentation to learn more about read-only regions in PlanetScale.
PlanetScale's latest SOC 2 Type II report covering the period of June 16, 2022 to June 15, 2023 is now available to customers. In addition to coverage over existing trust services criteria, the latest report includes additional controls mapped to the HIPAA Security Rule requirements.
To receive a copy of the report, please contact Support or visit our Trust Portal.
PlanetScale Boost is now available to all PlanetScale users in a public beta. PlanetScale Boost is a built-in database caching engine that requires no additional infrastructure, no cache invalidation, and up to 1,000× better query performance for your boosted queries.
If you are a current PlanetScale user, check your email for a “Welcome to PlanetScale Boost” email with a special coupon code to try out Boost today for free for a limited time.
We’re replacing our ‘Teams’ plan with a new ‘Scaler Pro’ offering that combines the best of our current plans and enterprise offerings for companies of all sizes. These plans allow customers to select exactly the resources they need for their workloads.
Scaler Pro databases are priced on a combination of resources (CPU and memory) and disk storage. Every database has a ‘cluster size’ encompassing the components that make up a PlanetScale database.
We just released an update to the PlanetScale UI database overview page. You now get a much more transparent view of what's happening under the hood with your PlanetScale database. This update surfaces important information about your database, such as:
For more information, see our Pulling back the curtain: the new database overview page blog post.
We have added a new Amazon Web Services (AWS) region. Now you can deploy databases on AWS in us-east-2 (Ohio).
For more information about our supported regions, see our documentation.
We have added a new Google Cloud Platform (GCP) region (in beta). Now you can deploy databases on GCP in Seoul, South Korea (gcp-asia-northeast3
)
For more information about limitations and supported regions, see our GCP documentation.
PlanetScale Insights now shows time-series metrics on a per-query pattern basis to help developers identify and troubleshoot problematic queries.
Read how the PlanetScale Engineering team used this feature to troubleshoot a query in our primary production database.
We’ve updated our status page to a new provider, enabling a streamlined incident workflow.
Historical availability events have been populated and the page is available at https://www.planetscalestatus.com.