We’re excited to share that Marcelo Altmann from the Percona Server Engineering Team has just been promoted from Oracle ACE Associate to Oracle ACE.

Congratulations!

The Oracle ACE Program recognizes and rewards community members for their technical contributions to the Oracle community.

Marcelo initially joined Percona as a senior support engineer in our global services organization, where he helped customers with running their MySQL-based environments. In early 2020, he joined our Server Engineering team and has been actively involved in the development of Percona Server for MySQL and Percona …

    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 …