We’re excited to present a recap of the MySQL Community 2025 Advent Calendar posts. Once again, we thoroughly enjoyed preparing and sharing our insights on a diverse range of topics related to MySQL. Continuing the tradition from previous years, the MySQL Community Team contributed a series of daily blog posts throughout December, leading up to […]

Decrypting SSL/TLS Traffic with Wireshark and ProxySQL

In this guide, we will walk you through the process of decrypting SSL/TLS traffic to and from ProxySQL using Wireshark. By enabling the SSLKEYLOG feature in ProxySQL and configuring Wireshark to use the SSL key log file, you will be able to view the decrypted traffic for debugging and analysis purposes.

Prerequisites

Before we begin, make sure you have the following:

• ProxySQL installed and running.
• Wireshark installed on your machine.

Enabling SSLKEYLOG in ProxySQL

You can enable the SSLKEYLOG feature in ProxySQL either by modifying the configuration file or via runtime queries.

Enabling SSLKEYLOG via Configuration File

1. Open the ProxySQL configuration file (typically proxysql.cnf) in a text editor.

2. Add or modify the …

I am upset about this one : I have a hard time not seeing this as negligence, and it starts to become a pattern...  So please forgive me if this post is not my most diplomatic, because I really think someone deserves a kick in the butt !  But what is all this about...

There is a MySQL bug, which can lead to data corruption, opened for 8.0 in September 2023, fixed in MySQL 8.4.0 (

For decades, we’ve accepted a painful compromise: if you wanted logic inside the database, you had to write SQL/PSM (Persistent Stored Modules). It’s clunky, hard to debug, and declarative by nature, making it terrible for algorithmic tasks. That ends with Percona Server 8.4.7-7. We are introducing JS Stored Programs as a Tech Preview. Unlike Oracle’s […]

This SQL Test 2026 contains 100 SQL MCQ with Answers to help you practice and improve your SQL knowledge. These SQL MCQ questions cover the most important SQL topics, including basics, joins, queries, functions, constraints, keys, etc. This SQL Test is ideal for students, freshers, developers, and anyone preparing for placements, coding interviews, online tests, […]

Managing large datasets can be a balancing act between performance and storage. Keeping your “hot” data lean is critical for speed and memory efficiency. But what about the “cold” data you still need to retain? Partition Exchange Archiving a simple, production-ready strategy that lets you instantly move old data out of your primary tables without […]

MySQL is one of the most popular open-source relational database management systems (RDBMS). It is widely used for web applications, ...

Read More

The post How to Install MySQL on Debian 13 appeared first on RoseHosting.

We have reached the end of our series on deploying to OCI using the Hackathon Starter Kit. For this last article, we will see how to deploy an application using Helidon (Java), the MySQL REST Service, and OCI GenAI with Lanchain4J. We use Helidon because it’s a cool, open-source framework developed by Oracle. It’s lightweight […]

The starter kit deploys a MySQL HeatWave DB System on OCI and enables the MySQL REST Service automatically: The REST Service enables us to provide access to data without requiring SQL. It also provides access to some Gen AI functionalities available in MySQL HeatWave. Adding data to MRS using Visual Studio Code To be able […]

As the year comes to a close, we want to take a moment to say thank you to everyone who makes the MySQL Community what it is. Whether you contributed code, filed bugs, answered questions in forums, wrote a tutorial, spoke at an event, organized a meetup, or simply shared your experience with others — your passion […]