November 2023 Summaries

Introducing Insights Anomalies`: PlanetScale has launched a new feature in its database monitoring tool called Insights Anomalies, designed to simplify troubleshooting and ensure database health. The feature provides a graph representing the database's health over time, highlighting periods of performance anomalies with a red icon. Clicking on an anomaly reveals detailed information to help understand the causes of the issue. A threshold is calculated based on query response times exceeding two standard deviations above the mean for queries with similar patterns, providing a reliable indicator of when the database is pushed beyond its limits. The feature also includes troubleshooting metrics such as query counts, utilization, and backup requests, making it easier to identify bottlenecks. Additionally, correlated queries can be identified by calculating the Pearson correlation coefficient between execution rates and overall database health metrics.

We built a secure webhooks service by implementing multiple layers of defense to protect against server-side request forgery (SSRF), mitigating webhook SSRF's through strict URL validation, DNS resolution tests, and egress rules that limit HTTP connections. We also implemented rate limiting, uniqueness/locking, isolated infrastructure, set strict timeouts, and limited the number of webhooks to prevent abuse and ensure the reliability of our systems.

There are several surprising benefits to sharding a MySQL database beyond just increasing data throughput. By horizontally splitting the data across multiple servers, organizations can minimize the impact of failures, making it easier to manage maintenance tasks and reduce costs associated with scalability. Sharded environments allow for more efficient backup and schema migration processes, as well as reduced costs by utilizing commodity disks in cloud infrastructure, resulting in a more predictable and cost-effective approach to database management.

MySQL replication is a crucial step in providing high availability for MySQL databases. To ensure data is always available, proper configuration of replication is necessary. The best practice is to use an active/passive configuration, where one server acts as the source and all other servers are read-only replicas from that source. Using Global Transaction Identifiers (GTIDs) can help reduce the risk of data getting out of sync based on transactions not being processed or being processed more than they should. The correct replication mode, such as semi-synchronous replication, is also essential to ensure data consistency and minimize latency. Additionally, monitoring replication, creating a failover strategy, and considering replication across different regions are crucial considerations when configuring MySQL replication. By understanding these best practices and configurations, businesses can improve the reliability and performance of their MySQL databases.

This guide covers building HTML emails using Ruby on Rails and Tailwind CSS. It discusses how to overcome common obstacles such as Gmail message clipping, large file size, Apple autolinking, and more. The article provides a step-by-step approach to setting up the necessary tools and configuring PostCSS for email. It also covers how to create an email-specific stylesheet using Tailwind CSS and how to implement inline styles using a library called Roadie. Additionally, it discusses how to accommodate Gmail desktop styles and test emails on different platforms. The guide aims to provide a reference for those exploring how to build HTML emails in their own application using Rails and Tailwind.

Sharding is an effective method for managing large databases by dividing them into smaller, more manageable parts called shards. This approach not only enhances the overall performance of a database cluster but also helps in reducing infrastructure costs associated with basic database operations. By implementing cost-effective sharding strategies, engineers can efficiently handle massive data volumes while maximizing application performance and minimizing expenses.

PlanetScale has been named on the Deloitte Technology Fast 500, ranking 188th out of 500 fastest-growing companies in North America. The company's mission is to be the world's most advanced MySQL platform, providing scalability, performance, and reliability without sacrificing developer experience. PlanetScale has received numerous awards for its growth trajectory, workplace culture, and product innovation, including Fortune Best Small Workplaces and InfoWorld Technology of the Year. By leveraging its cutting-edge features, users can focus on their applications rather than database management. The company thanks Deloitte and its users for this recognition.

Vitess 18 is now generally available, offering various enhancements for usability, performance, and MySQL compatibility. The new release introduces support for foreign key constraints within shards, allowing for easier data import from existing MySQL databases with foreign keys. Additionally, the query planner has been significantly enhanced to provide better support for complex aggregations and derived tables. Other notable improvements include the migration of Vitess CLI to cobra, enabling auto-generated reference documentation and shell completion, as well as the introduction of VReplication and online DDL, which enable near-zero downtime data migrations and improved progress estimates. The release also includes features like tablet throttler with gRPC communication, a revamped benchmarking system, and point-in-time recoveries without relying on external binlog servers. Users are encouraged to try out the new release and provide feedback via GitHub issues or the Vitess Slack channel.

Fivetran has announced an integration with PlanetScale, allowing users to extract, load, and transform data from their PlanetScale databases using Fivetran's fully managed data integration capabilities. The integration is quick to set up and benefits from Fivetran's large ecosystem of connectors and destinations. It enables users to send their data to multiple destinations without building bespoke solutions, providing near-immediate access to insights from their database. This setup saves time for engineering teams, allowing them to focus on other tasks, while also enabling self-serve analytics capabilities in business areas outside of Engineering. The integration was built with Fivetran's Connector SDK and provides PlanetScale-specific documentation directly in the Fivetran UI.