HeatWave – A MySQL cloud feature to speed up your queries

April 13, 2021
Tags: , , ,

If you have (too) long running select queries it is probably because of lack of relevant indexes, problematic schema that lead to poor queries or inadequate hardware.

That said, sometime even if you doing it right, the query execution time could be too long regarding of what the application or your users expect. It is often true for reporting, real time analytics or BI queries.

At Oracle we have developed Heatwave, that allow you to easily run high performance analytics against your MySQL database.

To be more precise, Heatwave is a massively-scalable integrated analytics engine for MySQL Database Service (MDS), the MySQL DBaaS in Oracle Cloud Infrastructure (OCI).

Some key points of Heatwave:

– Single MySQL database for OLTP & analytics applications
– All existing applications work without any changes
– Extreme performance:
+ 400x faster than MySQL, scales to thousands of cores
+ 1100x faster than Amazon
Aurora
+ 2.7x faster than Amazon Redshift

1

MySQL in Amazon (RDS)

March 16, 2021
Tags: , , ,

Up until now we have seen MDS (MySQL Database Service) and MySQL in Azure.
As the Cloud technology keeps moving fast, I thought it would be a good idea to see how to set up a MySQL in Amazon , as a service, that is RDS.

0

MySQL Recovery

February 23, 2021

If you are dealing with data, and you most probably are if you are reading this, one of your biggest fears would be not to be able to retrieve them. In a world where data actually surround us, it is critical to be able to retrieve them fast and with the best consistency.

Thus, it is always a good idea to have high availability settings in place to avoid loosing your data.

However, most of the times, we may wish or we may need to save the database and our data, and be a DBA-hero. Not an easy task, and it may be smoother to just perform a backup-restore. Sadly, this is not always the case.

So, this is what we will be facing in this article, we are going to see what to do when there is a data corruption in MySQL and the steps we need to perform to try saving our database.

0

Replicate from MySQL 5.7 to MySQL Database Service

January 26, 2021

MySQL Replication is a very common topology, widely used in various architecture.
People use it, among others, for High Availability, Read Scalability or Geographic Redundancy.

Another use case is to use MySQL Replication to seamlessly integrate a newer version of the server in your architecture.
Let’s say you are running MySQL 5.7 then you can easily setup a 8.0 instance as a replica of your 5.7.

Extending this idea it is also possible to replicate your MySQL 5.7 (or 8.0 obviously) to a MySQL Database Service instance, the true MySQL PaaS on Oracle Cloud Infrastructure.

3

MySQL in Azure

January 19, 2021
Tags: ,

In this article, we are going to see how to set up a MySQL Database instance on Microsoft Azure Cloud.

1

MySQL SHELL – The new era

December 17, 2020

In one of our previous articles – Setting up Replication with various methods for MySQL 8 – we reviewed how to create a replica with multiple tools.
Now, it is time to perform the same action but with MySQL Shell.

2

Setting up Replication with various methods for MySQL 8

December 10, 2020

In the world of the Databases, one of the most important value that we are all trying to achieve is High Availability. Not to loose our valuable data or in case one server fails to always have another to step in and take control.

So, it is critical to have along with our primary database, other identical instances, the replicas.

On this blog post, we will see the most famous ways to set up our replication.

6

Create a Cloud Backup with MySQL Enterprise Backup

December 10, 2020
Tags: ,

Cloud backup is a strategy increasingly used in organizations. Send copies of your data to the cloud, can help you to prevent a devastating IT crisis and ensure business continuity.

Currently, MySQL Enterprise Backup supports the following types of cloud storage services:

– Oracle Cloud Infrastructure (OCI) Object Storage

– OpenStack Swift or compatible object storage services

– Amazon Simple Storage Service (S3) or compatible storage service

0

MySQL 8.0.22 New Features Summary

November 10, 2020

Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.

0

Automatic connection failover for Asynchronous Replication

November 5, 2020

Since MySQL 8.0.22 there is a mechanism in asynchronous replication that makes the receiver automatically try to re-establish an asynchronous replication connection to another sender, in case the current connection gets interrupted due to the failure of the current sender.

4