Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Available now: OCI Database Management and Ops Insights for on-premises MySQL databases
We’re excited to announce the availability of Oracle Cloud Infrastructure (OCI) Database Management and Ops Insights services to monitor the on-premises (External) MySQL DB systems! Today, efficient database management is essential to deliver highly performant, reliable, and scalable applications. Database Management in OCI offers a cloud-native, comprehensive database monitoring solution which brings the capabilities of […]
Succeed with HeatWave – Part 1
HeatWave provides the simplicity of integrated, automated, and secure AI, transactions, and lakehouse-scale analytics in one cloud service. You can use a single HeatWave capability, such as HeatWave MySQL for example, and you can also take advantage of all the other built-in HeatWave capabilities at no additional cost—with great synergies when doing so. Moreover, you […]
Analyzing the Similarity of Spatial Trajectories in MySQL
Spatial trajectory data is becoming increasingly important in various fields, including transportation, ecology, sports analytics, and even human mobility studies. The ability to compare and measure the similarity of these trajectories can help in applications like identifying common travel patterns, detecting anomalies in movement, or optimizing routes based on historical data. A regular spatial data cleansing […]
Transforming GPS data into trajectories using MySQL
In this blog post, we will walk through how to transform timestamped GPS points into trajectories represented as LINESTRING geometries in MySQL. This process is essential for applications like route analysis, traffic prediction, and path similarity measures. Using MySQL’s powerful spatial support, we can efficiently manage, process, and visualize GPS data. This functionality is available in […]
Transformations between Spatial Reference Systems in MySQL
MySQL allows you to convert spatial data from one coordinate system, known as a Spatial Reference System (SRS), to another. This function is particularly useful when dealing with data from different sources or when you need to visualise data in a specific projection. In this blog post we will explain in detail how you can […]
Introducing the new CREATE_SPATIAL_REFERENCE_SYSTEM privilege in MySQL
Before MySQL 9.2.0 only users with the SUPER privilege were allowed to create or modify spatial reference systems (SRSs). That was inconvenient, especially for HeatWave MySQL where typically users do not have the SUPER privilege. MySQL 9.2.0 changes that by introducing a new dynamic privilege: CREATE_SPATIAL_REFERENCE_SYSTEM. This privilege enables users to create, replace, and drop […]
Introducing the Connection-Control Component in MySQL 9.2 : A Powerful Tool for Connection Management
Overview In a world where database performance and security are paramount, MySQL’s robust component architecture offers numerous ways to enhance and protect the customer’s data. Chief among them is the Connection-Control component now available in MySQL 9.2.0 for Community and Enterprise Editions, and HeatWave. This new component helps administrators manage and mitigate the risk of […]
Exporting query results to object storage with HeatWave
A new feature in HeatWave—the ability to write HeatWave query results to object storage—now makes it possible to use HeatWave also as a fast and flexible engine to transform data, build the silver or gold medallion layer of your lakehouse, create aggregates, perform format conversions, and enrich your data and make it available for use […]
MySQL January 2025 GA Releases Now Available
This January release is the fourth LTS release and third Innovation release since MySQL announced our move to a new LTS/Innovation release model. For more details see MySQL Releases: Innovation and LTS. During the innovation cycle, MySQL 9.x quarterly releases will include new features, deprecations and removals, and bug fixes. The 9.x releases also include […]
2024 Recap: Key Innovations and Enhancements in HeatWave MySQL
2024 was a productive year for HeatWave MySQL bringing powerful enhancements across the cloud and core database capabilities. From improved availability and disaster recovery to advancements in performance, system management, and operations, we achieved critical milestones that enhance scalability, efficiency, and ease of use. In this blog, we’ll recap some of the most impactful features […]