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...

How to import data from Microsoft SQL Server to MySQL Database Service
After having see how we can import data from PostgreSQL and Amazon Redshift, this time we will see how we can export data from Microsoft SQL Server and import it into MySQL Database Service in OCI. This time we will use something extra (for fun but also because it’s practical): OCI Object...

How to import data from Amazon Redshift to MySQL Database Service
We saw in this previous post how to import data from PostgreSQL to MySQL Database Service. Using almost the same technique, we will now import data from Amazon Redshift and import it to a MDS instance. With Redshift we have two options to export the data to CSV files that can be imported to...