In this blog, we will take a look at how MySQL HeatWave Lakehouse works with some of the popular file formats like Parquet and Avro. MySQL HeatWave Lakehouse enables querying data in the object storage stored in a variety of file formats, such as CSV, Parquet, and Avro. Most databases also support exporting their data […]

In this blog, we will take a look at how MySQL HeatWave Lakehouse works with some of the popular file formats like Parquet and Avro.

Vitess 18 is now Generally Available, with a number of new enhancements designed to improve usability, performance and MySQL compatibility. MySQL Compatibility Improvements # Foreign Keys # In the past, foreign keys had to be managed outside Vitess. This was a significant blocker for adoption. We are now able to support Vitess-managed foreign keys within the same shard. This includes the ability to import data into Vitess from an existing MySQL database with foreign keys.

Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at the release notes to see what these new versions bring to the community. You’ll want to keep an eye on the deprecations in particular because some long-accepted behavior, including wildcards, will change eventually.We get 83 […]

Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by renowned MySQL expert Morgan Tocker.

Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by renowned MySQL expert Morgan Tocker.

Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by renowned MySQL expert Morgan Tocker.

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 of combining them, as he would expect this to have an impact on the connections established with the server.

Let’s illustrate this by looking at the different ways of obtaining the state of a cluster. Here are the four different methods:

Method 1

This is the method most frequently used in the documentation:

$ mysqlsh admin@10.0.0.1
JS> cluster=dba.getCluster()
JS> cluster.status() 

Method 2

This is Alex’s preferred method as he expects to have less round trips with the network:

$ …

We don't say that quite often, but here is an update to end all updates, one of the biggest bulks of new features and enhancements that dbForge Studio for MySQL has ever seen.

The post Meet the Grand New dbForge Studio MySQL 10.0 with Integrated Source Control! appeared first on Devart Blog.

Above the Conferences and Events announced on Oct 24, we would like to also inform you about the upcoming MySQL meetups, as well as the Oracle User Group conferneces, webinars and other MySQL planned events as such. Please find the details with more information below. Planned MySQL Meetups Planned Oracle User Group Events MySQL Days, […]