HOME/Articles/MySQL Unconference #008 was held

MySQL Unconference #008 was held

2025/4/10 21:172025/4/11 8:39

Yuta Kikai (Service Reliability Group (SRG) of the Media Headquarters)@fat47)is.

#SRG(Service Reliability Group) mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, contributing to OSS, etc.

This article introduces the MySQL Unconference #008, which was held recently.

What is MySQL Unconference?MySQL Unconference #008 Contents Announcement 1: "Aurora Blue/Green Deployment feature supports non-disruptive upgrades of large-scale Aurora MySQL clusters"Presentation 2: "Reading the code of MySQL OnlineDDL(INPLACE) with help from Claude"Presentation 3: Aiming for safe DDL execution ~ (Part 1) Understanding the MDL to be obtained ~Next event schedule and call for speakers

What is MySQL Unconference?

MySQL Unconference to take place in February 2024@tom__boIt was started by and is run as a casual event where people from different companies can talk casually about MySQL.

What are your thoughts on the event?Tom__bo's blog herePlease see.

From this time on, I will be co-hosting@fat47and@mconfjpWith the addition of Mr. Ikeda, we have established a system that will allow us to continue holding events on an ongoing basis.

MySQL Unconference #008 Contents

MySQL Unconference #008 (2025/04/09 19:30~)

# Event Overview The 8th MySQL Unconference will be held. We are looking for people who can talk about something in a "chat" style rather than a "presentation". Please also refer to my blog (I want to hold a MySQL Unconference) for the purpose of the event. Any topic related to MySQL, even to a small extent, is OK, such as MySQL or MySQL-compatible databases, system design or operation related to MySQL, or even more broadly, topics related to database technology. # Schedule * Date and time: 2025/04/09 (Wed) 19:30-21:00 * Session schedule: To be decided within 5 minutes of the start *...

https://mysql-unconference.connpass.com/event/349826/

At this year's MySQL Unconference #008, each of the three organizers gave a session, and the event mainly consisted of casual conversation that developed from those sessions.

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

The first announcement is me@fat47This was carried out by.

Ameba Blog explains how they upgraded a large-scale Aurora MySQL cluster using the Aurora Blue/Green Deployment feature, and provides an overview of the feature.

Click here for the document

MySQL Unconference #008_Aurora Blue_Green Deployment feature supports non-disruptive upgrades of large-scale Aurora MySQL clusters

Ameba Blog provides a brief introduction to the method used to perform a non-disruptive Aurora MySQL upgrade and the problems encountered.

https://speakerdeck.com/yutakikai/mysqlankanhuarensu-number-008-da-gui-mo-aurora-mysqlkurasutano-wu-ting-zhi-atuhukuretowozhi-eta-aurora-blue-green-deploymentji-neng

When explaining the B/G function, we used diagrams to illustrate the switching process.

I also described the problems I encountered,

We will introduce examples of how it is difficult to check the replication status between Blue/Green at a glance from the console, and how to address the slowness of SELECT COUNT.

Presentation 2: "Reading the code of MySQL OnlineDDL(INPLACE) with help from Claude"

The second one is Morita-san (@mconfjp) and his presentation featured using Claude to read the source code of the OnlineDDL portion of MySQL.

Click here for the document

Reading the Code of DDL (INPLACE) - 8th MySQL Unconference

Check out this Presentation designed by Hiroki Morita.

https://www.canva.com/design/DAGjlxK2UyQ/Z0Y4HGSQNeQqu3_npUl8QQ/view?utm_content=DAGjlxK2UyQ&utm_campaign=designshare&utm_medium=link2&utm_source=uniquelinks&utlId=h2b52923aa6

In the past, he had researched the mechanism of online DDL and summarized it in a blog, but he challenged himself to deepen his understanding by reading the actual MySQL source code.

MySQL's source code is huge and it would be tedious to read it from scratch, so by using the generative AI Claude to read through it, they were able to get a rough grasp of its structure.

Presentation 3:Aiming for safe DDL execution ~ (Part 1) Understanding the MDL to be obtained ~

Finally,@tom__boThis presentation will deepen your understanding of Metadata Locking (MDL) by

Click here for the document

Aiming for safe DDL execution ~ (Part 1) Understanding the MDL to be obtained ~

https://speakerdeck.com/tombo/an-quan-naddlnoshi-xing-womu-zhi-site-sono1-qu-de-surumdlnoba-wo

An MDL is a lock acquired to manage concurrent access to database objects and ensure consistency, such as when changing a table structure.

This was being investigated because a better understanding of MDL could lead to safer DDL execution.

The MDL can be viewed via the performance_schema.metadata_locks table, but this only shows locks that are being acquired or are being waited on.

Therefore@tom__boApparently, he investigated the issue by modifying the MySQL source code and adding detailed log output using the print debugging method.

Next event schedule and call for speakers

MySQL Unconferences will continue to be held every three months.

Next time #009Around July 2025The event is scheduled to be held, so if you are interested, please feel free to join us!

X's community function "#MySQLUnconferenceIf you enter this information we will be able to let you know as soon as the date of the event is decided.

Someone who will talk to youCurrently accepting applicationsis.

Anything is OK, not just MySQL alone, but also MySQL-compatible products on each public cloud, MariaDB, Percona for MySQL, and other operations and problems related to these products.

We welcome LTs of about 5 minutes or longer presentations, so please feel free to contact the organizer (@tom__bo , @mconfjp , @fat47) I would be happy if you could contact me.

It is also fine to not prepare presentation materials, but just decide on a theme and have participants exchange opinions with each other.