Planet MySQL HA Blog

This blog introduces HeatWave, a cloud service that integrates AI, transactions, and analytics in a single solution, with a focus on HeatWave MySQL. It outlines common challenges faced by businesses using MySQL. The blog also highlights use cases across various industries and provides a step-by-step migration program for businesses looking to move to HeatWave MySQL. Overall, it emphasizes HeatWave’s ability to improve performance, reduce costs, and simplify database management for MySQL users.

Learn More »

In this blog post, we will explore how to use MySQL's spatial features to analyze the similarity of trajectories. We will focus on key metrics such as Frechet distance, which measures the similarity between two trajectories, and other geometric operations that help quantify how closely different paths align. This functionality is available in MySQL Community and Enterprise Editions and HeatWave MySQL.

Learn More »

Transforming GPS coordinates into trajectories in MySQL involves organizing raw GPS points (as POINT geometries) into ordered paths and converting them into LINESTRING geometries. This process uses MySQL's spatial functions like ST_Collect to aggregate points and requires ensuring proper ordering (e.g., by timestamp or sequence) to construct accurate routes.

Learn More »

This blog post explores how to transform spatial data between different Spatial Reference Systems (SRS) in MySQL using the ST_Transform function. It covers the syntax and usage of ST_Transform, and its practical applications in mapping and spatial analysis by using demonstrative examples. Whether you're visualizing geographic data or integrating datasets from various sources, understanding SRS transformation is key to accurate spatial analysis.

Learn More »

MySQL 9.2.0 has introduced a new dynamic privilege: CREATE_SPATIAL_REFERENCE_SYSTEM. This privilege enables users to create, replace, and drop custom spatial reference systems (SRS), allowing for greater spatial data customization across MySQL environments without needing SUPER access. In this post, we’ll explain the use of this privilege and provide an example to demonstrate its application. The new privilege is available in MySQL Community and Enterprise Editions and HeatWave MySQL.

Learn More »

The MySQL Connection-Control Component allows database administrators to enforce limits on client connections based on frequency and behavior. It is especially useful in preventing denial-of-service (DoS) attacks, mitigating resource exhaustion, and regulating access during high-load scenarios.

Learn More »

We take a look how you can use HeatWave to build your medallion data lake, transform data, create aggregates, perform format conversions, and enrich your data and make it available for use by HeatWave or other applications. HeatWave can write results of queries to object storage in standard formats like CSV or Parquet. This data can then be used by other applications or loaded back into HeatWave as tables, opening up new classes of applications and workloads that can be powered by HeatWave.

Learn More »

MariaDB Server comes with MariaDB Galera Cluster built-in, and it has a new release model, and a lot of new Galera Cluster features, since the replication layer within MariaDB Server is also rapidly changing. Come learn how about the new features, and how to use:

* vectors with Galera Cluster
* mix asynchronous replication with wsrep replication of Galera Cluster
* use features like system versioned tables with Galera Cluster
* allowlist for IST/SST requests in Galera Cluster
* the JSON interface

Learn More »

MySQL January 2025 GA Releases Now Available

Learn More »

Learn More »