MySQL and HeatWave

Try Oracle Cloud Platform For Free

MySQL

MySQL Database Service Replication: deployment with Terraform

In the previous post we saw how to easily deploy (in just some mouse clicks) MySQL Database Service on two different regions with data replicated from the...

In the previous post we saw how to easily deploy (in just some mouse clicks) MySQL Database Service on two different regions with data replicated from the source to the replica using OCI Resource Manager Stack. In this article, we will, this time, see how we can create similar architecture using the same Terraform modules in command line. To make it a bit more fun, I will extend the architecture to a third region. What we gonna deploy will look like this: The main region will...

MySQL Database Service Replication: easy deployment with Terraform

Recently, we discovered how to setup Disaster Recovery in OCI MySQL Database Service using inbound/outbound replication. In this article we will see how we can...

Recently, we discovered how to setup Disaster Recovery in OCI MySQL Database Service using inbound/outbound replication. In this article we will see how we can deploy MDS replication architecture very easily using Terraform and OCI Resource Manager. The current modules available as example on my github (https://github.com/lefred/oci-mds-multi-region) allows you to deploy architectures like these: We can deploy replica for a single MySQL Instance or for a MySQL HA Instance....

MySQL Database Service inbound replication channel troubleshooting

Using a MySQL Database Service instance in OCI as an asynchronous replica is very useful. It allows testing the service with always updated data from on-premise...

Using a MySQL Database Service instance in OCI as an asynchronous replica is very useful. It allows testing the service with always updated data from on-premise production. It can be used in the process of migrating with minimal downtime to OCI and finally, it can also be used between MDS instances on different regions for DR, analytics, etc… Here are some links to the documentation and other resources about inbound replication channel and how to use...

Where’s the MySQL team from October - December 2021

As a continue of the previous announcement from July 1st, 2021, please find below the list of shows where you can find MySQL Community and/or the MySQL team...

As a continue of the previous announcement from July 1st, 2021, please find below the list of shows where you can find MySQL Community and/or the MySQL team during the time of October - December 2021: October 2021: OpenSource Conference India (OSI Days) / Virtual, October 7-8, 2021 MySQL is going to have a virtual booth & 2 MySQL talks at OSI Days, one Keynote and second technical talk as follows: Keynote: "Why MySQL remains the OpenSource database of choice", given by Sanjay...

Dave's MySQL Quiz #3 -- JSON data conversion

This weeks quiz is a little different. Many of you grew up with MySQL's sample world database but have not used the world_x database (see...

This weeks quiz is a little different. Many of you grew up with MySQL's sample world database but have not used the world_x database (see https://elephantdolphin.blogspot.com/2021/09/sample-databases-for-learning-mysql-and.html for information on both sample data sets) and may be shocked to find that there is now a forth table to the database and some of the information is now stored in a JSON data type column. The quiz is to take the following code that works with the...

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

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 Service Today, we will see how we can export some tables from AWS RDS Aurora PostgreSQL and import them on MDS. For this exercise, the data used is pagila, a port of the Sakila example...

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

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

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

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 want to return to find the last GTID that was executed in that backup (not 100% mandatory but can accelerate the process) choose what is the objective: just skip one transaction...

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

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 Object Storage Bucket, this is easy and there is already a lot of literature about them (you can also check several of my previous articles). This is part 1 of the Point-in-Time Recovery in OCI...