MySQL Database Service: administrator user
On MySQL Database Service (aka MDS) on Oracle Cloud Infrastructure (aka OCI), when you create a new instance, you also need to set the credentials for the administrator: Let’s focus on that account… Please don’t forget the password, it cannot be recovered !! First of all...

MySQL 8.0: all you need to know about SDI
We recently saw that .frm files have been somewhat of replaced for MyISAM tables in MySQL 8.0 (see this post). However, what are those files ? Can they be used for something else than MyISAM tables ? … Let’s try to answer those questions and get more familiar with the .sdi...

Oracle Live: New MySQL Heatwave Innovations - AUG 10 - 9AM PST
Please join our Oracle Live event, on August 10th, 9AM PST, 12 noon ET / 1 PM BRT / 6 PM CEST where Edward Screven, Oracle’s chief corporate architect, will share our latest MySQL innovations, along with the latest benchmarks, that show the speed and cost savings gained with MySQL...

MySQL Database Service: Snapshot your data – restore
On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. This article is the second part of multiple part blog series. In part 1, we dealt with taking snapshots as backup. In this part, we deal with restoring the data. Managed...

MySQL Database Service: Snapshot your data - backups
On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. I will explain how it works in the multiple part blog series. In part 1, we will deal with taking snapshots as backup. In part 2, we will see how to restore data and for which...

Using OCI Cloud Shell & Bastion with MySQL Database Service
Recently, Oracle added a Bastion Service to OCI. And you may also have noticed that the OCI Dashboard offers you the possibility to use a browser based terminal: Cloud Shell. Today, we will see how we can use these two components to connect from the browser to a MDS DB System. We need the MySQL...

MySQL Shell Dump & Load and Compression
MySQL Shell is the popular tool to work with MySQL and it integrates perfectly everything for MySQL Database Service (MDS) in Oracle Cloud Infrastructure (OCI). For any logical dump and load of data and especially to dump data to MDS, MySQL Shell Utility is the recommended solution. MySQL...

Scale-up MySQL NDB Cluster 8.0.26 to +1.5M QPS the easy way with AMD EPYC 7742
On July 20th, 2021, we’ve celebrated the release of MySQL NDB Cluster 8.0.26. MySQL NDB Cluster (or NDB for short) is part of the MySQL family of open-source products providing an in-memory, distributed, shared-nothing, high-availability storage engine usable on its own or with MySQL servers...