Planet MySQL HA Blog

This blog will guide you through setting up and managing On-premises (External) MySQL DB systems in OCI, ensuring optimal performance and operational insights. In this part, we will cover the prerequisite steps before registering and managing External MySQL DB systems.

Learn More »

This blog outlines how to set up Oracle Heatwave MySQL disaster recovery copy for the production database using the OCI Console level full backup, copying the backup to another region, building the disaster recovery database from the primary backup and setting up the in-bound replication channel from primary to disaster recovery database.

Learn More »

Learn More »

In this latest post, the final part of my series on building an AI-powered search engine with HeatWave GenAI, I dive into enhancing AI-powered search by embedding full article content into HeatWave.

By cleaning HTML, chunking content, generating embeddings, and running semantic similarity searches directly within HeatWave, we unlock highly relevant, context-rich search results.
If you're building smart search engines or working with RAG pipelines, you’ll find practical tips and SQL-powered techniques you can apply right away.

This series demonstrates the powerful…

Learn More »

MySQL 8.0 will reach End-Of-Life (EOL) in April 2026. This means that HeatWave MySQL will no longer provide support or updates for MySQL 8.0 after this date. Customers should upgrade to newer supported version of HeatWave MySQL 8.4 LTS much ahead of the April 2026 deadline. This announcement is to provide customers with sufficient time to migrate their DB systems from 8.0 to the latest LTS release track. This article is exclusive to the cloud service version (HeatWave MySQL).

Learn More »

The first launch of your database is not the end; it is the beginning of Day-2 operations. Day-2 operations include critical, ongoing tasks such as rolling upgrades, patching, capacity scaling, and continuous performance tuning. These tasks are essential to ensure high availability, security, and performance of your production environments. Manual execution of Day-2 operations by […]

The post Automating Day 2 operations: Scaling, upgrades and maintenance appeared first on Severalnines.

Learn More »

MySQL 8.4 has two good options for High Availability clusters: Galera Cluster (and Percona XtraDB Cluster (PXC)) plus MySQL InnoDB Cluster. Both solutions are now mature enough, so what is the deciding factor? Workload characteristics, application compatibility (Galera is virtually synchronous; InnoDB Cluster offers 2 modes – single primary mode, which is one instance being […]

Learn More »

For users of HeatWave Service, the maintenance process can sometimes feel like a black box. What does it entail? How does it differ from version upgrades? When and how are updates applied? With questions like these swirling around, it’s time to unpack the mechanics of HeatWave maintenance and shed light on its purpose, scope, and flexibility. Whether you’re managing a production database or planning a deployment, this guide will help you navigate the process with confidence.

Learn More »

In this part 2 we focused on enhancing search relevance. We introduced reranking techniques using weighted distances of titles and excerpts to refine initial search results. Then we delved into leveraging article summaries for more effective semantic search, utilizing HeatWave's capability to execute JavaScript stored procedures for sanitizing HTML content and generating these summaries. Finally, we demonstrated how to create embeddings from these summaries and perform similarity searches, showcasing HeatWave GenAI's power for advanced information retrieval directly within the database.…

Learn More »

We are excited to announce that HeatWave on AWS is now available in the US West (Oregon) and Asia Pacific (Seoul) AWS regions, in addition to US East (N.Virginia), Europe (London), Europe (Frankfurt), Asia Pacific (Tokyo), and Asia Pacific (Mumbai).

Learn More »