AI Briefing#mysql
The latest AI and developer news about #mysql, with the original source and a short summary.
The latest AI and developer news about #mysql, with the original source and a short summary.
This traces, through debugging, the cause of a MySQL escape string handling error that occurred while using the Exposed ORM.
Kakao Pay analyzed how JPA's @Transactional settings affect DB performance and improved query performance by removing unnecessary transactions.
The Kurly team resolved an OOM issue caused by a connection leak that occurred after switching the MySQL connector, using Heap Dump analysis.
An analysis of paging omissions and SQL errors in Spring Batch 5.2.0 caused by how MySqlPagingQueryProvider handles sortKey, along with proposed solutions.
The team details their integration of Flink CDC with Apache Iceberg, addressing challenges in sharded table consolidation, commit conflicts, and performance optimization.
The integration with MySQL based on Flink CDC 2.4.1 applied step-wise Kafka topic separation and DDL security response logic.
Kakao's Data Analytics Platform team detailed their production implementation of Apache Flink CDC to minimize database load while ensuring real-time data consistency.
Aurora MySQL's load balancing issues and cost problems were resolved using Maxscale.
The overlap between MariaDB Connector/J's Aurora mode and the open-in-view setting caused the Master DB's Snapshot to not be refreshed, resulting in data not being retrievable, and this was resolved.
This summarizes how to switch the soon-to-expire RDS CA certificate to a new CA and whether a restart is required.
This covers the process and incident encountered while attempting an **online alter** to add a new column to a large-scale MySQL table.
Starting from MySQL 8.0.28, TLS 1.0/1.1 support was removed, causing older clients to fail to connect.
Banksalad used AWS DMS to consolidate over 50 RDS clusters into 5-10 clusters per domain, reducing costs to one-third.
Separating the loan comparison DB from the credit management service reduced load and coupling.
MySQL timestamp suffers from the Y2K38 Problem in 2038 due to its 32-bit limitation.
To reduce the DB load that occurs when aggregating large volumes of data, a new Aggregation architecture is proposed instead of complex GroupBy queries.
This explains the limitations of the Reader that determine performance in large-scale batch data processing and the optimization approaches to overcome them.
This shares the planning process of the 'Re:Review' project, a review service developed by new developers on Olive Young's Service Development Team.
Oli, a Kakao DBA who joined through the 2020 new graduate recruitment, shared his experience managing company-wide MySQL and the appeal of the role.
An analysis and fix for a lookup failure caused by MySQL's right-padding when storing UUIDs as BINARY(255) in JPA.
Due to page locking structures and unidirectional Linked Lists during Backward Scans, performance differences of up to 44% occur.
Worked directly with MySQL in Python, learning CSV import/export and DB CRUD operations.
It presents a strategy for scaling shards up or down without real-time data conflicts by running Binlog and Table Crawler in parallel, and shares a data verification approach based on full scans.
It supports everything from MySQL data collection to loading into other DBs, while the custom handler for shard redistribution is currently in the verification stage.