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

This article explains the SIGNED and UNSIGNED integer data types in MySQL and provides examples to illustrate when and how to use these integer data types effectively.

The post MySQL INT (INTEGER) Data Types with Different Examples appeared first on Devart Blog.

The article covers the basic syntax of the MySQL INSERT statement and explains how to work with the INSERT command in the MySQL table using dbForge Studio for MySQL.

The post MySQL INSERT Statement – Inserting Rows Into a Table appeared first on Devart Blog.

As we already announced back in August, there are several MySQL meetups planned for this fall. Some of them already happened, please find quick report out of them on the bottom of the page. Also please register yourself for any of the below planned meetups. We are looking forward to seeing & talking to you! […]

In current times, there is a high degree of focus on ensuring the availability and recovery of your production data. This can be challenging at times when using DBaaS solutions in the public cloud space, for example, when using AWS Aurora. Relying solely on a single cloud provider for database services can pose significant risks. […]

Well, that is more a catchy headline, than the reality: XA transactions work in your Galera Cluster Enterprise Edition (EE). This has been supported since our very first release with 8.0.28 Enterprise, right up till now, in 8.0.39 Enterprise. If you try to run an XA transaction in your regular Galera Cluster you’ll be given an error as such:

mysql> XA START 'xatest';
ERROR 1235 (42000): This version of MySQL doesn't yet support 'XA with wsrep replication plugin'

However, with Galera Cluster Enterprise Edition (EE), XA transactions, “just work”. What is an XA transaction, you might ask? An XA transaction is a distributed transaction …