Showing entries 1011 to 1020 of 44805
« 10 Newer Entries | 10 Older Entries »
Using the Oracle Cloud TypeScript SDK Part 2 – Managing MySQL HeatWave Instances

This post is the second in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve information about a single MySQL HeatWave instance and how we […]

Using the component_keyring_file File-Based Keyring Component in MySQL

This is the second article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed MySQL’s effort in transitioning from keyring plugins to keyring components, the advantages of keyring components over keyring plugins and how to migrate from a keyring plugin to a keyring component. In […]

MySQL Shorts – Episode #56 Released

The latest Episode of MySQL Shorts is now available! Check out Episode 56 on the MySQL YouTube Channel to learn how to return tabular data as a list.

MySQL Shorts - Episode #56 Released

Episode #56 of MySQL Shorts in now available!

Using the Oracle Cloud TypeScript SDK Part 1 – Listing MySQL HeatWave Instances

This post is the first in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve a list of MySQL HeatWave instances for a given compartment. […]

Using the Oracle Cloud TypeScript SDK Part 1 - Listing MySQL HeatWave Instances

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.

Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024

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

Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024

Recap of the MySQL Belgian Days 2024

Introducing Keyring Components in MySQL

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

Three common MySQL database design mistakes

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 accommodated growth like this, but of …

[Read more]
Showing entries 1011 to 1020 of 44805
« 10 Newer Entries | 10 Older Entries »