This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…
The post MySQL Data Archiving basics – considerations, mistakes, best practices first appeared on Change Is Inevitable.
MySQL 8.0 will reach End-Of-Life (EOL) in April 2026. This means that HeatWave MySQL will no longer provide support or updates for MySQL 8.0 after this date. Customers should upgrade to newer supported version of HeatWave MySQL 8.4 LTS much ahead of the April 2026 deadline. This announcement is to provide customers with sufficient time to migrate their DB systems from 8.0 to the latest LTS release track. This article is exclusive to the cloud service version (HeatWave MySQL).
MySQL 8.4 has two good options for High Availability clusters: Galera Cluster (and Percona XtraDB Cluster (PXC)) plus MySQL InnoDB Cluster. Both solutions are now mature enough, so what is the deciding factor? Workload characteristics, application compatibility (Galera is virtually synchronous; InnoDB Cluster offers 2 modes – single primary mode, which is one instance being read-write, with the rest being read only, and multi-primary mode, which is closer to what Galera Cluster is) and operational preferences, most likely will decide which one comes out top in 2025, is what we aim to answer at next week’s webinar.
Due to the lack of real-world usage statistics (we can tell you how many Galera Cluster downloads we have, for example, or even customer numbers, but we won’t have anything to compare against), we look at proxy statistics, like …
[Read more]In Percona Server for MySQL 8.0.41 / 8.4.4, we introduced several improvements in Encryption User-Defined Functions. Added support for RSAES-OAEP (OAEP) padding for RSA encrypt / decrypt operations. Added support for RSASSA-PSS (PSS) padding for RSA sign / verify operations. Added new encryption_udf.legacy_padding_scheme component system variable. Normalized character set support for all Encryption UDFs. PKCS1 […]
For users of HeatWave Service, the maintenance process can sometimes feel like a black box. What does it entail? How does it differ from version upgrades? When and how are updates applied? With questions like these swirling around, it’s time to unpack the mechanics of HeatWave maintenance and shed light on its purpose, scope, and flexibility. Whether you’re managing a production database or planning a deployment, this guide will help you navigate the process with confidence.
Time zones, truncation, formatting nightmares—oh MySQL, why so complex? Learn the key differences between TIMESTAMP and DATETIME, when to use each, and how to prevent time-based bugs in your queries.
The post MySQL Date Format: Understanding Date, Time, and Datetime in MySQL appeared first on Devart Blog.
Most database performance issues don’t start with complex queries or heavy traffic—they begin at the foundation: data type selection. One seemingly small decision—CHAR vs. VARCHAR—can dictate whether your database remains fast and efficient or bloated and sluggish as it scales. It’s a mistake even experienced developers make, and it’s easy to see why. At a […]
The post Key Differences Between VARCHAR And CHAR in MySQL appeared first on Devart Blog.
Need MySQL database hosting? Learn how to host a MySQL database on cloud, VPS, or local servers. Compare costs, features, and providers.
The post How to Host MySQL Databases: Best Methods & Hosting Solutions appeared first on Devart Blog.
Learn how to use ENUM in MySQL to store predefined values efficiently. Find syntax, examples, and best practices for the ENUM data type.
The post ENUM Data Type in MySQL: Syntax, Examples and Best Practices appeared first on Devart Blog.
The TIMESTAMPDIFF() function in MySQL calculates differences between two points in time. This article explores TIMESTAMPDIFF(), covering its syntax, everyday use cases, and best practices for real-world applications.
The post MySQL TIMESTAMPDIFF() Function: Syntax, Examples & Use Cases appeared first on Devart Blog.