dasini.net – Journal d'un expert MySQL

This is the fourth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we’ve created our Virtual Cloud Network, that provides you with complete control over your cloud networking environment that we will create in this Discovering MySQL Database Service journey.

In this episode, we’ll see what is OCI Object Storage and how to export data to it from a MySQL instance using MySQL Shell.
In fact, in the process of creating a MySQL DB system, this step is optional. But it is especially useful if you want to create a MDS instance with data from a MySQL server on premise or in any public/private cloud.

This is the third episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we’ve created our compartment, the foundation stone, of the architecture that we will build during this Discovering MySQL Database Service journey.

In this episode, we’ll see what is a Virtual Cloud Network (VCN) and how to create one and use it.

This is the second episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we’ve introduced the different components that we will use during this Discovering MySQL Database Service journey.

In this episode, we’ll see what is a compartment and how to create one and use it in order to create a MySQL DB system.

This is the first episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

Like any series, in this episode I’m going to give you some context and set up the characters.

Le Monde de MySQL est un vidéocast, animé par deux vétérans MySQL (Lefred & Daz), qui a pour but de tenir informé la communauté francophone sur l’actualité de la base de données la plus populaire au monde.

Dans ce troisième épisode, les sujets abordés sont (entre autres):

+ MySQL Operator for Kubernetes
+ Plugin MySQL Shell pour copier les utilisateurs
+ MySQL Day francophone 2021
+ Haut disponibilité avec MySQL Database Service
+ Zoom sur l’InnoDB Buffer Pool

Ce mercredi 19 mai 2021 à partir de 10h (CET), tu es cordialement invité à nous rejoindre en ligne, pour le MySQL Day 2021 (en français).
Tu assisteras à six présentations d’une vingtaine de minutes, sur des sujets d’actualité…

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

Rejoignez nous ce mardi 30 mars à 14h30 CET, pour ce webinar: MySQL, les dernières nouveautés.

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.

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