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 be in USA (Ashburn) and will consist in a MDS HA instance using 3 availability domains. Then we will have replicas in ..read more

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. Let’s see how do deploy such solution using OCI Resource Manager Stack. To start, just click on this button below: This ..read more

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 it: https://docs.oracle.com/en-us/iaas/mysql-database/doc/replication.html https://blogs.oracle.com/mysql/migrate-from-on-premise-mysql-to-mysql ..read more

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 Manwani, the Senior Director of MySQL India. Session: "MySQL Database Service with HeatWave", gi ..read more

Want to learn MySQL? Have an hour or so?  Go to Oracle's Learning Explorer and sign up for the FREE MySQL Explorer learning path (it is near the bottom of the page).  It begins with an overview of MySQL, discusses the client/server model, and then leads you through the use of MySQL.  You do not need previous MySQL or database experience.   MySQL is the most-used opensource database and over the years I have has requests for introductory materials. Well, now I can send them to the MySQL Explorer for some web based training. And you can earn the explorer badge when you pass t ..read more

 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 world database and convert it to work with the&nb ..read more

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 joins.  And depending on how you decided to the solve this problem you may also end up using window functions and groupings.         The problem:  Find the customers with more than one unreturned rented movies that are past their return due date.  You might to look at thi ..read more

  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 Database Service, customers now have a single database which is efficient for both transaction processing and analytics. It eliminates the need for ETL to a specialized analytic database and provides support for real-time analytics. HeatWave is built on an innovative, in-memory query engine which is architec ..read more

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 database. We will use S3 to export the data. AWS Aurora PostgreSQL My RDS Aurora PostgreSQL instance is of course running ..read more

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 visuali ..read more