inflearn logo
inflearn logo

Concepts and tuning methods considered when migrating 20 billion data to MySQL

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

(4.2) 수강평 29개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

MySQL
MySQL
mysql-workbench
mysql-workbench
mysql-query
mysql-query
MongoDB
MongoDB
MySQL
MySQL
mysql-workbench
mysql-workbench
mysql-query
mysql-query
MongoDB
MongoDB

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.2

5.0

유쾌한 캥거루

92% 수강 후 작성

I think this is a good lecture that focuses on the parts that you need to be careful about when writing queries rather than the basic concepts. I think that in this lecture, you can learn a lot about performance improvement and tuning improvement rather than learning about queries. In fact, I think that queries can be developed through ChatGPT in general, so I was more satisfied with this lecture that focused on theories.

5.0

gy.lyu

31% 수강 후 작성

I think it will be a great help in my work.

5.0

멀머

100% 수강 후 작성

Before listening to the lecture, it would be better to study the concepts once with the keywords in the lecture table of contents. Rather than a detailed lecture on the concepts, this lecture focuses more on the parts that need more attention when writing queries and the advice from the instructor's experience.

강의상세_배울수있는것_타이틀

  • Things to be aware of when using MySQL

  • Writing queries in MySQL

  • Various constraints in MySQL

  • Locks in MySQL

How do we migrate 20 billion records of data? 🤔

In my recent work, I migrated 20 billion records of data from MongoDB to MySQL, which resulted in cost savings and normalization.

To cut to the chase, there's no right answer. I don't know if I'm doing it right or if it could be further optimized.

However, we deployed the service normally and without interruption, and I would like to share with you the areas we considered and paid attention to for optimization during this process.

Through this lecture, I hope you will learn about the charm of DB and the concerns of backend developers .

Features of this course

📌 The topic is 100% based on my own experience.

📌 It includes things I would like to share in addition to what I experienced.

📌 I will look into any parts where my personal explanation is lacking and let you know.

📌 I will tell you about my actual practical experience.

I recommend this to these people

backend developer

DB: Can't you just write a query?

DB Engineer
I want to share and inform you about these things.

job seekers
I need to prepare for a job as a developer, and I'm curious about RDB.

The lecture covers the following topics: 🤔

  1. Multi-Column Index [Composite Index]

  2. Explain Query [Query Analysis]

  3. Covering Index [Index Optimization]

  4. RDB vs. ElasticSearch [Index and Inverted Index]

  5. ORDER BY [Sort Optimization]

  6. INSERT [Insert Optimization]

  7. AUTO_INCREMENT LOCK [ AUTO_INCREMENT Lock ]

  8. Index Dive [Query Planning Optimization]

  9. Prefix Index [Index Lightening]

  10. MySQL Lock [ MySQL Integrity and Concurrency ]

  11. DeadLock [Understanding DeadLock through Case Analysis]

  12. No OFFSET [Query Tuning]

  13. Skip Locked [ Session Management ]

Who created this course

I have diverse experiences from startups to metaverse and platform service development. Recently, I migrated a service that handled 20 billion MongoDB data to MySQL, and now I am a platform server developer that handles 20 billion MySQL data.

Things to note before taking the course

Practice environment

  • This lecture will be based on MacOS. MySQL Workbench will be used, so please install it.


A good lecture to refer to 💁


This course primarily focuses on MySQL.

But none of the companies I've experienced use a single DB.

  • Of course, in the case of a startup, it is configured with one DB.


We select and utilize various DBs according to the situation, legacy, and environment.

So I think MySQL alone may not be enough.


If you are curious about MongoDB, a leading NoSQL platform, the lecture below will be of great help.

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • For those who are new to DB

  • For those who are curious about large-scale data design

  • For those who are curious about the basic concepts of MySQL

강의소개.지공자소개

3,785

수강생

187

수강평

88

답변

4.4

강의 평점

15

강의_other

Introduction

As a non-major, I am currently working as a platform server developer in Pangyo.

I enjoy server optimization and various query tuning, and I strive to explain simple features to you in a quick and easy-to-understand manner.

Experience

[Former] Sandbox Blockchain Developer

[Former] Backend Developer at a Nexon subsidiary

[Former] Platform Server Developer at a major tech company in Pangyo

[Current] Server Developer at a Pangyo-based parent company

더보기

커리큘럼

전체

13개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

강의 게시일: 
마지막 업데이트일: 

수강평

전체

29개

4.2

29개의 수강평

  • sasas님의 프로필 이미지
    sasas

    수강평 78

    평균 평점 4.9

    5

    100% 수강 후 작성

    • jukas5985 [DEL] 250815201525님의 프로필 이미지
      jukas5985 [DEL] 250815201525

      수강평 14

      평균 평점 4.9

      5

      92% 수강 후 작성

      I think this is a good lecture that focuses on the parts that you need to be careful about when writing queries rather than the basic concepts. I think that in this lecture, you can learn a lot about performance improvement and tuning improvement rather than learning about queries. In fact, I think that queries can be developed through ChatGPT in general, so I was more satisfied with this lecture that focused on theories.

      • july
        지식공유자

        Many people use MySQL and I wanted to share the way I dealt with it. As you left, I think AI is actually more accurate than me when it comes to queries. ㅎㅎ So I covered the theory and optimization part rather than queries. Thank you for your good review.😁

    • gylyu1184님의 프로필 이미지
      gylyu1184

      수강평 10

      평균 평점 5.0

      5

      31% 수강 후 작성

      I think it will be a great help in my work.

      • july
        지식공유자

        I'm glad it was helpful. Thank you for listening :)

    • haruhiism님의 프로필 이미지
      haruhiism

      수강평 10

      평균 평점 4.3

      4

      100% 수강 후 작성

      It was a good lecture that allowed me to recall concepts I had forgotten for a long time.

      • uheejoon님의 프로필 이미지
        uheejoon

        수강평 45

        평균 평점 5.0

        5

        100% 수강 후 작성

        July님의 다른 강의

        지식공유자님의 다른 강의를 만나보세요!

        비슷한 강의

        같은 분야의 다른 강의를 만나보세요!

        강의상세.할인문구

        $20.90

        29%

        $29.70