Oracle’s Command Line Interface (CLI) is a small-footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure (OCI) tasks. The CLI provides the same core functionality as the Console, plus additional commands. Some of these, such as the ability to run scripts, extend Console functionality. The CLI is built on the Oracle […]

MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries. One – The MySQL Query Optimizer wants to optimize your […]

This post is the third and last of a series of articles dedicated to MySQL Database Service (MDS): 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 […]

This post is the second of a series of articles dedicated to MySQL Database Service (MDS): 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 […]

This post is the first of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. In this first article we will start by creating a MySQL DB System and a Compute instance in OCI. One of the […]

We already saw how easy it’s to deploy solutions on OCI using Terraform and Resource Manager’s Stack. I’ve published several resources available on this page.

Today we will see how easy it’s to deploy Apache Superset on OCI using MySQL Data Service.

Apache Superset is an open source BI, Reporting, Charting tool that competes with Tableau, Looker, etc.  For a list of companies that have deployed Superset, see:  https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md.

Superset is loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts.

For a gallery of …

From RDS to MDS   When an application reaches the maximum capabilities offered by Amazon Web Services (AWS) RDS, it is often recommended to migrate to the AWS Aurora service.   However, Aurora is based on an older version of MySQL.  Aurora still does not support MySQL 8.0, which was released in April 2018.  Therefore, it […]

MySQL Database Service is now easier to use and has flexible deployment options, including High Availability. While creating a new DB System using the web console, users can choose between Standalone, Highly Availability, and HeatWave deployments. The service will pre-populate the necessary fields with the recommended settings. You only need to provide the MySQL user […]

You’ve been using Amazon Aurora to manage your data but recently found out that you could manage the same data on Oracle cloud for a ⅓ of the cost on Amazon.   You also learned that you could run your MySQL queries on Oracle Cloud 1100x faster than on Amazon Aurora, including Analytics queries. Now […]

Introduction MySQL is the world most popular open source database because of its reliability, high-performance, and ease of use. MySQL has been designed and optimized for transaction processing and enterprises around the world rely on it. With the introduction of HeatWave in MySQL Database Service, customers now have a single database which is efficient for both […]