This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure. The first article was dedicated on Backups, this one is about Disk Space Utilization. This time we have two options to retrieve useful information related to disk […]

In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.

Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, …

But as a serious DBA, you want to know the status of all this and maintain some control.

Some information is available on OCI’s webconsole and some in Performance_Schema and Sys.

If you use MySQL Shell for Visual Studio Code, you have the possibility to see an overview of your server using the Performance Dashboard:

But today we will take a look at the backup, a very important responsibility of the DBA.

When you use MySQL Database Service on OCI, you can define the backup policy at the DB Instance’s creation. You can always modify it later:

In …

In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job. Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, … But as a serious DBA, you […]

I’ve been enjoying OpenLampTech for 70 weeks now. Wow! That’s a lot of publishing. But, more importantly, a lot of learning. And forming relationships with the readers. I am so grateful you are reading OpenLampTech. Thanks!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #70, I am sharing some fantastic articles on:

• ‘Tainted’ PHP code
• Linux package dependencies
• 10 useful PHP array functions
• SQL NULL value
• And much, much more

Thanks so much for …

New series of articles about how to find useful information when using MySQL Database Service

I recently had the chance to read in preview Bill Karwin‘s new book: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming. This book is a rework of Bill’s best seller from 2010. The new book can be considered as the second edition and is updated with Bill’s latest observations about common mistakes. The […]

MySQL book review: SQL Antipatterns, volume 1

Overview

HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy), in the last few years I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture there are many components that need to be considered before deciding what is the best solution.

When deciding what to pick, there are many things to consider like where the proxy needs to be, if it “just” needs to redirect the connections or if more features need to be in, like caching, filtering, or if it needs to be integrated with some MySQL embedded automation.

Given that, there never was a single straight answer, instead an analysis needs to be done. Only after a better understanding of the environment, the needs and the evolution that the platform needs to achieve is it possible to decide what will be the better choice.

However recently we have seen an increase in usage of MySQL on Kubernetes, especially with the …

Learn how to build a products listing application with Golang and a MySQL database.

Read the full story

Learn how to build a products listing application with Golang and a MySQL database.