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.
This course is prepared for Basic 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 leveraging MySQL for Docker environments,
Implement them one by one and learn them with your own hands.
Topic Introduction 📝
How do I use MySQL in a Docker environment?
If you Google it, 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 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 such as backup, recovery, and monitoring?
I hope that 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 through ProxySQL
5. Configuring MySQL monitoring using Prometheus and Grafana
6. Bulk deployment of multiple services using Docker Compose
7. Service expansion through Docker Swarm
Course 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
540
Students
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: