title: [TW_DevRel] TECH-Verse 2022 Interesting Agenda Sharing - Day 1
published: false
date: 2022-11-18 00:00:00 UTC
tags:
canonical_url: http://www.evanlin.com/twdevrel-techverse2022/
---

![image-20221118150105191](http://www.evanlin.com/images/2021/image-20221118150105191.png)

# Preface

The Z Holding developer conference TECH-Verse, held online from 11/17 to 11/18, is about to begin. It includes online developer conferences from 8 companies, including LINE Corp and Yahoo! Japan, with a total of 90 online sessions:

All relevant session categories are listed below:

- Day 1 - 11.17 (11:00 ~ 18:00)
- Data / AI
- Security
- Infrastructure
- Blockchain
- Day 2 - 11.18 (10:00 ~ 18:00)
- Server Side
- UX / Design
- Mobile App
- Web Front-end
- Process & Environment

Related event URL: [https://tech-verse.me/en](https://tech-verse.me/en)

The slides will be made public immediately after the relevant sessions. The videos after the interpretation is completed will be released successively after 11/25.

# Interesting Agenda Sharing on Day 1:

![img](https://github.com/vdaas/vald/raw/main/assets/image/readme.svg)

## Vald: ANN search engine by Golang\*\*Vald: OSS ANN Nearest Neighbor Dense Vector Search Engine

Valid: https://github.com/vdaas/vald

This is a scalable distributed ANN (approximate nearest neighbor) vector search engine. This is a tool that can be quickly deployed on K8S. It is even used in Yahoo! JP:

- Similar product image search
- Generate related tags through product names
- Similar source code search (this also works!)

If you want to know how to use it, you can refer to

- [Slides](https://speakerdeck.com/techverse_2022/vald-oss-ann-nearest-neighbor-dense-vector-search-engine-introduction-and-case-studies).
- Session: https://tech-verse.me/en/sessions/172

## Our Automation Tool for Migrating 1,800 MySQL Instances in Only Six Months
<iframe frameborder="0" src="https://speakerdeck.com/player/52b80ea6286f4fa9ad587699c3324731" title="Our Automation Tool for Migrating 1,800 MySQL Instances in Only Six Months" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true" style="border: 0px; background: padding-box padding-box rgba(0, 0, 0, 0.1); margin: 0px; padding: 0px; border-radius: 6px; box-shadow: rgba(0, 0, 0, 0.2) 0px 5px 40px; width: 560px; height: 314px;" data-ratio="1.78343949044586"></iframe>

Have you upgraded MySQL before? Due to the expansion of LINE's business, the entire enterprise has more than 6000 MySQL Instances. In order to upgrade the version of MySQL 5.6 (which has stopped maintenance in 2021/02), it will be an incalculable cost.

<iframe frameborder="0" src="https://speakerdeck.com/player/52b80ea6286f4fa9ad587699c3324731?slide=15" title="Our Automation Tool for Migrating 1,800 MySQL Instances in Only Six Months" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true" style="border: 0px; background: padding-box padding-box rgba(0, 0, 0, 0.1); margin: 0px; padding: 0px; border-radius: 6px; box-shadow: rgba(0, 0, 0, 0.2) 0px 5px 40px; width: 560px; height: 314px;" data-ratio="1.78343949044586"></iframe>

Generally speaking, the MySQL update process can be divided into:

- Create New MySQL Instance
- Add User ACL
- Set MySQL Variable
- Export/Import Data
- Start Replication
- Inspect Query Performace
- Switch to new MySQL. (In midnight?)
- Shutdown old MySQL

This kind of work is actually quite time-consuming. It is possible that after it is done...

<iframe frameborder="0" src="https://speakerdeck.com/player/52b80ea6286f4fa9ad587699c3324731?slide=17" title="Our Automation Tool for Migrating 1,800 MySQL Instances in Only Six Months" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true" style="border: 0px; background: padding-box padding-box rgba(0, 0, 0, 0.1); margin: 0px; padding: 0px; border-radius: 6px; box-shadow: rgba(0, 0, 0, 0.2) 0px 5px 40px; width: 560px; height: 314px;" data-ratio="1.78343949044586"></iframe>

(This speaker is really humorous)

Therefore, the LINE DBA team developed a tool MUH: (MySQL Update Helper)

How MUH can help you upgrade MySQL without security concerns. You can refer to this slide to explain the principle:

- Slides https://speakerdeck.com/techverse\_2022/our-automation-tool-for-migrating-1800-mysql-instances-in-only-six-months
- Session: https://tech-verse.me/en/sessions/61