About SRGTechnical articleRecruitment Information
About SRGTechnical articleRecruitment Information
HOME/Technical article/We held the MySQL Unconference #008.

We held the MySQL Unconference #008.

 
Yuta Kikai of the Service Reliability Group (SRG) in the Media Management Division@fat47)is.
#SRGThe Service Reliability Group primarily provides comprehensive support for the infrastructure surrounding our media services, focusing on improving existing services, launching new ones, and contributing to open-source software (OSS).
This article introduces the MySQL Unconference #008, which was held recently.
 

What is the MySQL Unconference?

The MySQL Unconference will be held in February 2024.@tom__boIt was launched by [Name] and is run as a relaxed event that provides a place for people to casually discuss MySQL, transcending company boundaries.
What are your thoughts on holding the event?This is tom__bo's blog.Please take a look.
 
From this time onwards, I will be a co-organizer.@fat47and@mconfjpWith [Name] joining us, we've established a system that allows us to continue holding events on a regular basis.

Summary of the MySQL Unconference #008

At this MySQL Unconference #008, the three organizing members each gave a session, and the conference mainly consisted of casual discussions that stemmed from those sessions.

Announcement 1: "Aurora Blue/Green Deployment feature enabled non-disruptive upgrades of large-scale Aurora MySQL clusters"

The first presentation is by me@fat47It was done by [name/organization].
This article describes how we upgraded a large-scale Aurora MySQL cluster for Ameba Blog using the Aurora Blue/Green Deployment feature, and provides an overview of that feature.
The document is available here.
 
The B/G function was explained using diagrams to illustrate the switching process.
The article also describes the troubles encountered.
This section illustrates the difficulty of quickly checking the replication status between Blue and Green instances from the console, and uses the slowdown of SELECT COUNT as an example.

Presentation 2: "Reading the MySQL Online DDL (INPLACE) Code with Claude's Assistance"

The second one is Morita-san (@mconfjpThe presentation was about using Claude to read the source code for the OnlineDDL portion of MySQL.
The document is available here.
 
In the past, he had researched the mechanism of online DDL and summarized it on his blog, but he was challenging himself to deepen his understanding even further by reading the actual MySQL source code.
The MySQL source code is enormous and difficult to read from scratch, so they used the generation AI Claude to read through it, which apparently allowed them to grasp the general structure.

Announcement 3:Aiming for Secure DDL Execution ~ (Part 1) Understanding the MDL to be Acquired ~

Finally,@tom__boThis is a presentation by [Name] to deepen your understanding of metadata locking (MDL).
The document is available here.
 
MDL (Multiple Lock Definition) is a lock acquired to manage simultaneous access to database objects and ensure consistency, such as when changing the table structure.
The research was conducted because a deeper understanding of MDL would allow for safer execution of DDL.
 
MDL can be checked via the performance_schema.metadata_locks table, but this only shows locks that are currently acquired or pending.
 
Therefore@tom__boIt seems that Mr. [Name] modified the MySQL source code and added detailed log output using a print debugging method to investigate the issue.

Upcoming event and call for speakers

The MySQL Unconference will continue to be held every three months.
Next time #009Around July 2025The event is scheduled to take place, so please feel free to join us if you are interested!
X's community feature:#MySQLUnconferenceThere is a link available, so if you join there, we will be able to inform you as soon as the event date is decided.
 
Some people will talk to me.Now accepting applications!is.
We welcome presentations on anything related to MySQL, not just MySQL itself, but also MySQL-compatible products on various public clouds, MariaDB, Percona for MySQL, and any operational issues or problems you may be experiencing.
Short lightning talks of around 5 minutes or longer presentations are all welcome, so please feel free to contact the organizers (@tom__bo , @mconfjp , @fat47I would be happy if you could reach out to me.
Even if you don't prepare a full presentation, it's perfectly fine to simply choose a theme and exchange ideas with other participants.