강의

멘토링

커뮤니티

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

442 learners

Level Basic

Course period Unlimited

  • July
MySQL
MySQL
mysql-workbench
mysql-workbench
mysql-query
mysql-query
MongoDB
MongoDB
MySQL
MySQL
mysql-workbench
mysql-workbench
mysql-query
mysql-query
MongoDB
MongoDB

Reviews from Early Learners

Reviews from Early Learners

4.3

5.0

유쾌한 캥거루

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.

5.0

gy.lyu

31% enrolled

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

5.0

멀머

100% enrolled

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.

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,773

Learners

184

Reviews

88

Answers

4.4

Rating

15

Courses

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

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 74

    Average Rating 4.9

    5

    100% enrolled

    • uheejoon님의 프로필 이미지
      uheejoon

      Reviews 45

      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.

        Limited time deal ends in 3 days

        $29,700.00

        22%

        $29.70

        July's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!