The latest from the MySQL community

Episode #62 of MySQL Shorts in now available!

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.

This story starts with a pull request for go-mysql to allow setting the collation in auth handshake that I was reviewing. The reason why the author wanted to do this is to speedup the connection setup as he has a latency sensitive application and a lot of connection setups and tear downs.

While looking at this I noticed that the collation would be stored in a single byte. However the list of supported collations shows collations with an ID that’s more than 255.

mysql> SELECT MIN(ID),MAX(ID) FROM information_schema.collations;
+---------+---------+
| MIN(ID) | MAX(ID) |
+---------+---------+
|       1 |     323 |
+---------+---------+
1 row in set (0.00 sec)

The …

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 […]