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.

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

2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and Backup Management. These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Percona’s co-Founder Peter Zaitsev wrote a detailed post about migration from Prometheus to VictoriaMetrics, One of the most significant differences in …