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

/

Database

Learn MySQL on Docker by following along

Instead of long and boring theories, you can learn them one by one through short practical exercises, and as you flesh them out one by one, you will soon be able to experience the overall architecture composition.

(4.9) 47 reviews

550 learners

  • dbakim7939
3시간 만에 완강할 수 있는 강의 ⏰
Docker
MySQL

Reviews from Early Learners

What you will learn!

  • Even if you don't know it in depth, if you follow along one by one, you will be able to understand and learn it one by one through practice.

  • In a Docker environment, you can learn the following: ▼

  • MySQL Installation

  • Replication Configuration (Master-Slave Configuration)

  • Configuring HA (High Availability) using Orchestrator

  • Proxy Layer Configuration Using ProxySQL

  • Configuring MySQL monitoring environment via Prometheus

  • Bulk deployment via Docker Compose

  • Configuring Scalability via Docker Swarm

  • Backup and Recovery

Tutorial on using MySQL for Docker environments,
Try implementing them one by one and learn them with your own hands.

Topic Introduction 📝

How do I use MySQL in a Docker environment?
If you search on Google, you will find examples of running a container using the MySQL Docker Image and connecting to the DB.
Most of them.

Can I use it just by knowing that?
What are some special considerations that need to be taken into account in a Docker environment, unlike in a general environment?
Normally, when used in services, it is used in a Master-Slave configuration, but how should it be configured in a Docker environment?
I would like to have automatic failover so that the service can continue even in the event of a Master failure. How should I configure this?
How can we implement essential functions like backup, recovery, and monitoring?

I hope this lecture will help you address these concerns.


What you will learn in this course ✏️

1. Running MySQL Container in Docker Environment

2. Configuring MySQL Master-Replication in a Docker Environment

3. Configuring MySQL Auto Failover using Orchestrator

4. Configuring Auto Failover at the Application Level via ProxySQL

5. Configuring MySQL monitoring using Prometheus and Grafana

6. Batch deployment of multiple services using Docker Compose
7. Service expansion through Docker Swarm


Lecture Features 💡

Rather than detailed theories, you can implement them one by one through short command unit practice.


Tools covered here 🧰

  • AWS EC2
  • Docker
  • Percona MySQL 5.7
  • Orchestrator
  • ProxySQL
  • Prometheus
  • Grafana

Recommended for
these people

Who is this course right for?

  • For those who want to know how to use MySQL in a Docker environment

  • Anyone who wants to learn about various open source use cases related to MySQL

  • For those who want to gain a lot of experience through practical training in a short period of time

Need to know before starting?

  • MySQL Basics

  • AWS EC2

Hello
This is

550

Learners

47

Reviews

72

Answers

4.9

Rating

1

Course

LG CNS와 NBP(Naver Business Platform), 라이엇게임즈를 거쳐 현재는 현대자동차에서 근무하고 있는 경력 23년차 DBA 입니다.

Oracle과 Cubrid, MySQL, 데이터모델링 경력을 가지고 있습니다. 

Curriculum

All

23 lectures ∙ (3hr 6min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

47 reviews

4.9

47 reviews

  • dolphhong1630님의 프로필 이미지
    dolphhong1630

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    You can learn the overall technologies required to operate MySQL DB in a Docker container environment, and you can understand the content well through hands-on practice with the instructor's friendly explanation. I would like to recommend this to those who are interested in database operation based on containers. I think it is a lecture that will be very helpful in practice.

    • ㅇㄿㅇㄿㅇㄹ님의 프로필 이미지
      ㅇㄿㅇㄿㅇㄹ

      Reviews 6

      Average Rating 5.0

      5

      52% enrolled

      I've only used AWS RDS. It was my first time building a server with Docker, and it was great. At first, it was inconvenient to do it manually, but later, the build-up lecture that led to automation was great. I'm so grateful that I can hear the knowledge I've accumulated over the years for just 30,000 won. I wish we had someone like this in our company.

      • dbakim7939
        Instructor

        Thank you for your kind review.

    • green4s5968님의 프로필 이미지
      green4s5968

      Reviews 1

      Average Rating 5.0

      5

      57% enrolled

      It was great to learn about orchestrator, which has a web console that wasn't available in mmm or mha, and to learn about the configuration and operation of MySQL's high availability in a container environment!

      • devramyun님의 프로필 이미지
        devramyun

        Reviews 5

        Average Rating 5.0

        5

        100% enrolled

        Thank you for creating a great lecture.

        • dbakim7939
          Instructor

          Thank you for taking the class.

      • deo01님의 프로필 이미지
        deo01

        Reviews 25

        Average Rating 4.6

        5

        65% enrolled

        Hmm.. This was a Docker lecture that fit my needs perfectly. I wonder if you have any plans for a sequel.

        • dbakim7939
          Instructor

          Thank you for taking the class. I haven't made any follow-up plans yet.

      $26.40

      Similar courses

      Explore other courses in the same field!