The latest Episode of MySQL Shorts is now available! Check out Episode 79 on the MySQL YouTube Channel to learn how to convert non-ISO conforming date formats into conforming ISO dates.

Next year, MySQL will celebrate its 30th anniversary. I started using MySQL in 2001 when I landed my first job as a web developer. Since that time, I have always had at least one project in production that used MySQL to store and retrieve data on the backend. For this year’s Advent Calendar of Content, we are […]

MySQL NDB Cluster (NDB) is truly amazing. High availability and durability built into its design. Blazingly fast. Online scalable and upgradable. NDB serves your critical applications or infrastructure with its proven five 9’s availability. It’s capable of running millions of transactions per second – with no downtime while increasing your database size, or during upgrades. These are all reasons why […]

Learn about the merge replication topology used for building scalable, bi-directional, multi-primary replication deployments using MySQL NDB Cluster. This topology makes it possible to reliably scale out circular replication forming three, four, or more clusters all containing the same data.

MySQL 8.4 changes the default values of built-in configurations when compared to MySQL 8.0. These changes are designed to auto adapt with the machine making the MySQL server production ready out of the box.

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote four posts on the subject, they are listed below.  In this post, I use the system analysis of the previous post to revisit the light optimization on EBS volumes.  With this analysis, I am able to determine why the previous tests did not show

MySQL Shell is an advanced command-line client and code editor for MySQL.  Besides being able to run SQL commands, MySQL Shell provides scripting capabilities for JavaScript and Python from within Shell.  But, you can also use shell to run JavaScript outside of the command-line code editor.  In other words, you can execute a JavaScript like […]

Lina One, the sales subsidiary of Lina Life Insurance, is at the forefront of the insurance industry in South Korea. Part of the Lina Korea group and affiliated with Chubb, the world’s largest publicly traded insurance company, Lina One is integrating telemarketing operations for both life and non-life insurance products across six call centers. With a workforce of 2,000 agents dedicated to customer-focused […]

How to use MySQL Shell to run JavaScript and Python scripts to connect to a MySQL database and execute queries. In this example, I show you how to dump and load a database table with a JavaScript script.

Last month we released MySQL 9.1, the latest Innovation Release. Of course, we released bug fixes for 8.0 and 8.4 LTS but in this post, I focus on the newest release. Within these releases, we included patches and code received by our amazing Community. Here is the list of contributions we processed and included in […]