Fosstodon

Martin<a href="https://blog.martinscloud.com/mariadb-mysql-migrate-from-mariadb-to-mysql-using-mysql-shell/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://blog.martinscloud.com/mariadb-mysql-migrate-from-mariadb-to-mysql-using-mysql-shell/</a> <a href="https://dresden.network/tags/oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#oracle</a> <a href="https://dresden.network/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://dresden.network/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mariadb</a> <a href="https://dresden.network/tags/migration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#migration</a> <a href="https://dresden.network/tags/mysqlshell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysqlshell</a> <a href="https://dresden.network/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a>-shell <a href="https://dresden.network/tags/mysql_shell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql_shell</a>

shaunHuh, 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... <a href="https://mastodon.xyz/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://mastodon.xyz/tags/mysqlshell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysqlshell</a> <a href="https://mastodon.xyz/tags/libpolyglot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#libpolyglot</a>

lefredMySQL 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 orderWhere does that error come from?The error MY-010914 is part of the Server Network issues like:Aborted connection XX to db: ...Bad handshakeGot <a href="https://lefred.be/content/mysql-error-log-got-packets-out-of-order/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/mysql-error-log-got-packets-out-of-order/</a> #80 #90 <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a>

MySQL CommunityDo you think creating an InnoDB replica set with MySQL is difficult?What if we told you you can perform that task with as few as two commands with MySQL Shell?Check out @boyzoid 's latest blog post to learn how.<a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a> <a href="https://fosstodon.org/tags/innodb" class="mention hashtag" rel="tag">#innodb</a> <a href="https://blogs.oracle.com/mysql/post/create-an-innodb-replica-set-with-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/create-an-innodb-replica-set-with-mysql-shell</a>

MySQL CommunityNow that Scott showed you some advanced options for dumping data with MySQL Shell, it's time to talk about some options that make loading data quicker and easier.Check out this blog post for the details.<a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a><a href="https://blogs.oracle.com/mysql/post/advanced-data-load-with-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/advanced-data-load-with-mysql-shell</a>

MySQL CommunityWe can use MySQL Shell as part of a scripted process to perform tasks such as dumping/loading data.Scott's latest blog post demonstrates how to accomplish this and gives some examples of the slightly different syntax for doing so.<a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a><a href="https://blogs.oracle.com/mysql/post/mysql-shell-cli-integration" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/mysql-shell-cli-integration</a>

MySQL CommunityOne of the most favorite (and most used) features of MySQL Shell is the ability to easily dump tables, schemas, or an entire instance in a single command.In this blog post, Scott discusses some options we can use to make this process quicker and easier. <a href="https://blogs.oracle.com/mysql/post/advanced-data-dump-with-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/advanced-data-dump-with-mysql-shell</a><a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a> <a href="https://fosstodon.org/tags/MySQLCommunity" class="mention hashtag" rel="tag">#MySQLCommunity</a>

MySQL CommunityIf someone told you that you can learn to create an InnoDB replica set using MySQL Shell in about 3 minutes, you would think he was daft, wouldn't you?Well...there's a MySQL Short for that!<a href="https://www.youtube.com/watch?v=hGsI_vkIfmY&list=PLWx5a9Tn2EvG4C90YFJ9eU61IpALeE0SN&index=68" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://www.youtube.com/watch?v=hGsI_vkIfmY&list=PLWx5a9Tn2EvG4C90YFJ9eU61IpALeE0SN&index=68</a><a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a> <a href="https://fosstodon.org/tags/replication" class="mention hashtag" rel="tag">#replication</a>

MySQL CommunityMySQL Shell is a powerful tool to we can use to manage MySQL instances. Remembering the syntax and options for all the features can be difficult. Thankfully, MYSQL Shell has a comprehensive help system.Check out at: <a href="https://blogs.oracle.com/mysql/post/getting-help-in-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/getting-help-in-mysql-shell</a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a>

MySQL CommunityDid you know you can run system commands inside of MySQL Shell? This feature is a hidden gem that has become part of my normal workflow.Check out this blog post for more information. <a href="https://blogs.oracle.com/mysql/post/executing-system-commands-in-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/executing-system-commands-in-mysql-shell</a><a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a>

MySQL CommunityIn a new blog series, Scott is going to highlight some "hidden gems" in MySQL Shell.The first post demonstrates running external JavaScript, Python, and SQL scripts inside MySQL Shell.<a href="https://blogs.oracle.com/mysql/post/running-external-scripts-in-mysql-shell" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://blogs.oracle.com/mysql/post/running-external-scripts-in-mysql-shell</a><a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="tag">#mysql</a> <a href="https://fosstodon.org/tags/mysqlshell" class="mention hashtag" rel="tag">#mysqlshell</a> <a href="https://fosstodon.org/tags/javascript" class="mention hashtag" rel="tag">#javascript</a> <a href="https://fosstodon.org/tags/python" class="mention hashtag" rel="tag">#python</a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="tag">#sql</a>

lefredMySQL 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 <a href="https://lefred.be/content/mysql-shell-for-vs-code-bastion-host-invalid-fingerprint-detected/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/mysql-shell-for-vs-code-bastion-host-invalid-fingerprint-detected/</a> <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a>

lefredWordPress 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 <a href="https://lefred.be/content/wordpress-in-oci-with-mysql-heatwave-read-replicas-and-mysql-router-r-w-splitting/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/wordpress-in-oci-with-mysql-heatwave-read-replicas-and-mysql-router-r-w-splitting/</a> #80 #82 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a> <a href="https://fosstodon.org/tags/Replication" class="mention hashtag" rel="tag">#Replication</a> <a href="https://fosstodon.org/tags/Router" class="mention hashtag" rel="tag">#Router</a> <a href="https://fosstodon.org/tags/wordpress" class="mention hashtag" rel="tag">#wordpress</a>

lefredMigrate 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 HeatWaveHow to Migrate from MariaDB to MySQL 8.0Migrating from MariaDB to MySQL using MySQL Sh <a href="https://lefred.be/content/migrate-from-mariadb-to-mysql-heatwave-easier-with-mysql-shell-8-2-1/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/migrate-from-mariadb-to-mysql-heatwave-easier-with-mysql-shell-8-2-1/</a> #80 #82 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a>

lefredMySQL 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 <a href="https://lefred.be/content/mysql-shell-adminapi-different-ways-to-call-the-commands-same-effect/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/mysql-shell-adminapi-different-ways-to-call-the-commands-same-effect/</a> <a href="https://fosstodon.org/tags/InnoDBCluster" class="mention hashtag" rel="tag">#InnoDBCluster</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a>

lefredBackup 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 <a href="https://lefred.be/content/backup-your-mysql-instance-in-the-cloud/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/backup-your-mysql-instance-in-the-cloud/</a> #81 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a>

lefredHow 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 copylogical copyThe 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 <a href="https://lefred.be/content/how-to-copy-a-mysql-instance/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/how-to-copy-a-mysql-instance/</a> #80 #81 <a href="https://fosstodon.org/tags/CLONE" class="mention hashtag" rel="tag">#CLONE</a> <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a>

lefredCut & 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 <a href="https://lefred.be/content/cut-paste-a-user-creation-statement-with-mysql-8/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/cut-paste-a-user-creation-statement-with-mysql-8/</a> #80 #81 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a>

lefredHow 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 <a href="https://lefred.be/content/how-to-migrate-from-mariadb-to-mysql-heatwave/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/how-to-migrate-from-mariadb-to-mysql-heatwave/</a> #80 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#Cloud</a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#HeatWave</a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#MDS</a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQL80" class="mention hashtag" rel="tag">#MySQL80</a> <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#OCI</a> <a href="https://fosstodon.org/tags/rss" class="mention hashtag" rel="tag">#rss</a>

lefredQuery 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 <a href="https://lefred.be/content/query-and-transaction-size-in-mysql/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://lefred.be/content/query-and-transaction-size-in-mysql/</a> #8.0 <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#MySQL</a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#MySQL8</a>.0 <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#MySQLShell</a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#Performance_Schema</a>

Recent searches

Search options

Administered by:

Server stats:

#mysqlshell