Dave's MySQL Quiz #2
This week's MySQL uses the Sakila database (See below for details on obtaining and installing this sample database)  and this week's quiz is a  great one for those wanting to move from beginner level SQL development to a higher level.  There will be lots of tables to...

MySQL HeatWave: Scale Out Management
  Introduction MySQL is the world's 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...

Import data from Amazon Aurora PostgreSQL to MySQL Database Service in OCI
In previous posts we already saw how to export data from PostgreSQL and AWS RedShift, and import it on MySQL Database Service in OCI using MySQL Shell importTable utility: How to import data from PostgreSQL to MySQL Database Service How to import data from Amazon Redshift to MySQL Database...

Deploy Apache Superset with MySQL Database Service on OCI
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...

Oracle MySQL Scores Big Race Victory at Silverstone
GT Cup 2021 For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose.   Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup Greystone GT became...

Point-in-Time Recovery in OCI MDS with Object Storage – part 2
In part 1 of the series about Point-in-Time Recovery in OCI MDS, we saw how to stream the binary log to Object Storage. In this blog post, we will see how we can restore the data up to certain point. The high level process is simple: we need to restore the last backup just before the point we...

Point-in-Time Recovery in OCI MDS with Object Storage – part 1
To setup point-in-time recovery for MDS using Object Storage, these are the prerequisites: a MDS instance running a backup plan (default) a compute instance an Object Storage Bucket In this article, I won’t focus on how to create a MDS instance, a compute instance, enable backups and...

Setup Disaster Recovery for OCI MySQL Database Service
When you create a MySQL Database Service instance in OCI, you have the choice between 3 types: If you have minutes as RTO (Recovery Time Objective) in case of a failure, you must choose a High Availability instance that will deploy a Group Replication Cluster over 3 Availability Domains or 3...