PlanetScale
PlanetScale is a fully-managed MySQL database platform built on Vitess, offering features like non-blocking schema changes, branching workflows, and real-time query caching.
PlanetScale Services
PlanetScale is a fully-managed MySQL database platform built on Vitess. The platform provides various features including non-blocking schema changes, ensuring zero downtime during updates. It also offers a branching workflow similar to code branching, which enables isolated development environments. PlanetScale supports horizontal sharding that facilitates database scaling without any application-level changes. The PlanetScale Boost feature provides real-time query caching with automatic cache invalidation, enhancing query performance and efficiency.
Key Features of PlanetScale
PlanetScale offers several innovative features such as Data Branching®, which allows for the creation of development branches with data from another branch. The platform also includes Insights for real-time query performance monitoring and anomaly detection. Moreover, PlanetScale supports online schema changes using tools like `pt-online-schema-change` and `gh-ost`. The databases are AES encrypted both in transit and at rest, ensuring robust data security. The SOC 2 Type II compliance and optional HIPAA compliance for enterprise customers further bolster compliance and security. PlanetScale Managed is available for single-tenant deployments, and it includes PCI DSS compliance when deployed on AWS.
Security and Compliance at PlanetScale
PlanetScale places a strong emphasis on security and compliance. The platform ensures AES encryption for databases both in transit and at rest. It holds SOC 2 Type II compliance and offers HIPAA compliance for enterprise customers. Additionally, PlanetScale can enter into Business Associate Agreements (BAAs) with enterprise clients. The PlanetScale Managed offering on AWS is PCI DSS compliant, ensuring the secure handling of payment data. Multi-factor authentication and single sign-on (SSO) are supported for enhanced security measures.
PlanetScale Deployment and Integration
PlanetScale offers robust deployment and integration options. The platform provides a no-downtime import tool for migrating databases from other platforms like Amazon Aurora, facilitating a smooth transition. It also supports a CLI and API for programmatic interaction with the database platform. PlanetScale Deploy Requests enables safe, non-blocking schema changes with the capability to revert changes if necessary. The platform offers schema recommendations to enhance database performance and reduce memory and storage usage. Additionally, read-only regions support globally distributed applications, ensuring low-latency data access.
PlanetScale Tools for Database Management
PlanetScale provides various tools to simplify database management. PlanetScale Connect facilitates easy data extraction, loading, and transformation (ELT) processes. The platform's branching workflow for databases helps developers create isolated development environments, similar to code branching. Insights enable real-time query performance monitoring and anomaly detection. Horizontal sharding support allows databases to scale efficiently without requiring application-level modifications. The platform's Deploy Requests feature ensures safe and non-blocking schema changes, and the Boost feature offers real-time query caching with automatic cache invalidation.