MySQL for Hundreds of Millions of Platform Data: Insights from a Kakao Interviewer

Most developers are still stuck on Batch and CronJobs when it comes to data processing. However, in real-world production environments, data is generated continuously, and failing to process that flow immediately leads to latency, bottlenecks, and consistency issues. Having personally dealt with real-time recommendations, state synchronization, and event delay problems in high-traffic environments, I’ve often asked myself, "Is batch processing really the right approach for this?" This course begins with that very question. It explores how to use Apache Flink to perform computations the moment data flows, manage state securely, and produce accurate results based on Event Time—all from a practical perspective. Beyond simple theoretical explanations, you will experience how real-time stream processing systems are designed and operated through actual source code and architectures. For those who found real-time processing vague or were curious about the world beyond messaging, this course will provide a clear sense of direction.

When you're doing backend development, at some point you face this dilemma. As services grow and traffic increases, there comes a moment when simple REST communication and CRUD structures feel limiting. I experienced the same problem in real-world work and went through many trials and errors between performance and structural complexity. The solution I chose in that process was NATS. Its simple configuration based on a single binary, ultra-low latency performance in microseconds, and the fact that it provides just the right amount of essential features for real work—from Pub/Sub to Queue Groups and JetStream—made it a very practical choice in actual service environments. This course is not about listing NATS features. Based on the problems I faced in real work, I explain with code and flow diagrams which situations led me to choose NATS, why, and how I designed the architecture. This is a course designed to help everyone—from those new to messaging systems, to backend developers preparing for jobs, to senior developers contemplating better architectures—understand distributed systems and grow to the next level.

This course covers RPC communication techniques that maximize performance in large-scale MSA (Microservice Architecture) environments. Going beyond simple gRPC practice, you'll learn how to implement stable and efficient inter-service communication in real production environments where hundreds of microservices operate simultaneously. Based on Golang, the course covers Protocol Buffers (proto) syntax writing, automatic code generation and service implementation, gRPC structure and advantages over existing RPC, and performance optimization strategies with a practical focus. To ensure easy understanding for non-majors and server development beginners, the course provides step-by-step explanations from RPC concepts to gRPC's internal operating principles, enabling you to develop practical skills that can be immediately applied to real services.

Develop a scalable order processing system with real-time event streaming capabilities using Spring Boot 3.x + Kotlin to build a Kafka cluster, leveraging PostgreSQL CDC, Debezium Connect, and Apache Avro schema.

Learn the process of building data pipelines using Apache Airflow from basics to practical application. Understand Airflow's core concepts and architecture, and master advanced design patterns frequently used in practice such as dynamic DAGs, parallel processing, distributed processing, and Custom Operators through hands-on exercises. Set up a practice environment with Python and Docker, and develop practical skills to design and operate real workflows.

Learn how to design and process large-scale data architecture that handles hundreds of billions of data records using only pure SQL and MySQL's core features, together with a Toss developer who handles hundreds of billions of financial traffic transactions and a developer who started as a non-major and is now developing platforms in Pangyo.

Learn the process of building essential Observability in a Microservices Architecture (MSA) environment from basics to practical application. Master standardized data collection using OpenTelemetry, trace storage and search through Grafana Tempo, and visualization using TraceQL through step-by-step hands-on practice. You can learn how to track service flows through distributed tracing, identify bottlenecks, and analyze the root causes of failures.

How do you handle exploding traffic? Learn how to build resilient and flexibly scalable architectures through practical design patterns based on EDA (Event-Driven Architecture) using Kafka, Spring, CDC, and Temporal. Explained clearly and simply with real-world experience from a Kakao developer, making it accessible even for non-majors. A hands-on, practical course covering real-time data flow, event processing, and microservice integration all at once!

I am covering the know-how on how I studied and got a job, starting as a non-major.

I'll show you how to use Redis effectively, along with its precautions and best practices, using real-world examples from actual work environments and well-known case histories.

This course explores microservice architecture and distributed environments not as a simple list of technologies, but from a 'design perspective' required in actual work and interviews. Starting from the differences between monolithic and MSA, it progressively covers incremental migration strategies, modular monoliths, clean architecture and hexagonal architecture, clearly explaining why each choice is necessary and the trade-offs involved. Through hands-on practice, you can directly verify the intent of the structure and learn about core issues inevitably encountered in distributed environments—such as data consistency, transactions, inter-service communication, and failure handling—through realistic scenarios. Based on actual questions and perspectives from Kakao interviewers, this course aims to go beyond simple knowledge acquisition and elevate your way of thinking about distributed systems to the next level.

Learn SAGA transaction management techniques for maintaining data consistency in distributed environments through hands-on practice. Build 3 microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns with Kafka and MySQL. Through this course, you can master core concepts that are immediately applicable in real-world scenarios, including distributed transaction operation principles, compensating transaction design, and failure recovery handling.

Using Spring Boot 3.x + Kotlin, we build a 3-instance cluster, and utilizing Redis Pub/Sub distributed messaging and an Nginx load balancer, develop a scalable WebSocket real-time chat server capable of handling large-scale traffic.

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

This course is a master class that teaches Kotlin's 🌺 Coroutine, covering everything from theoretical foundations to practical application in a standard manner. It systematically covers core principles and structure, the necessity of asynchronous programming, Coroutine builders and scopes, exception handling, channels, Flow, and other key features frequently used in practice, step by step. Each concept is explained with hands-on examples, making it easy for beginners to understand and immediately apply them. This is the best introductory and practical course for developers who want to build strong Coroutine skills for real-world use.

Let's build a project using Ktor, the most popular project in Kotlin, and master Kotlin! 😆

Kotlin mastery via virtual payment server course.

In this course, rather than directly covering theory, you will learn how to effectively use Redis in code through hands-on practice.

You can learn about JWT and ws communication using Spring Boot, and how to handle high TPS.

I learned it the hard way, so you can learn it the easy way I've discarded unnecessary theory and included only the SQL essentials. Quickly build your SQL confidence.

If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

I've created a 'DB Design Beginner/Practical' course that even non-majors can easily understand and apply directly in real-world situations!

Numpy and Pandas are the foundation of data analysis and the backbone of AI frameworks, and I've packed this course with the core practical know-how I've accumulated through my work and teaching experience. I've designed it with a hands-on approach so that marketers, planners, and beginner analysts can easily follow along with data cleaning and processing—the areas where they most often get stuck. Through this course, anyone can develop the skills to handle data and produce analysis results on their own, without needing help from developers.

"Let's put an end to Spring Batch. Putting a stop to the dark ages of batch code.💀"

As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.

You can master Database development, which is essential for mobile/web development, through MySQL.

This is a course to learn about Airflow, an Orchestration tool for efficiently building and managing data pipelines. Welcome to the Airflow Master Class, where even beginners can learn step-by-step!

How do you handle exploding traffic? Learn how to build resilient and flexibly scalable architectures through practical design patterns based on EDA (Event-Driven Architecture) using Kafka, Spring, CDC, and Temporal. Explained clearly and simply with real-world experience from a Kakao developer, making it accessible even for non-majors. A hands-on, practical course covering real-time data flow, event processing, and microservice integration all at once!

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

You can learn the core concepts of GA4 (Google Analytics) e-commerce setup, which is too difficult to learn on your own by searching the internet, through hands-on practice. Performance marketers and beginner developers who are setting up GA4 e-commerce for the first time can easily understand by practicing step-by-step setup on a cafe24 demo shopping mall. Since the developer's role is handled by chatgpt during the practice, marketers and PM/planners without specialized development knowledge can also learn about GA4 e-commerce setup.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

Learn SAGA transaction management techniques for maintaining data consistency in distributed environments through hands-on practice. Build 3 microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns with Kafka and MySQL. Through this course, you can master core concepts that are immediately applicable in real-world scenarios, including distributed transaction operation principles, compensating transaction design, and failure recovery handling.

This course proceeds in stages, similar to the actual work, by learning and applying the necessary knowledge while configuring the infrastructure.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

"Turn your Java code into the hands and feet of AI! Practical Agent Development with Kakao PlayMCP and Spring AI" Traditional LLMs are limited to answering based only on their trained data, which can lead to issues with recency and accuracy. In this course, you will learn **MCP (Model Context Protocol)**—the next-generation standard protocol for connecting AI with external tools. Using Spring AI, you will build a server that communicates with various platforms like Kakao PlayMCP through a single implementation. Master the entire process from theory to real-world deployment and platform registration through the 'Proverbs & Psalms Counseling Center (JAMSI)' project, and grow into a true AI agent developer who can empower AI to handle tools independently.

This is a course on creating a practical Unity game with a database. You can learn through lectures about aspects that are difficult to encounter.

Spring AI + JPA + MySQL Premium Reservation Agent Backend Development with 'Autonomous Behavior' Beyond Chatbots to Agents: The Definitive Guide to Tool Calling and Prompt Engineering

Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!