In this article, we will see how you can create a MySQL DB System
from the Oracle Cloud Shell. You can also create MySQL DB System
from Oracle Cloud Infrastructure (OCI) console or from OCI
Command Line Interface (CLI).
Oracle Cloud Infrastructure (OCI) Cloud Shell is a feature
available to all OCI users and accessible from the Console. It is
a web browser-based terminal and provides a Linux shell, a
pre-authenticated command-line interface (CLI) and preinstalled
developer tools like Git, Java, Ansible, and Terraform, for
easily managing Oracle Cloud resources. You can run cli commands
without any setup. Developers can quickly get started using the
Oracle Cloud Infrastructure SDKs, such as the SDK for Python,
Java, Go, Ruby, TypeScript and JavaScript without having to
download and configure a CLI or Python or other languages on
their local machines. To know more about Oracle cloud shell,
please look …
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]Apache Airflow is an open-source workflow management platform for data engineering pipelines.
Today we will see how we can deploy very easily Apache Airflow on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL HeatWave Database Service (MDS).
I am sharing Terraform modules you can use to deploy in your architecture:
Architectures
With the modules you can deploy architectures like these:
with a single MDS instancewith MDS High Availabilitywith HeatWave Cluster
We will use the exact same modules built into a stack for OCI’s Resource Manager. This will allow us to deploy the architecture just in few clicks.
Deployment
We open in a browser the following GitHub repository: …
[Read more]When using cloud native application architectures, Functions have an important role for the business logic without managing any infrastructure. Functions is a serverless platform powered by the Fn Project open source engine.
These Functions are mostly used to create and run different tasks. They can be executed using Fn Project CLI, OCI CLI or a HTTP request.
HTTP requests are useful to invoke Functions from a different service. Usually use to schedule the execution of the function according to a time schedule. Currently, Oracle Cloud Infrastructure does not provide a native mechanism to create time based schedules to execute some jobs like invoking a Function directly …
[Read more]If like me you like to share some data between all your devices (presentations, keypassX file, pictures, …), you probably use a cloud platform to store all that.
I do like to keep control of such solution, I used ownCloud and now I’m using Nextcloud.
In this article I will show you how to easily deploy Nextcloud on Oracle Cloud (OCI) using MySQL Database Service (MDS) and Object Storage.
The easiest way to deploy solutions on OCI is to use Terraform and Resource Manager’s Stack.
If you already have an account on Oracle …
[Read more]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]
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 third and last of a series of articles dedicated to MySQL Database Service (MDS):
- Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
- Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
- Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities.
We can now start a query on our MDS instance that has been populated with >200M rows:
SQL > SELECT year, Reporting_Airline,
AVG(ArrDelay) AS avgArrDelay …[Read more]
This post is the second of a series of articles dedicated to MySQL Database Service (MDS):
- Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
- Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
- Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities.
Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System in OCI is to use a parallel dump created using MySQL to Object Storage and load it …
[Read more]