On MySQL 8.0.41, when the "defaultMode" is "js" in the shell options file (~/.mysqlsh/options.json) but the binary doesn't support JavaScript, it returns a Segmentation fault.

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-configuring-options.html

#mysql #mysqlshell #percona #python #javascript

MySQL :: MySQL Shell 8.0 :: 13.4 Configuring MySQL Shell Options

I see they’ve renamed this to “libjitexecutor.so” in 8.0.42, which better conveys its purpose! #mysql #mysqlshell #libjitexecutor
MariaDB/MySQL: Migrate from MariaDB to MySQL (using MySQL Shell)

This blog post is about how to migrate from MariaDB to MySQL using MySQL Shell.

Martin's Blog

Huh, the latest version of mysql-shell (8.0.41) drops a /usr/lib/mysqlsh/libpolyglot.so that's 175MB.

Not much documentation out there about "libpolyglot.so" but from what I gather it's part of GraalVM, which compiles Java to native binaries. Now mysqlsh is a 30MB binary + 175MB of library. Leave it to Oracle... #mysql #mysqlshell #libpolyglot

MySQL Error Log: Got packets out of order
Some users, myself included, have noticed that their MySQL error log contains many lines like this one:

2024-09-06T09:28:40.522161Z 17 [Note] [MY-010914] [Server] Got packets out of order

Where does that error come from?

The error MY-010914 is part of the Server Network issues like:

Aborted connection XX to db: ...

Bad handshake

Got
https://lefred.be/content/mysql-error-log-got-packets-out-of-order/
#80 #90 #MySQL #MySQLShell

MySQL Error Log: Got packets out of order

Some users, myself included, have noticed that their MySQL error log contains many lines like this one: 2024-09-06T09:28:40.522161Z 17 [Note] [MY-010914] [Server] Got packets out of order Where doe…

lefred blog: tribulations of a MySQL Evangelist

MySQL Shell for VS Code – Bastion Host & Invalid fingerprint detected
If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI.

If you already have a connection setup using a bastion to host, you may experience the same problem as me, MySQL Shell complains about a
https://lefred.be/content/mysql-shell-for-vs-code-bastion-host-invalid-fingerprint-detected/
#Cloud #HeatWave #MDS #MySQL #MySQLShell #OCI

MySQL Shell for VS Code – Bastion Host & Invalid fingerprint detected

If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI. If you already have a connection setup using a bastion t…

lefred blog: tribulations of a MySQL Evangelist
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the applica
https://lefred.be/content/wordpress-in-oci-with-mysql-heatwave-read-replicas-and-mysql-router-r-w-splitting/
#80 #82 #Cloud #MDS #MySQL #MySQLShell #OCI #Replication #Router #wordpress
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting

Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Wri…

lefred blog: tribulations of a MySQL Evangelist

Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1
I won't cover reasons why you should migrate from MariaDB to MySQL, I already covered the topic in previous blogs and webinars:

How to Migrate from MariaDB to MySQL HeatWave

How to Migrate from MariaDB to MySQL 8.0

Migrating from MariaDB to MySQL using MySQL Sh
https://lefred.be/content/migrate-from-mariadb-to-mysql-heatwave-easier-with-mysql-shell-8-2-1/
#80 #82 #Cloud #HeatWave #MDS #MySQL #MySQLShell #OCI

Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1

I won’t cover reasons why you should migrate from MariaDB to MySQL, I already covered the topic in previous blogs and webinars: How to Migrate from MariaDB to MySQL HeatWave How to Migrate fr…

lefred blog: tribulations of a MySQL Evangelist

MySQL Shell AdminAPI: different ways to call the commands… same effect?
During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell.

He wanted to know why, in the manual and blogs, we always use separate commands instead o
https://lefred.be/content/mysql-shell-adminapi-different-ways-to-call-the-commands-same-effect/
#InnoDBCluster #MySQL #MySQLShell

MySQL Shell AdminAPI: different ways to call the commands… same effect?

During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell. He…

lefred blog: tribulations of a MySQL Evangelist

Backup your MySQL instance in the Cloud
Since MySQL Shell 8.1, it's even easier to create a logical backup of your MySQL instance and store it directly in Object Storage, an internet-scale, high-performance storage platform in Oracle Cloud Infrastructure (OCI).

IMySQL Shell now offers the option of dumping to Object Storage Bucket using PAR (Pre-Authenticated Request
https://lefred.be/content/backup-your-mysql-instance-in-the-cloud/
#81 #Cloud #HeatWave #MDS #MySQL #MySQLShell #OCI

Backup your MySQL instance to the Cloud

Since MySQL Shell 8.1, it’s even easier to create a logical backup of your MySQL instance and store it directly in Object Storage, an internet-scale, high-performance storage platform in Orac…

lefred blog: tribulations of a MySQL Evangelist