MariaDB(MySQL)의 모든것 - 심화편
bradkim
개발입문자, 백엔드개발자, SQLD시험준비 수강생 등 개발자라면 알아야 할 MariaDB(MySQL)의 모든 것을 배웁니다. DB를 직접 구축해보는 실습위주로 수업이 진행됩니다.
초급
MariaDB, MySQL, sql-join
BEST
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.
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
552
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
JungMin HongReviews 1
∙
Average Rating 5.0
- LetsGoHigh
Reviews 6
∙
Average Rating 5.0
5
52% enrolledaws rds만 사용해왔습니다. 직접 도커로 서버에 구축하는 것은 처음이었는데 너무 좋네요. 처음엔 불편하게 수동으로 진행하면서 나중에는 자동화로 이어지는 빌드업 강의가 너무 좋았습니다. 수년간 쌓아온 지식들을 단 돈 3만원에 이렇게 들을 수 있다는게 너무 감사하네요. 저희 회사에도 이런 분이 계셨으면 좋겠습니다.
- 김영헌Instructor
좋은 수강평 감사합니다.
- green4s
Reviews 1
∙
Average Rating 5.0
$26.40
Similar courses
Explore other courses in the same field!
![풀스택을 위한 도커와 최신 서버 기술(리눅스, nginx, AWS, HTTPS, 배포까지) [풀스택 Part3]강의 썸네일](https://cdn.inflearn.com/public/courses/326771/cover/bc862b4d-abe6-4d80-a826-3a5324a9f998/326771-eng.png?f=avif&w=420)
![[백문이불여일타] 데이터 분석을 위한 기초 SQL강의 썸네일](https://cdn.inflearn.com/public/courses/324566/cover/aa1fac55-6e80-4506-9c92-f32c2b65f93a/sql_basic.png?f=avif&w=420)