When building MySQL Heatwave Systems (use to be called MySQL Database Service or MDS), the need to add a Hostname to the system is critical. The system having a hostname will allow for other applications like Oracle Analytics Cloud (OAC) to connect to MySQL Heatwave.
Building a MySQL Database in Oracle Cloud Infrastructure (OCI) is easy. Within a few steps, you can build a MySQL instance for your development or production needs. To begin building, you first have to login into your OCI tenancy. After you have logged in, use
MySQL has long been the number two database in the world! Initially MySQL started as one of the first open source databases that the world used as an alternative to Oracle and Microsoft’s SQL Server, so much so that sometime in 2009 Oracle purchased the
If you are reading this post, more than likely you are either looking at Oracle’s MySQL HeatWave for the first time and trying to understand how to load your database into the HeatWave cluster. There are actually two approached to loading data into a HeatWave
Recently I’ve been playing with Oracle’s MySQL Database Service (MDS) and testing out the Heatwave option. Heatwave is very impressive and enables MySQL to run OLAP workloads within a smaller database on the Oracle Cloud Infrastructure (OCI). Within the MySQL Database Service there are only
With every new service on any cloud platform, the need to make connections is essential .This is the case with Oracle’s new MySQL Database Service (MDS). The MySQL Database Service (MDS) is the gateway to implementing MySQL Heatwave. Understanding how to connect from on-premises to
With the Oracle Cloud Infrastructure (OCI) MySQL Database Services, in order to connect you have to access MySQL through a compute node. This means you will have to create a compute node within OCI. You can do this quickly with Terraform (here). Once you have
With Oracle’s recent release of MySQL Heatwave, I’ve been looking more into MySQL. I’ve actually looked at it a few times over the years, but the addition of Heatwave and how it allows MySQL to be used as an analytical platform. This post is not