Universally Unique Identifiers, also known as UUIDs, are designed to allow developers to generate unique IDs in a way that guarantees uniqueness without knowledge of other systems. These are especially useful in a distributed architecture, where you have a number of systems and databases responsible for creating records. You might think that using UUIDs as a primary key in a database is a great idea, but when used incorrectly, they can drastically hurt database performance. In this article, you'll learn about the downsides of using UUIDs as a primary key in your MySQL database. The many versions of UUIDs At the time of this writing, there are five official versions of UUIDs and three proposed versions. Let's take a look at each version to better understand how they work. UUIDv1 A UUID version 1 is known as a time-based UUID and can be broken down as follows:

While much of modern computing uses the UNIX epoch time (Jan 1, 1970) as its base, …

In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games. Then in MySQL 8.0.29 we added the possibility to add (or remove) a column anywhere […]

This blog post provides some recommendations for MySQL DBAs when using Instant DDL operations.

In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games.

Then in MySQL 8.0.29 we added the possibility to add (or remove) a column anywhere in the table.

For more information, please check these articles from Mayank Prasad : [1], [2]

In this article, I want to focus on some dangers …

Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!

The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.

Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL.In this blog post, we will discuss how […]

We previously announced support for Generative AI with the MySQL HeatWave vector store, currently in private preview. Today, we revealed more details about our vector store and generative AI implementation and announced several new capabilities, including support for a new VECTOR data type, integration with MySQL Shell and MySQL Shell for VS Code, an automated […]

Leading industry analysts react to MySQL HeatWave’s latest vector store and generative AI new capabilities (private preview), including support for a new VECTOR data type, integration with MySQL Shell and MySQL Shell for VS Code, an automated pipeline to ingest documents into the vector store, several options to use LLMs with MySQL HeatWave, the ability to combine Gen AI with machine learning, and more.

Generative AI is arguably the most important technology trend right now. It’s a transformative force that will have a significant impact on nearly every industry. This fast-moving disruption represents tremendous opportunities for developers to play a critical role in the evolution of almost every new and existing application.  Indeed, OnHires notes that “the demand for […]

Generative AI is arguably the most important technology trend right now. This fast-moving disruption represents tremendous opportunities for developers to play a critical role in the evolution of almost every new and existing application. MySQL HeatWave makes it easy to build upon your existing skills to become an AI developer with in-database machine learning and support for generative AI and vector store.