|MySQL 8.1 And HeatWave Lakehouse Released|
|Written by Kay Ewbank|
|Monday, 24 July 2023|
After a gap of five years since the release of MySQL 8.0, MySQL 8.1 has arrived and the community server builds are now available. Oracle has also announced the wider and general availability of MySQL Heatwave Lakehouse, a MySQL cloud database service for transactions, real-time analytics across data warehouses and data lakes that has machine learning features.
MySQL is an open source relational database that was originally developed by Monty Widenius and David Axmark back in 1994-5, and named after Widenius' daughter My. The first version of MySQL appeared on 23 May 1995.
MySQL was owned and sponsored by the Swedish company MySQL AB, which was then bought by Sun Microsystems, and later acquired alongside Sun by Oracle. Widenius then forked the open-source MySQL project to create MariaDB. Oracle, meanwhile, offers commercial versions of MySQL, including the latest MySQL HeatWave Lakehouse.
The community release of MySQL 8.1 extends the existing Explain Format=JSON with an Into option. This provides the ability to store JSON-formatted Explain output in a user variable where it can be worked with using MySQL JSON functions.
Another improvement to the support for JSON is the addition of a Show Parse_Tree statement that can be used to display a JSON-formatted parse tree for a Select statement.
A few days after the release of MySQL 8.1, Oracle announced the general availability of MySQL HeatWave Lakehouse. Oracle says this lets customers query data in object storage as fast as querying data inside the database. MySQL Heatwave is a MySQL Database service for transactions, analytics, and machine learning (ML). MySQL HeatWave Lakehouse extends this to data lakes, and supports a variety of object store file formats including CSV and Parquet, and export files from other databases. It can also combine object storage file data and MySQL database transactional data together in the same query.
Object store files are queried directly by HeatWave without copying the data into the MySQL database, so improving scalability and performance for query processing, speed of loading data, cluster provisioning time, and automation to query data in object storage.
MySQL HeatWave Lakehouse is now available on Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Microsoft Azure.
or email your comment to: email@example.com
|Last Updated ( Tuesday, 25 July 2023 )|