As of 2024, MySQL ranks as the second most popular database management system globally.

MySQL has become a go-to choice for database management due to its dependable performance, stability, and open-source licensing.

However, its popularity also brings significant security challenges like SQL injection attacks and unauthorized data access.

As cyber threats evolve, protecting MySQL infrastructure is more critical than ever. Advanced tools like ProxySQL are vital for addressing these issues. ProxySQL is a high-performance, open-source SQL proxy tailored for MySQL and other database systems sharing the same protocol. It optimizes database traffic by managing queries more efficiently and enhancing performance and security by supporting …

I have been looking into “dolphie” lately, and have to say, “thanks Charles!”. I actually first saw dolphie via Lefred’s MySQL Belgian Days and installed it just after looking into the slidedeck. But never got around to looking further… until now.

We can use so many different observability (o11y?) tools to get notifications, alerts, react, generate reports, etc. from so many different companies, using agents, proxies, repositories, and so on and so forth. And after exchanging experiences with dolphie’s author himself, Charles, the idea here is to go that little bit further in …

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote three posts on the subject, they are listed below.  In this post, I focus on describing the startup phase InnoDB Tablespace Duplicate Check (Duplicate Check for

As a follow up to our regular blog posts on the list of conferences and events where you can find MySQL Community and MySQL team at published back in August, you can find the new list of conferences and events we are part of during December 2024 to February 2025 below: December: MySQL Meetups, London […]

MySQL Conferences 12/24-2/25

Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…

The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable.

In the financial services sector, safeguarding sensitive customer data and ensuring compliance with an ever-evolving regulatory landscape are paramount. As cyber threats become increasingly sophisticated and regulations tighten, financial institutions must adopt robust solutions to protect their data and meet compliance requirements. MySQL Enterprise Edition offers a comprehensive suite of security features designed to address […]

This blog highlights how MySQL Enterprise Edition helps financial services companies enhance security and comply with regulations.

This was principally written for my SQL students but I thought it might be useful to others. SQL calculation are performed row-by-row in the SELECT-list. In its simplest form without even touching a table, you can add two literal numbers like this:

SELECT 2 + 2 AS result;

It will display the result of the addition to the column alias result as a derived table, or the following result:

+--------+
| result |
+--------+
|      4 |
+--------+
1 row in set (0.00 sec)

Unfortunately, the use of literal values as shown above doesn’t really let you see how the calculation is made row-by-row because it only returns one row. You can rewrite the two literal values into one variable by using a Common Table Expressions (CTEs). The CTE creates an struct tuple with only one x element. Another way to describe what the CTE does would say, it creates a derived table named struct with a single …

Rename table operations are common. When business situations and business requirements change, it becomes necessary to change the name of tables in MySQL databases. This article will explore various methods of renaming MySQL tables and essential related issues.

The post How to Change a Table Name in MySQL in Different Ways appeared first on Devart Blog.