MySQL Shell 8.0.13 (GA) introduced a new feature to allow you to easily import JSON documents to MySQL. The basics of this new feature were described in a previous blog post. In this blog we we will provide more details about this feature, focusing on a practical use case of interest for to many: How to import JSON data from MongoDB to MySQL.…
Category Archives: MySQL
Importing Data from MongoDB to MySQL using JavaScript
MySQL Shell 8.0.13 (GA) introduced a new feature to import JSON documents to MySQL in an easy way. The basics of this new feature were described in a previous blog post. Here, we provide more details about this feature, focusing on a practical use case that may be of interest for some readers: How to import JSON data from MongoDB to MySQL.…
MySQL Shell: API Command Line Integration for DevOps
MySQL Shell is a command-line shell for MySQL Server that has the capability for
interactive and batch code execution. It also offers a wealth of APIs that make it easier and more efficient to work with and manage MySQL servers. In 8.0.13, we made an effort to make those APIs easily accessible straight from the command line.…
Import JSON to MySQL made easy with the MySQL Shell
The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features, for more information see the full changelog here: https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/mysql-shell-news-8-0-13.html. One of those features was the introduction of a convenient and easy way to import JSON documents to a MySQL Server database.…
MySQL InnoDB Cluster – What’s new in the 8.0.13 (GA) release
The MySQL Development Team is very happy to announce the second 8.0 Maintenance Release of InnoDB Cluster!
In addition to bug fixes, 8.0.13 brings some new exciting features:
- Defining the next primary instance “in line”
- Defining the behavior of a server whenever it drops out of the cluster
- Improved command line integration for DevOps type usage
Here are the highlights of this release!…
MySQL Shell 8.0.13 – What’s New?
The MySQL Development team is proud to announce a new version of the MySQL Shell which in addition to the usual bug fixes and enhancements to the existing components, offers new features we expect are quite useful in your day to day work.…
The MySQL 8.0.13 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.13 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.13 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
MySQL : InnoDB Transparent Tablespace Encryption
From MySQL 5.7.11, encryption is supported for InnoDB (file-per-table) tablespaces. This is called Transparent Tablespace Encryption or sometimes referred as Encryption at Rest. This blog post aims to give the internal details of InnoDB Tablespace Encryption.
Keyring Plugin : Why What How ?…
What is the “(scanning)” variant of a loose index scan?
A query plan uses loose index scan if “Using index for group-by” appears in the “Extra” column of the EXPLAIN output. In some plans though, “Using index for group-by (scanning)” appears. What does “(scanning)” mean and how is it different from the regular loose index scan?…
JSON_TABLE – The Best of Both Worlds
One of the new JSON functions in MySQL 8.0 is JSON_TABLE. It is also MySQL’s first table function. That is, the return value is not a scalar value, but a result set. JSON_TABLE will convert (part of) a JSON document into a relational table.…