home.social

#mysqlshell — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #mysqlshell, aggregated by home.social.

  1. Julien Riou @[email protected] ·

    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.

    dev.mysql.com/doc/mysql-shell/

    #mysql #mysqlshell #percona #python #javascript

    #mysql #mysqlshell #percona #python #javascript
  2. Julien Riou @[email protected] ·

    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.

    dev.mysql.com/doc/mysql-shell/

    #mysql #mysqlshell #percona #python #javascript

    #mysql #mysqlshell #percona #python #javascript
  3. Julien Riou @jriou ·

    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.

    dev.mysql.com/doc/mysql-shell/

    #mysql #mysqlshell #percona #python #javascript
  4. Julien Riou @[email protected] ·

    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.

    dev.mysql.com/doc/mysql-shell/

    #mysql #mysqlshell #percona #python #javascript

    #javascript #python #percona #mysqlshell #mysql
  5. Julien Riou @[email protected] ·

    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.

    dev.mysql.com/doc/mysql-shell/

    #mysql #mysqlshell #percona #python #javascript

    #mysql #mysqlshell #percona #python #javascript
  6. shaun @[email protected] ·

    I see they’ve renamed this to “libjitexecutor.so” in 8.0.42, which better conveys its purpose! #mysql #mysqlshell #libjitexecutor

    #mysql #mysqlshell #libjitexecutor
  7. Martin @[email protected] ·

    blog.martinscloud.com/mariadb- #oracle #mysql #mariadb #migration #mysqlshell #mysql-shell #mysql_shell

    #oracle #mysql #mariadb #migration #mysqlshell #mysql_shell
  8. shaun @[email protected] ·

    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 #mysqlshell #libpolyglot
  9. lefred @lefred ·

    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
    lefred.be/content/mysql-error-
    #80 #90

    #mysql #mysqlshell
  10. lefred @lefred ·

    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
    lefred.be/content/mysql-shell-

    #cloud #heatwave #mds #mysql #mysqlshell #oci
  11. lefred @lefred ·

    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
    lefred.be/content/wordpress-in
    #80 #82

    #cloud #mds #mysql #mysqlshell #oci #replication
  12. lefred @lefred ·

    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
    lefred.be/content/migrate-from
    #80 #82

    #cloud #heatwave #mds #mysql #mysqlshell #oci
  13. lefred @lefred ·

    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
    lefred.be/content/mysql-shell-

    #innodbcluster #mysql #mysqlshell
  14. lefred @lefred ·

    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
    lefred.be/content/backup-your-
    #81

    #cloud #heatwave #mds #mysql #mysqlshell #oci
  15. lefred @lefred ·

    How to copy a MySQL instance ?
    To copy a MySQL server to another server or to the cloud, there are several ways.

    We can distinguish between two different types of copy:

    physical copy

    logical copy

    The physical copy is often the fastest. However, it requires some tools to ensure that you have a consistent online backup. For example, you can use MySQL Enterpris
    lefred.be/content/how-to-copy-
    #80 #81

    #clone #cloud #heatwave #mds #mysql #mysqlshell
  16. lefred @lefred ·

    Cut & Paste a User Creation Statement with MySQL 8
    Sometimes it's convenient to retrieve the user creation statement and to copy it to another server.

    However, with the new authentication method used as default since MySQL 8.0, caching_sha2_password, this can become a nightmare as the output is binary and some bytes can be hidden or decoded differently de
    lefred.be/content/cut-paste-a-
    #80 #81

    #cloud #heatwave #mds #mysql #mysqlshell #oci
  17. lefred @lefred ·

    How to Migrate from MariaDB to MySQL HeatWave
    We see an increase in the demand for database migration from MariaDB to MySQL. This is likely due to recent news about MariaDB. [1][2][3][4][5][6][7][8]

    In this article, we will show you how to migrate from MariaDB to MySQL HeatWave in Oracle Cloud Infrastructure (OCI).

    If you plan to migrate from
    lefred.be/content/how-to-migra
    #80

    #cloud #heatwave #mds #mysql #mysql80 #mysqlshell
  18. lefred @lefred ·

    Query and Transaction size in MySQL
    Some times it's important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster.

    Today we will see the different possibilities to have an idea of the size of transactions.

    First we need to split the t
    lefred.be/content/query-and-tr
    #8.0 .0

    #mysql #mysql8 #mysqlshell #performance_schema
  19. lefred @lefred ·

    MySQL Shell for Visual Studio Code v1.9.1 has been released today ! 🐬🐚

    #mysql #mysqlshell #vscode
  20. lefred @lefred ·

    Kenny Gryp is announcing MySQL Shell 8.0.32 🐬🐚blogs.oracle.com/mysql/post/an

    #mysql #mysqlshell
  21. lefred @lefred ·

    Generating an OCI MySQL HeatWave Slow Query Log with MySQL Shell blogs.oracle.com/mysql/post/ge 🐬🔥🐚❄️📅

    #mysql #mysqladvent2022 #oci #mysqlshell
  22. lefred @lefred ·

    MySQL Community Advent Calendar 2022 - Creating Aliases in MySQL Shell 🐬🐚❄️ blogs.oracle.com/mysql/post/cr

    #mysql #mysqlshell #mysqladvent2022
  23. lefred @lefred ·

    MySQL
    Community Advent Calendar : today's box by Scott
    - connecting MySQL Shell Over SSH blogs.oracle.com/mysql/post/co 🐬❄️🔐

    #mysql #mysqlshell #mysqladvent2022
  24. lefred @lefred ·

    Today's box in the MySQL Content Advent Calendar 2022 is presented by my colleague Scott
    blogs.oracle.com/mysql/post/my ❄️🐬

    #mysql #mysqlshell #mysqladvent2022
  25. lefred @lefred ·

    MySQL Advent 2022 Blog Post Calendar - blogs.oracle.com/mysql/post/al

    #mysqladvent2022 #mysql #mysqlshell
  26. lefred @lefred ·

    MySQL 101 - Part 4: How to install Shell 🐚 for Visual Studio Code youtu.be/vpPDjL_3OKQ 🐬

    #mysql #mysqlshell #code #developers
  27. lefred @lefred ·

    MySQL 101 Episode 3: How to install Server and MySQL Shell on Windows youtu.be/uPWKXBXePy4

    #mysql #mysqlshell #mysql8isgreat #microsoft #windows #beginners
  28. lefred @lefred ·

    @adamtuttle take a look at MySQL Shell Dump & Load utility dev.mysql.com/blog-archive/mys

    #mysql #mysqlshell