MySQL innovation and application sharing session track
How We Efficiently Manage a Large Number of DB Instances on LINE MySQL Platform
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
I am Database Administrator at LY Corporation from Japan, managing MySQL instances and developing operation tools.
Issues and Solutions for Migration from MySQL PXC 5.7 to GR8.0 in Yahoo! JAPAN
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
I am Database Administrator at LY corporation from Japan, managing MySQL.
What's new in MySQL 8.4 LTS and some of reference architectures in Korea?
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
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
資料當道的現在,維護資料血緣是發揮資料價值的必要手段之一,常見的做法是基於語法解析器(parser)來解析query statement,取得其中的metadata。比如開源套件SQLGlot就是實作解析器以取得對應的metadata。然而,解析器往往只支援標準 query statement ,講者以自身經驗分享過去案例,將語法解析以資料庫執行計畫(query plan)取代,不僅減少外部工具的依賴,也徹底解決方言 (dialect) 的支援問題, 還可以結合開源工具OpenLineage將組織內資料血緣視覺化,進一步做到資料治理。
講者
Posu Tsai
來自國境之南的小小工程師,目前在永豐金打雜,對 Compiler、DB、Network 和各種語言都一點點涉略,頭快禿了QQ
身為開發者,如果知道更多 MySQL 的 InnoDB 使用索引的背後邏輯架構,就可以知道優化器採用索引的時機,與應該如何設計索引,以優化資料庫效能。
講者
蕭大俠
8 年後端工程師經歷 現任職於: Zerologix 擔任資深後端工程師
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 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 Server Sizing and Configuration for Performance and Stability
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 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.
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 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功能和技巧,在資料庫使用的過程中幫助您增進MySQL的性能
講者
杜修文
目前是Oracle公司的東亞區MySQL解決方案工程部經理,領導MySQL大中華和東亞區解決方案工程團隊,致力於推廣MySQL技術並幫助企業用戶使用MySQL,同時也是台灣MySQL使用者社群的發起人.