Planet MySQL Blog - Software

Galera Cluster for MySQL 8.0.36-26.18 released | Galera Cluster for MySQL

The world's most advanced open source database cluster

MySQL 8.4 First Peek

Dave Stokes does a quick review of the release notes for MySQL 8.4, now that it's been officially released.

MySQL 8.4 LTS – new production-ready defaults for InnoDB – lefred blog: tribulations of a MySQL Evangelist

Yesterday, MySQL 8.4, the very first LTS version of MySQL was released. A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications. The default value of 20 InnoDB variables has been modified! Let's have a look at those variables and explain…

Easily Validate MySQL Configuration Settings in MySQL 8.0

MySQL 8.0.16 introduces the 'validate-config' option, providing a seamless solution for MySQL configuration validation. Learn everything you need to know here!

Vitess | Scalable. Reliable. MySQL-compatible. Cloud-native. Database.

How we implemented a consistent lookup Vindex in Vitess to ensure data consistency without using 2PC

The MySQL adaptive hash index

The adaptive hash index help to improve performance of the already-fast B-tree lookups

MySQL: Latency and IOPS | Die wunderbare Welt von Isotopp

When COMMIT Is the Slowest Query

When COMMIT is the slowest query, it means your storage is slow. Let’s look at an example.

Did MyDumper LIKE Triggers?

Learn to use the LIKE clause effectively to filter triggers or views from specific tables, plus a link to a fixed mydumper bug that inspired this insight.

How to Find and Fix a Slow MySQL Query Effectively

In this blog, our experts provide tips on finding slow queries in MySQL and tuning them for better performance with Percona Monitoring and Management (PMM).

MySQL Foreign Keys: Create, Display and Remove With Ease

Here is your step-by-step guide to mastering MySQL foreign keys. Discover how to create, view, and delete foreign keys in MySQL, making database management simple and effective using a GUI client for MySQL.

A Guide to Better Understanding MySQL Charset Levels

Understanding Charset levels in MySQL, especially in light of the deprecation of utf8mb3 and the adoption of utf8mb4 as the new default.

Profiling memory usage in MySQL

Learn how to visualize the memory usage of a MySQL connection

17 Years of Insecure MySQL Client ! | J-F Gagné's MySQL Blog

Yes, this is a catchy title, but it is true, and it got you reading this post :-).  Another title could have been “Please load this mysql-du...

Percona Monitoring and Management Setup on Kubernetes with NGINX Ingress for External Databases

Since the PMM server and client communication require the use of the gRPC framework, it needs to be enabled when adding the NGINX ingress controller to our Kubernetes setup.

Vitess | Scalable. Reliable. MySQL-compatible. Cloud-native. Database.

My experience working as an intern in the Vitess query serving team for PlanetScale

Ask Me Anything About MySQL 5.7 to 8.0 Post EOL

Discover the implications of MySQL 5.7 reaching EOL and the transition to MySQL 8 with insights from Vinicius Grippa. Learn how users are adapting to MySQL 8 and how Percona supports this significant database version upgrade.

dbdeployer Tutorial on Mac | J-F Gagné's MySQL Blog

Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested m...

caching_sha2_password Support for ProxySQL Is Finally Available!

ProxySQL 2.6.0 brings exciting news for MySQL 8 users with the addition of caching_sha2_password support. Enhance security and performance with this new authentication method.

How to implement transaction management in MySQL

Michael McLaughlin's Technical Blog

Identifying and profiling problematic MySQL queries

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.

MySQL Delete Duplicate Records: A Practical Tutorial with Examples

Learn how to remove duplicate rows in MySQL using DELETE JOIN, Temporary Table, GROUP BY, and ROW_NUMBER(). Includes GUI tool tips for easy data management. Essential for database optimization

Galera Manager March 2024 Release now includes UI improvements and a SSH console tab | Galera Cluster for MySQL

The world's most advanced open source database cluster

How to Install and Use MySQL 8 on Ubuntu 22.04

MySQL is a free, open-source, relational database management platform powered by Oracle Cloud. This tutorial will show you how to install MySQL 8 on U...

How Missing Primary Keys Break Your Galera Cluster

Any Galera documentation states that missing primary keys are not properly supported. What is the actual risk, and what are the symptoms?

SSH Connection to a MySQL in a DigitalOcean Droplet – A Step-by-Step Tutorial

Guide to connecting MySQL databases via SSH in DigitalOcean Droplets. Explore the benefits of GUI tools for simplified database access.

Galera Cluster for MySQL 8.0.36 released | Galera Cluster for MySQL

The world's most advanced open source database cluster

Javascript support in MySQL: the UUID example – lefred blog: tribulations of a MySQL Evangelist

You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network (OTN): MySQL Enterprise Download. I also recommend you look at…

The problem with using a UUID primary key in MySQL

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.

MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know – lefred blog: tribulations of a MySQL Evangelist

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…

Percona XtraBackup 8.0.28 Supports Encrypted Table Backups with AWS KMS

Percona XtraBackup version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service.

Champs Recap: Devart's Award-Winning Products in Q1 2024 - Devart Blog

Read on to learn all about the awards and badges collected by dbForge products over Q1 2024!

Percona Operator for MySQL Now Supports Automated Volume Expansion in Technical Preview

Percona Operator for MySQL 1.14 introduces automated volume expansion (technical preview), allowing users to expand storage volumes without manual intervention or risk of human error.

Master MySQL Point In Time Recovery - ScaleGrid

MySQL Point in Time Recovery (PITR) enables restoration to a specific point after a backup. It relies on binary log files to record changes needed for recovery.

Vitess | Scalable. Reliable. MySQL-compatible. Cloud-native. Database.

Vitess 19 is now Generally Available

Help Us Improve MySQL Usability and Double Win!

Help us make sure Percona Server for MySQL and other Percona products have the highest level of usability possible. Take our survey for a chance to win!

MySQL install ‘n’ config one-liners | MySQL-Med

I've been installing and configuring InnoDB Clusters and ClusterSets and thinking about the Ansible and Terraform users amongst us, maybe one-liners might help someone out there.

Highlights from the Newly Released MySQL Server 8.3.0

Discover the latest release of MySQL Server 8.3.0. Dive into new features, security enhancements, and performance improvements to optimize your MySQL experience.

MySQL Change a Column Type: Detailed Syntax Guide and Examples

Explore MySQL Change a Column Type: A complete guide covering everything from basic syntax to specific examples like INT to VARCHAR, changing VARCHAR length, and more, with a focus on using GUI tools. Understand critical factors in the column type changing process and how to leverage GUI for seamless database updates.

How to avoid data loss in MySQL Primary Key change

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.