강의

멘토링

커뮤니티

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) 27 reviews

432 learners

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

Reviews from Early Learners

What you will gain after the course

  • 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,710

Learners

182

Reviews

88

Answers

4.5

Rating

15

Courses

자기 소개

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

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

 

경력

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

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

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

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

Curriculum

All

13 lectures ∙ (2hr 6min)

Published: 
Last updated: 

Reviews

All

27 reviews

4.3

27 reviews

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

    Reviews 14

    Average Rating 4.9

    5

    92% enrolled

    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
      Instructor

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

  • sasas님의 프로필 이미지
    sasas

    Reviews 62

    Average Rating 4.9

    5

    100% enrolled

    • uheejoon님의 프로필 이미지
      uheejoon

      Reviews 44

      Average Rating 5.0

      5

      100% enrolled

      • gylyu1184님의 프로필 이미지
        gylyu1184

        Reviews 10

        Average Rating 5.0

        5

        31% enrolled

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

        • july
          Instructor

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

      • haruhiism님의 프로필 이미지
        haruhiism

        Reviews 10

        Average Rating 4.3

        4

        100% enrolled

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

        $29.70

        July's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!