Planet MySQL HA Blog

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

Welcome MySQL 9.0, a review of Oracle’s stewardship in 8.0

Stewardship of a community is easy for new and emerging technology. After 29 years, MySQL has become one of the most-used and trusted open-source databases by millions of users worldwide. Leadership of a community at this scale can be complex. We strive to find a balance of stability and innovation, provide a stable and predictable […]

Learn More »

Extending MySQL Shell with Startup Scripts

MySQL Shell offers a wide variety of tools to manage our MySQL instances. With all those tools, though, we may want functionality that would be helpful and pertain to just your situation. Thankfully, the MySQL Shell team made it possible to extend MySQL Shell and add functionality. In this post, we will explore the use of […]

Learn More »

Start And Stop Your MySQL HeatWave And Compute Instances From The Command Line Using Oracle’s Command Line Interface

Oracle’s Command Line Interface (CLI) is a small-footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure (OCI) tasks. The CLI provides the same core functionality as the Console, plus additional commands. Some of these, such as the ability to run scripts, extend Console functionality. The CLI is built on the Oracle […]

Learn More »

How to partition tables with foreign keys in MySQL HeatWave (with a Work-Around)

Occasionally, a database schema design calls for a table with foreign keys to be partitioned.  However, this will not work with HeatWave because MySQL does not support partitioning tables that have foreign keys.  A quick clarification before proceeding any further: HeatWave is a fully-managed MySQL database service provided by Oracle Cloud.  In this article, I […]

Learn More »

MySQL Telemetry Metrics with OCI Monitoring Metrics Exporter

Overview OpenTelemetry Metrics provided by MySQL Telemetry provides insight into the performance, behavior, and health of your MySQL database. By exposing up to 400 unique MySQL internal metrics users can better – This is especially true at scale when 10s to 1000s of MySQL Databases are deployed across many data centers. And from a security […]

Learn More »

How To Use The Oracle Cloud Shell To Access MySQL HeatWave

MySQL HeatWave Database (HeatWave) is a fully-managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle.  For security reasons, the HeatWave instance does not have a public IP address, so you may only connect to the instance from inside the OCI network.  While you may connect to HeatWave (inside or […]

Learn More »

Quick And Easy Guide For Getting Started With HeatWave GenAI on Oracle Cloud Infrastructure

Oracle HeatWave GenAI provides integrated and automated generative AI with in-database large language models (LLMs); an automated, in-database vector store; scale-out vector processing; and the ability to have contextual conversations in natural language – letting you take advantage of generative AI without AI expertise, data movement, or additional cost. HeatWave Vector Store provides simple, fast, […]

Learn More »

Oracle ClouldWorld Keynote: Build Generative AI Applications—Integrated and Automated with HeatWave GenAI

Oracle recently announced HeatWave GenAI, enabling you to take advantage of generative AI without AI expertise, data movement, or additional cost. HeatWave GenAI provides in-database LLMs; an automated, in-database vector store; scale-out vector processing; and the ability to have contextual conversations in natural language.     At Oracle CloudWorld, Oracle’s Chief Corporate Architect Edward Screven […]

Learn More »

Data-driven, multilingual chat with HeatWave GenAI

Data-driven, multilingual chat with HeatWave GenAI   Chatbots boost operational efficiency and bring cost savings to enterprises while offering convenience and added services to internal and external customers. They allow enterprises to effectively resolve customer issues while reducing the need for human interaction.  Chatbots enable enterprises to proactively personalize and scale the content to a […]

Learn More »

HeatWave scale-out, high performant similarity search

HeatWave scale-out, high performant similarity search Enterprises are facing unprecedent challenges with the explosion of unstructured data such as documents in PDF and HTML formats. To analyze this vast amount of unstructured data for business operations, decision making and user experience, enterprises are turning to Generative AI advanced search techniques such as similarity search to […]

Learn More »