August 17, 2021
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.
Like this:
Like Loading...
August 10, 2021
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.
Like this:
Like Loading...
August 3, 2021
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.
Like this:
Like Loading...
April 13, 2021
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
Like this:
Like Loading...
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.
Like this:
Like Loading...
May 19, 2020
Dual-password capability makes it possible to seamlessly perform credential changes without downtime.
Like this:
Like Loading...
May 12, 2020
DBA can configure user accounts such that too many consecutive login failures cause temporary account locking.
Like this:
Like Loading...
May 5, 2020
MySQL 8.0 has introduced an optional behavior that authorize users to change their password only if they could provide the current password.
Like this:
Like Loading...
April 28, 2020
MySQL provides password-reuse capability, which allows database administrators to determine the number of unique passwords a user must use before they can use an old password again.
Like this:
Like Loading...
April 21, 2020
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password.
Like this:
Like Loading...