We saw in the previous post how we can deal with data stored in the new VECTOR datatype that was released with MySQL 9.0.

We implemented the 4 basic mathematical operations between two vectors. To do so we created JavaScript functions. MySQL JavaScript functions are available in MySQL HeatWave and MySQL Enterprise Edition (you can use MySQL EE for free while learning, developing, and prototyping as mentioned here).

For the MySQL Community Users, extending the operations dealing with Vectors can be done by implementing User Defined Functions …

A couple of weeks ago, my colleague Marco Tusa published an important announcement titled “Do Not Upgrade to Any Version of MySQL After 8.0.37.” The announcement highlighted a critical issue in MySQL 8.0.38, MySQL 8.4.1, and MySQL 9.0.0 that caused database server crashes. Good news! The upcoming minor releases for the community edition of MySQL and […]

In this article we see how we can create a component to add UDFs functions to deal with the VECTOR datatype in MySQL.

How to deal with VECTORS in MySQL HeatWave and Enterprise Edition using JavaScript

MySQL 9.0.0 has brought the VECTOR datatype to your favorite Open Source Database.

There are already some functions available to deal with those vectors:

• STRING_TO_VECTOR()
• VECTOR_DIM()
• VECTOR_TO_STRING()

This post will show how to deal with vectors and create our own functions to create operations between vectors.

We will use the …

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to when exporting table data to different formats.

Regular expressions are a powerful tool for developers. In this post we will demonstrate how to use regular expressions backreferences in MySQL.

Dear Kris,

We have a number of old MySQL instances, version 5.5 and 5.6. We want to upgrade them to a current version of MySQL. The databases are between 0.5 TB to 8 TB in size.

Unfortunately, using rsync on a stopped MySQL instance is not an option because the versions are too different, and the new version seems unable to read the binary data. I could use a dump (multi-threaded), but importing a single file with mysql takes forever (it would need to be single-threaded).

Would you simply create a dump per table and then import them in parallel? Or has MySQL improved, allowing for better import methods now?

That is a lot to unpack.

A consistent backup and a binlog position

First off, a backup needs to be consistent. You cannot make a backup of individual tables, one after the …

Learn about the options for running non-blocking schema changes natively to MySQL, using Vitess, or other tools

pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But if you have foreign keys, this could be an interesting and important read for you. Tables with foreign keys are always complicated, and they have to be handled with care. The use case I am […]