The latest from the MySQL community

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to list the MySQL HeatWave instances for a given compartment.

Our MySQL Belgian Days were a complete success. With 120 participants, the room was packed throughout the 2 days from the first to the last session. A record for this event ! The audience was made up of customers (some from very far away), users, contributors, community members and, of course, old friends. The atmosphere […]

Recap of the MySQL Belgian Days 2024

In this series of articles we will explore MySQL transition from keyring plugins to keyring components, the advantages of keyring components over keyring plugins, migration from keyring plugin to keyring component and steps to initialize and configure keyring components. Motivation Before MySQL 8.0, to add a feature to MySQL, writing a plugin was the only […]

Many years ago, I worked for a telematics company that ingested data from hundreds of thousands of devices worldwide. There was a point of incredible growth where we onboarded a customer that gave us a massive number of new devices and a huge bump in revenue. It was a great moment for the company's trajectory, but the increased amount of data being processed highlighted a massive flaw in our system.

The ID column of the data history table (which logged every event that occurred across all devices) was created with the INT data type, and it was quickly running out of space.

It wasn't an issue immediately, but if that column ran out of space, our entire system would come to a halt. Funnily enough, we built a quick tool called “the doomsday clock,” which would roughly calculate the date this would occur. Had we expected this, we would have designed the database with a different type that would have more easily …

Getting started with MySQL Server 8.3.0, upgrades are now supported in the MySQL Configurator for Windows.

Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster (PXC), where using tables without a primary key is not allowed by default. There are many […]

MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…

The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable.

We’re pleased to share the general availability of Bring Your Own Certificate (BYOC) in MySQL HeatWave Service (MHS) on Oracle Cloud Infrastructure (OCI). By default, all MySQL connections are secured through a MHS-defined certificate. BYOC extends the service by allowing users to select their own certificates to be used by the MySQL Server. With a […]

By default, all MySQL connections are secured through a MHS-defined certificate. BYOC extends the service by allowing users to select their own certificates to be used by the MySQL Server. With a few clicks, you can now set up your secured connections for MySQL HeatWave Service. The service facilitates both mutual TLS (requiring a connection wallet for the client) and one-way TLS, allowing clients to connect without necessitating a wallet.