Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Programming

/

Back-end

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.3) 24 reviews

412 learners

  • july
3시간 만에 완강할 수 있는 강의 ⏰
마이그레이션
rdb
MySQL
mysql-workbench
mysql-query
MongoDB

Reviews from Early Learners

What you will learn!

  • 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.

Recommended for
these people

Who is this course right for?

  • 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

Hello
This is

3,479

Learners

162

Reviews

87

Answers

4.5

Rating

15

Courses

자기 소개

비전공자 출신으로 판교에서 플랫폼 서버 개발을 담당하여 진행하고 있습니다.

서버 최적화와 다양한 쿼리 튜닝을 좋아합니다.

 

경력

[前] 샌드박스 블록체인 개발자

[前] 넥슨 자회사 백엔드 개발자

[前] 판교 대기업 플랫폼 서버 개발자

[] 판교 모회사 서버 개발자

Curriculum

All

13 lectures ∙ (2hr 6min)

Published: 
Last updated: 

Reviews

All

24 reviews

4.3

24 reviews

  • 유쾌한 캥거루님의 프로필 이미지
    유쾌한 캥거루

    Reviews 14

    Average Rating 4.9

    5

    92% enrolled

    기본적인 개념보다는 좀 더 쿼리를 작성하는데에 있어서 주의해야하는 부분들에 대해서 집중적으로 알려주는 좋은 강의라고 생각을 합니다. 이 강의에서 쿼리에 대해서 배워가시기 보다는 성능 개선이나 튜닝 개선을 많이 배워 갈 수 있다는 생각이 들었습니다. 사실 쿼리에 대해서는 일반적으로 ChatGPT를 통해서도 개발이 가능하다고 생각을 하기 떄문에 이런 이론에 집중된 강의가 더 만족스럽게 다가왔습니ㅣ다.

    • July
      Instructor

      많은 분들이 MySQL을 사용하시고 제가 다루었던 방식에 대해서 공유드리고 싶었습니다. 남겨주신 내용처럼 사실 쿼리에 대해서는 저보다 AI가 더 정확할꺼 같아요 ㅎㅎ 그래서 쿼리보다는 이론이나 최적화하는 부분에 대해서 다루어보았습니다. 좋은 평 해주셔서 감사합니다.😁

  • 쿄큐큐님의 프로필 이미지
    쿄큐큐

    Reviews 49

    Average Rating 4.9

    5

    100% enrolled

    • 유희준님의 프로필 이미지
      유희준

      Reviews 33

      Average Rating 5.0

      5

      100% enrolled

      • gy.lyu님의 프로필 이미지
        gy.lyu

        Reviews 9

        Average Rating 5.0

        5

        31% enrolled

        업무에 큰도움이 될것 같습니다.

        • July
          Instructor

          많은 도움이 되었다고 하시니 뿌듯합니다. 들어주셔서 감사합니다 :)

      • Kwonkyu Park님의 프로필 이미지
        Kwonkyu Park

        Reviews 10

        Average Rating 4.3

        4

        100% enrolled

        잊고있던 개념들을 오랜만에 떠올려볼 수 있는 좋은 강의였습니다

        Limited time deal

        $28,880.00

        24%

        $29.70

        july's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!