Codership, the developers of Galera Cluster for MySQL, provides training sessions in September 2021 for EMEA and USA timezone.

The Advanced Database Administrator with Galera Cluster training course teaches you how to install and configure in real-time a Galera Cluster for your application use cases. You will participate in interactive hands-on labs. Our expert instructor will teach you how to design and maintain your Galera Cluster for MySQL high availability and scalability. If you are a DBA or been given a Galera Cluster to manage, this is the course for you, as you’ll learn how to run your Galera Cluster in an optimal fashion, from setup, performance tuning, monitoring, as well as backups and more.

For more information, please read the full CONTENT BRAKEDOWN  course.

Course Dates

EMEA: …

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.

The post Discovering MySQL Database Service – Episode 2 – Create a compartment first appeared on dasini.net - Diary of a MySQL expert.

You will learn How to recover/reset a forgotten password using PHP and MySQLi in this post. We’ll show you how to use a Forgot Password form to recover your password if you’ve forgotten your username or email. We’ll send a password recovery email to the user after the form is submitted. There are several accounts […]

The post How To Reset Password by Email Using PHP7 and MySQLi appeared first on Phpflow.com.

On December 2, Edward Screven, Oracle’s chief corporate architect revealed the Oracle MySQL Database Service with Analytics Engine known as HeatWave.

During Oracle Live on August 10th, 9AM PST, 12 noon ET / 1 PM BRT / 6 PM CEST, Edward Screven will share our latest MySQL innovations, along with the latest benchmarks, that show the speed and cost savings gained with MySQL HeatWave.

HeatWave, in-memory query accelerator for the Oracle MySQL Database Service, allows customers to run very fast analytics queries directly against their MySQL databases entirely avoiding the step of data ETL into a …

     InnoDB is the default storage engine for MySQL and InnoDB prefers that there is a PRIMARY KEY defined when a table is defined.  Having a unique non-nullable primary key can vastly speed up queries and data is stored by the primary key in a B+ Tree structure.  

    What if a primary key is not defined, InnoDB will use the first unique key defined as NOT NULL.  Failing that, InnoDB generates a hidden clustered index named GEN_CLUST_INDEX on a synthetic column that contains a 6-byte automatically increasing number when rows are inserted. This is a key that you can not use for searches (it is hidden from you!) and is not directly benefitting you. And that is probably not what you want.

    To find those columns you need to look in the INFORMATION_SCHEMA with a query like this:

SELECT i.TABLE_ID,
   …

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 HeatWave.  

Be sure to register here. 

There has been a recent MySQL innovation in the MySQL/Oracle Cloud partnership that has been very popular among the MySQL community. This new integrated, high performance in-memory analytics engine provides:

• A single database for running OLTP and OLAP workloads
• Real time analytics that accelerates MySQL queries by 400X …

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 HeatWave. Be sure ...

 I was asked today what opportunities Oracle and MySQL had for new college graduates.  I referred them to Start Your Success Story as the place to start. Oracle is a big company and always on the lookout for talent.  The list of internships & programs is extensive. 

But  specifically what about MySQL?  For someone who is not a recent graduate?

The …

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 Snapshots

We saw in the post one how to create the snapshots automatically (Backup Plan) or Manually. Both type of backups are what we call Managed Snapshots. This means that as a user, we don’t have access to the Object Storage where the backup is stored.

So what’s the purpose of these snapshots ?

Let’s see them:

Data Restore

Restoring a MDS backup is recommended of course to save the data and in case of issue (hardware or software problem unlikely or human issue more …

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 Snapsho...