MySQL創新與應用的分享平台

MySQL innovation and application sharing session track

篩選條件

議題

How We Efficiently Manage a Large Number of DB Instances on LINE MySQL Platform

TR410 [[ new Date( '2024-08-03 02:00:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 02:00:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 02:30:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

At LY Corporation, we operate a large number of MySQL instances, with over 12,000 instances only for LINE-related services. As new services are released one after another, the number of instances and the amount of data continues to increase.

In this session, I will show how we streamline the daily operations that occur with large numbers of MySQL instances, such as MySQL upgrades and safe DDL execution.

講者

Takuya Saeki

Takuya Saeki

I am Database Administrator at LY Corporation from Japan, managing MySQL instances and developing operation tools.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 A87HM3 general (30mins)

Issues and Solutions for Migration from MySQL PXC 5.7 to GR8.0 in Yahoo! JAPAN

TR410 [[ new Date( '2024-08-03 02:35:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 02:35:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 03:05:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

In Yahoo! JAPAN (now LY Corporation) operates more than 10,000 MySQL instances. The majority of these are Database as a Service (DBaaS), providing clustered databases using Percona XtraDB Cluster (PXC) and Group Replication (GR).

This session will introduce the background of adopting cluster type, PXC, and GR, and the issues and solutions in migrating to MySQL 8.0.

講者

Yuki Umazume

Yuki Umazume

I am Database Administrator at LY corporation from Japan, managing MySQL.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 XYJXLL general (30mins)

What's new in MySQL 8.4 LTS and some of reference architectures in Korea?

TR410 [[ new Date( '2024-08-03 03:10:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 03:10:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 03:40:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

I'd like to talk about What's new in MySQL 8.4 LTS. MySQL 8.4 was recently GA and there are some changes from 8.0, so I will cover the changes and removes.

講者

Sumi Ryu

Sumi Ryu

MySQL Principal Solution Engineer, Oracle MySQL GBU Founder and staff of MySQL User Group in Korea Sun Software pre-sales for MySQL, Glassfish and iPlanet web server, Sun Microsystems Java developer and software architect, LGCNS

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 CMRKZH general (30mins)

滴血認親,該怎麼解析你的 Query Statement ?

TR410 [[ new Date( '2024-08-03 03:45:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 03:45:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 04:15:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 中文 Chinese
加入行事曆 加入關注 加入關注 已關注

資料當道的現在,維護資料血緣是發揮資料價值的必要手段之一,常見的做法是基於語法解析器(parser)來解析query statement,取得其中的metadata。比如開源套件SQLGlot就是實作解析器以取得對應的metadata。然而,解析器往往只支援標準 query statement ,講者以自身經驗分享過去案例,將語法解析以資料庫執行計畫(query plan)取代,不僅減少外部工具的依賴,也徹底解決方言 (dialect) 的支援問題, 還可以結合開源工具OpenLineage將組織內資料血緣視覺化,進一步做到資料治理。

講者

Posu Tsai

Posu Tsai

來自國境之南的小小工程師,目前在永豐金打雜,對 Compiler、DB、Network 和各種語言都一點點涉略,頭快禿了QQ

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 3PAV7G general (30mins)

MySQL innodb 如何使用索引

TR410 [[ new Date( '2024-08-03 05:00:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 05:00:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 05:30:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 中文 Chinese
加入行事曆 加入關注 加入關注 已關注

身為開發者,如果知道更多 MySQL 的 InnoDB 使用索引的背後邏輯架構,就可以知道優化器採用索引的時機,與應該如何設計索引,以優化資料庫效能。

講者

蕭大俠

蕭大俠

8 年後端工程師經歷 現任職於: Zerologix 擔任資深後端工程師

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 JGGJML general (30mins)

Chat with MySQL with LLM and Langchain

TR410 [[ new Date( '2024-08-03 05:40:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 05:40:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 06:10:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

Learn how to modernize your MySQL applications with a natural language chat interface using popular large language models such as OpenAI, Cohere, and many others. In this session, we will use one of the popular frameworks, Langchain to build a simple chat application to answer your questions on data stored in MySQL.

講者

Ryan Kuan

Ryan Kuan

Ryan Kuan is a Cloud Solutions Engineer who helps organisations to adopt cloud-native data architecture across the Asia Pacific regions at Oracle MySQL.
Ryan believes that organisations adopting cloud technology can focus and innovate their business entirely without worrying about the underlying IT infrastructure the business depends upon. He has helped many organizations adopt cloud-native data science capabilities to discover invaluable information and data insights to solve complex business problems. Before joining Oracle MySQL, he worked in various roles such as Cloud Advisor, Solutions Architect, and Database Engineer at IBM, BEA Systems, and Informix respectively, he achieved various professional accreditations such as TOGAF, ITIL, and IBM certified professional architect.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 VMRPXE general (30mins)

MySQL Server Sizing and Configuration for Performance and Stability

TR410 [[ new Date( '2024-08-03 06:20:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 06:20:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 06:50:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

Whether you're a seasoned DBA seeking to squeeze every last drop of performance from your database servers or a developer aiming to optimize query execution times, this session offers MySQL server sizing, baseline configuration and tuning for performance fundamentals. Performance tuning isn't just about optimizing queries—it's also about right-sizing your MySQL infrastructure to meet the demands of your workload. We'll discuss strategies for sizing and configuring MySQL servers appropriately, taking into account factors such as memory, CPU, and storage requirements.

講者

Hananto Wicaksono

Hananto Wicaksono

Hananto Wicaksono is a seasoned database professional mainly in Oracle and MySQL for more than 20 years. With a passion for optimizing data-driven solutions and enhancing system performance, he frequently shares his insights through articles, presentations, and workshops, fostering a collaborative environment for database professionals to exchange ideas and best practices.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 XNHKQK general (30mins)

MySQL Maximum High Availability Architecture

TR410 [[ new Date( '2024-08-03 06:55:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 06:55:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 07:25:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 英文 English
加入行事曆 加入關注 加入關注 已關注

High Availability (HA) is a critical concern for organizations relying on MySQL databases to power their applications. This talk delves into the strategies and implementation techniques to achieve maximum HA in MySQL environments. This talk focuses on the importance of HA in ensuring uninterrupted service availability, especially in mission-critical applications. It highlights the impact of downtime on business continuity and customer satisfaction, emphasizing the need for robust HA solutions. It explores various HA architectures tailored for MySQL, ranging from simple setups to complex distributed systems.

講者

Hananto Wicaksono

Hananto Wicaksono

Hananto Wicaksono is a seasoned database professional mainly in Oracle and MySQL for more than 20 years. With a passion for optimizing data-driven solutions and enhancing system performance, he frequently shares his insights through articles, presentations, and workshops, fostering a collaborative environment for database professionals to exchange ideas and best practices.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 Z38QNT general (30mins)

10個增進MySQL性能的秘訣

TR410 [[ new Date( '2024-08-03 07:30:00+00:00' ).toLocaleDateString('ja', {year: 'numeric', month: '2-digit', day: '2-digit'}) ]] [[ new Date( '2024-08-03 07:30:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] ~ [[ new Date( '2024-08-03 08:00:00+00:00' ).toLocaleTimeString('zh-Hant', {hour12: false, hour: '2-digit', minute:'2-digit'}) ]] 中文 Chinese
加入行事曆 加入關注 加入關注 已關注

本演講將為您介紹如何利用新版的MySQL功能和技巧,在資料庫使用的過程中幫助您增進MySQL的性能

講者

杜修文

杜修文

目前是Oracle公司的東亞區MySQL解決方案工程部經理,領導MySQL大中華和東亞區解決方案工程團隊,致力於推廣MySQL技術並幫助企業用戶使用MySQL,同時也是台灣MySQL使用者社群的發起人.

MySQL innovation and application sharing session track MySQL創新與應用的分享平台 ECFELP general (30mins)