This post will explain how you can start and stop your MySQL Heatwave and compute instances from the command line using Oracle's Command Line Interface tool.

We are excited to announce that Vitess now supports recursive Common Table Expressions (CTEs), marking another significant step in our journey to fully align with MySQL’s capabilities. Recursive CTEs, often a critical feature for complex query handling, allow for the execution of recursive queries within a single CTE. This addition brings more flexibility and power to developers using Vitess, especially those working with distributed databases. One of the key challenges in implementing recursive CTEs within a sharded environment is managing the distribution of data across multiple shards.

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 […]

A work-around for partitioning MySQL tables with foreign keys is described in this article.

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 […]

OpenTelemetry Metrics provided by MySQL Telemetry provides insight into the performance, behavior, and health of your MySQL database - exposing up to 400 unique MySQL internal metrics

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 […]

This is a quick guide on how to use the Oracle Cloud Shell on the Oracle Cloud Infrastructure console to access MySQL HeatWave via MySQL Shell.

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 […]

Percona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also create Kubernetes pods to run Percona Toolkit operations there instead if you do not […]