In this article I will show you how to properly configure Apache Zeppelin in order to take advantage of the Analytics and Machine Learning capabilities of MySQL HeatWave the MySQL in-memory query accelerator.
The post Interactively explore & visualize your MySQL HeatWave data with Apache Zeppelin first appeared on dasini.net - Diary of a MySQL expert.
We are pleased to announce the general availability of Vitess 14. Major Themes # In this new release, major improvements have been made in several areas of Vitess, including usability and reliability. Online DDL is now GA. Gen4 planner is the new default planner. VTAdmin and VTOrc are officially in beta with Vitess 14. Usability # Command-Line Syntax Deprecation # This release marks the beginning of Vitess standardizing its command-line and flags syntax.
In this article I will show you how to properly configure Apache Superset in order to take advantage of a high performance, in-memory query accelerator: MySQL HeatWave.
The post Explore & visualize your MySQL HeatWave data with Superset first appeared on dasini.net - Diary of a MySQL expert.
This fall, from October 16 to 20, the MySQL Summit will be held in La Vegas.
This conference is totally dedicated to your favorite dolphin database and is part of Oracle CloudWorld.
MySQL Summit will bring together a large community of new and expert MySQL users.
Attendees will be able to meet the engineers, product managers and developers who make MySQL the number one open source database in the world!
MySQL Summit will be different from MySQL’s previous appearances at Oracle OpenWorld, for the summit, we, as MySQL Team, users of MySQL… MySQL Community, will have more sessions, dedicated tracks and more !
The call for papers is now open until June 24, 2022.
CfP is extented !
The Call for Papers ends on June 30th !
If you …
[Read more]Aurora Serverless V2 is generally available around the corner recently 21-04-22 for MySQL 8 and PostgreSQL, with promising features that overcome the V1 disadvantages. Below are those major features
Features
Getting started with authentication_oci There is a new means of connecting seamlessly to a MySQL Database Service instance in the Oracle Cloud Infrastructure. It is a method that does not require passwords, and can utilize the public key found in a OCI user’s account profile, without anyone needing to access that profile directly . It derives its access… Read More »
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]I could have also called this article When Pandas meet Dolphins in MySQL Shell.
Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL.
Since then, the MySQL Shell engineering team implemented another powerful native utility that collect all the essential information and more and store them in a single zip file.
This zip archive contains TSV and YAML files that, for example, the MySQL Support Team could use to solve your eventual issue.
For more information regarding MySQL Shell’s
util.debug.collectDiagnostics(), I encourage you to
check the manual.
This tool is …
[Read more]In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions.
While this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how DDLs behave when using the ONLINE option. With a quick comparison with what happens in MySQL 8 standard and with Group Replication.
Tests
All tests were run on an Aurora instance r6g.large with a secondary availability zone. The test was composed of:
Four connections
In the Aurora instance, a …
[Read more]