Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]

Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […]

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to the global Intl object in a MySQl stored function.

MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Database Service. These are the latest General Availability (GA) releases as of April 30, 2024. New release model, first LTS Release In the summer of 2023, MySQL announced plans move to a new LTS and Innovation release model planning […]

MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Service. These are the latest General Availability (GA) releases as of April 30, 2024.

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to filter an array of objects based on the value of one of the properties of the object.

MySQL NDB Cluster is a highly available and performant database with a shared-nothing architecture powering its linear scalability. Replication with MySQL NDB Cluster provides active-active geographical replication, allowing better data locality and disaster recovery with backup sites. Thus, it can serve a large number of clients at the same time in a global Cloud environment. […]

As I mentioned in some previous posts, MySQ: HeatWave and MySQL Enterprise support writing stored functions using JavaScript. When I started playing around with this feature, I wanted to know how much support there was for global JavaScript objects. There is a lot of support for these, and in this post, we will talk about using the […]

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36-26.18 (release notes, download). There is no change to the Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

This is a …

Learn how to setup MySQL NDB Cluster replication using redundancy to continuously replicate data and be fully online during upgrade and maintenance.