The latest episode of MySQL Shorts is now available.
Managing cloud resources is a continuous challenge for enterprises. Many organizations move to the cloud to reduce operational costs and enhance business agility. Early adopters often allowed their business units to deploy infrastructure quickly to become more agile and better serve their customers. However, this approach has led to a rapid spread of data and […]
As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the early years.
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 […]