Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Galera Cluster vs InnoDB Cluster in MySQL 8.4 – preamble for SHOOTOUT webinar 15th of April

| Galera Cluster
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 »

Understanding Maintenance in HeatWave MySQL Service: A Deep Dive

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 »

Build an AI-Powered Search Engine with HeatWave GenAI (part 2)

| MySQL expert Diary

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 »

Announcement: HeatWave on AWS is now available in AWS US West (Oregon) and Asia Pacific (Seoul) regions

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 »

HeatWave Service: Proactive Backup Monitoring

This blog explores how to monitor HeatWave backups using OCI’s Monitoring and Alarm services and includes details on how to set up alarms that instantly notify the user in case of backup failures, enabling quick action.

Learn More »

Galera Cluster and Galera Manager on ARM / aarch64

| Galera Cluster
We were recently asked to support Galera Manager on ARM architectures (aarch64), and while we do support Galera Cluster on aarch64 for Galera Cluster Enterprise Edition (EE) in Galera Cluster for MySQL 8.0, we do not make such builds for our community release. This also means that for Galera Manager we are firmly just based […]

Learn More »

Doing a 'Incremental' Dump With MySQL Shell

In this post, we demonstrate how to perform an incremental dump of data using MySQL Shell by leveraging the `util.dumpBinlogs()` function.

Learn More »

Hytera Leverages MySQL Enterprise Edition to Enhance Equipment Performance and Boost Data Security

Based in China, Hytera Communications Corporation Limited is a global leader in providing innovative communications technologies and solutions. MySQL Enterprise Edition has enhanced both the performance and security of their systems, enabling them to deliver high-quality, reliable solutions to their customers. With MySQL’s competitive advantages, Hytera can continue to drive customer satisfaction and maintain its position as a global leader in mission-critical communications.

Learn More »

MySQL HeatWave as Vector Store and more with GenAI

In this article you will see how to create embeddings of your database's content and store those vectors in MySQL HeatWave. Then you will discover the power of HeatWave GenAI to RAG your data with LLMs

Learn More »

Automating Machine Learning with MySQL HeatWave Service: A Guide for DBAs & Developers