Skip to main content

MySQL Overview

KakaoCloud MySQL is a fully managed relational database management system (RDBMS) service based on the open-source MySQL Community Edition. You can create MySQL instances from the console without separate installation or complex configuration, and operate them securely in a logically isolated VPC environment.

For detailed information about MySQL, refer to the official MySQL documentation.

Terminology
  • Relational Database: A database that stores data in tables composed of rows and columns and uses SQL to define, query, and modify data. It is suitable for managing data integrity based on predefined schemas and relationships.
  • RDBMS (Relational Database Management System): Software that creates, operates, and manages relational databases. MySQL is a representative open-source RDBMS used in various applications, including web services and business systems.

Supported versions​

KakaoCloud MySQL provides service based on MySQL 8.x, and detailed patch and minor versions will continue to be added.
The latest version currently provided is 8.4.8. For detailed release information, see the MySQL 8 release notes.

Supported features and end-of-life (EOL) schedules may differ by version. Versions past EOL no longer receive security patches, so refer to the official documentation and select a version appropriate for your operating environment.

Supported Engines and Versions
  • MySQL: 8.0.34, 8.0.41, 8.0.44, 8.0.45, 8.4.7, 8.4.8

Purpose and use cases​

MySQL is used as a data store for applications that require data integrity and a relational data model. It is suitable for environments such as web and mobile services where user requests occur continuously and transaction-based data management is required.

  • Services that need to manage user information, such as authentication, accounts, and permissions
  • Services that need to manage relational data, such as orders, payments, products, and content
  • Services that require continuous data input and lookup, such as game servers and IoT data collection
  • Services that need data recovery and inspection using point-in-time recovery and log export

Key features​

Relational application database​

  • Can be used for various applications such as web, mobile, and e-commerce services that require data integrity and relational data models
  • Provides key operational functions in the console, including instance group creation, backup, restore, and monitoring

Point-in-time recovery and log utilization​

  • Restores a new instance group to data from a specific point in time using automated backups and binary logs
  • Supports querying Slow Query and exporting general logs, error logs, slow query logs, and binary logs to Object Storage

High availability based on Primary and Standby​

  • Creates a Primary instance and multiple Standby instances in a high availability configuration
  • Responds to failures through auto failover and manual failover
  • Adds Standby instances for high availability and read-only replica usage

Instance and operational setting management​

Instance type options​
  • Provides various instance types for use from test environments to high-performance workloads
  • Supports flexible resource operations by changing instance types according to workload changes
  • Provides metrics for system status such as CPU and memory usage and database status such as connection count and average response time
  • Provides instance group operation features such as parameter group changes, volume expansion, and automated backup configuration

Network and security​

Security controls​
  • Deploys MySQL instances in a logically isolated VPC network to control external access
  • Uses security groups to allow database access only from permitted IP ranges and ports

Getting started​

If you are using MySQL for the first time, start with Key concepts to understand the resource structure and operational concepts. For actual procedures such as creating instance groups, backups, and failover, see How-to guides.

If you are new to KakaoCloud, see Getting started with KakaoCloud.