Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 121 to 130 of 45356 « Previous | Next »
Multi-Region MySQL on Kubernetes: Architecture Patterns for Global Scale

A deep dive into multi-region MySQL deployment patterns on Kubernetes, exploring replication models, failover strategies, and the operational trade-offs required to achieve global scale and resilience.

Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before)

You read this right, symbolic links (symlinks) are unsafe in MySQL since at least 8.0.39.  As always, it is a little more complicated than that, but if you are using symbolic links and in certain conditions, you risk a crash.  I think it is important to raise awareness on this, hence this post.

My attention was brought to this via the now private Bug #120156: MySQL 8.0.39/8.0.42

Auditing Login Attempts in MySQL and MariaDB

My colleague Miguel wrote about ways to audit login attempts in MySQL over 13 years ago, and this is still a relevant subject. I decided to refresh this topic to include some important changes since then.

Very often, it is important to track login attempts to our databases due to security reasons as well as to catch application misconfigurations. I’ll focus here on the most convenient ways to log authentication attempts. While auditing all client connections is usually pointless on busy production systems, when even thousands of new client sessions may be authenticating per second, let’s concentrate especially on the failed ones.

The Error Log

All MySQL and MariaDB variants have an easy way of logging failed authentication attempts in the standard error log via elevated log verbosity. To enable it, in older MySQL versions up …

[Read more]
Join the Public MySQL Community Discussion Webinar (Edition #3)

Following the strong participation in the first two editions of our Public MySQL Community Discussion webinar series, we’re excited to invite you to Edition #3. These sessions are part of our ongoing commitment to increase transparency, strengthen collaboration, and make it easier for the community to provide input that helps shape the evolution of MySQL’s. […]

50 SQL Interview Questions and Answers (2026 Advanced Edition)

We understand that tackling SQL interviews can feel challenging, but with the right focus, you can master the required knowledge. Structured specifically for the 2026 job market, this comprehensive resource provides 50 real, frequently asked SQL interview questions covering everything from basic definitions and data manipulation to advanced analytical queries and performance optimisation. Section 1: SQL […]

Celebrating 30 Years of MySQL: Free Training & Certification Results 

In 2025, MySQL celebrated its 30th anniversary—and to mark the milestone, Oracle University (together with the MySQL Community team) offered free MySQL training and free certification exams from April 20 through July 31, 2025.  The goal was simple: make it easy for developers, DBAs, architects, and newcomers to build practical skills and validate them with […]

Thanks AWS Open Source

I would like to thank AWS Open Source for their support.

For some time, I am maintaining Planet for the MySQL Community, a blog / news aggregator for the MySQL Community/Ecosystem.  I am also maintaining a similar aggregator for the Valkey Community.

Maintaining blog / news aggregators is not free.  It incurs hosting, domain registration, and other costs (in addition to time,

MySQL Tools for Performance Tuning and Test Data Generation

As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…

The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable.

How to fix write latency in MySQL 8.4 Upgrade

During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…

The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable.

How to Enable MySQL HeatWave Telemetry and Analyze Logs with OCI Log Analytics

MySQL HeatWave Service on Oracle Cloud Infrastructure (OCI) provides built-in telemetry and logging capabilities that help organizations monitor database activity, troubleshoot issues, and maintain operational health. These logs are valuable not only for operations and performance tuning, but also for governance and regulatory compliance, where audit logging can be essential for tracking database activity and […]