This post is the final one of a series of articles on extending MySQL with the Component Infrastructure:
On the previous article we saw how to easily deploy Apache Zeppelin on OCI with MySQL using Terraform.
In this article we will see how we can accelerate queries enabling MySQL HeatWave.
Enabling HeatWave
If you used a MySQL Database Service Shape compatible with
HeatWave (MySQL.HeatWave.VM.Standard.E3), using the
same Resource Manager Stack, you have the possibility to enable
HeatWave and deploy a HeatWave Cluster for your MySQL.
The first think to do, is to edit the previous applied stack:
As we used a HeatWave compatible shape, we have the choice to deploy a HeatWave Cluster and we can choose it:
Save and Apply… the HeatWave cluster will be added:
If you …
[Read more]Recently, somebody requested some help as he was trying to modify the structure of a large table. The requested modification was related in changing a fixed length string to a variable length string column.
If you don’t know it yet, MySQL supports multiple algorithms when altering a table (DDL):
The operation that interests us today needs to copy the full table. And this was the problem for the user as the MySQL Datadir could not store twice the amount of that large table.
In this blog post I will explain a method that can be used to solve this problem. There are also others method like a logical dump …
[Read more]
Apache
Zeppelin is a web-based notebook that enables
data-driven,
interactive data analytics, machine learning, and
collaborative documents with SQL, Scala, Python, R.
Today we will see how we can deploy Apache Zeppelin on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL Database Service (MDS).
You can manually deploy a compute instance and install zeppelin on it then connect to MySQL Database Service or you can use the Terraform modules I’m sharing on GitHub: https://github.com/lefred/oci-zeppelin-mds
Finally you can also deploy all this by just clicking on the follow button to use …
[Read more]This post is the twelfth one of a series of articles on extending MySQL with the Component Infrastructure:
This post is the eleven one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
Last week, Jan 18th, we started 2022 with a new release of the MySQL Server suite (Router, Shell, Connectors, …).
MySQL is Open Source and each release contains contributions from our great Community. Let me thanks all the contributors on behalf of the entire MySQL Team: Thank you !
As Dave already mentioned already in his MySQL 8.0.28 Release Note Commentary post, this new version of MySQL includes contributions from Song Zhibai, Venkatesh Prasad Venugopal, Zheng Lai, Tingu Wei, Casa Zhang, Kevin Michel, our Øystein Grøvlen before his comeback, Tsubasa Tanaka, Brian Yue, Murakami Kohei, Casa Zhang, Hope Lee, Rahul Malik, Hobert Lu, Zhai Weixiang and Facebook.
Once again, thank you all for your …
[Read more]Today we are already at the post number ten of the series of articles related to extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
This post is the nine one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
This post is the eight one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: