One of the things I love about the MySQL Shell is that is saves your authentication credentials (no longer just passwords) in an obfuscated login path file named .mylogin.cnf. You can find that file in the %APPDATA%\MySQL directory on Windows or the current user's home directory on non-Windows systems. The file can be read later by MySQL client programs, such as the MySQL Shell, to obtain your authentication credentials for connecting to MySQL Server.

Which Credentials?

I had an email this morning from someone wanting to a) change the password stored by mysqlsh and b) find out which credentials are stored on the shell account being used.

Let's start out in reverse order.  The mysql_config_editor will show you the accounts with credentials saved for that login. 

$ mysql_config_editor print --all
[root@localhost]
user = "root"
password = …

GT Cup 2021

For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose.  

Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup

Greystone GT became race winners for the first time as Rich Mason and Jon Lancaster scored an extraordinary GT Cup victory on a chaotic weekend at Silverstone.

It was an inspired strategy call that put the #22 McLaren 570S GT4 into prime position in the GTH category - the most hotly-contested class in GT Cup - in Saturday afternoon's Endurance Race.

An on-track incident brought out the safety car close to half-distance, and I was still on-track when the mandatory pit window - in which all cars must spend at least 70 seconds stationary and driver changes are allowed - opened on the 28-minute mark.

While most of …

GT Cup 2021 For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose. Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup Greystone GT became race winners for the firs...

MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS).

This is the fifth 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 this episode, we’ll see how these data can now easily be imported into a MySQL Database Service instance.

The post Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump first appeared on dasini.net - Diary of a MySQL expert.

Oracle APEX App Creator Spotlight: Michelle Skamene invented Reading Rewards to encourage her children to read. Now the app is used by students around the world.

Oracle APEX App Creator Spotlight: Michelle Skamene invented Reading Rewards to encourage her children to read. Now the app is used by students around the world.

In our first APEX app creator spotlight, we take a look at two ingenious apps Hesham built with APEX.

In our first APEX app creator spotlight, we take a look at two ingenious apps Hesham built with APEX.

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:

1. we need to restore the last backup just before the point we want to return to
2. find the last GTID that was executed in that backup (not 100% mandatory but can accelerate the process)
3. choose what is the objective:
   1. just skip one transaction (following transaction could depend on it)
   2. recover up to that transaction and skip all the following ones
4. replay the binary logs taking in consideration the chosen option of point 3

The scenario …

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 MDS series. It’s only about streaming the binary logs to Object Store. In part 2, we will see how to use them and perform PITR.

Saving the binary logs

In fact most of the work will be to setup the compute instance to store the binary logs coming from MDS (one single compute instance could stream those binlogs from multiple MDS source).

On the compute instance we need …