Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

Drupal is a popular open-source content management system (CMS) that is used by businesses, governments, and organizations around the world to build and manage websites. It is known for its flexibility, scalability, and security features. On 14th December, Drupal launched the latest upgrade to its popular software. In this article, we will guide you through […]

The developer interviews I publish in the OpenLampTech publication always seem to be a big hit. I enjoy them and learn so much from other developers. This week, I’m reposting another recently published fantastic interview.

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.

This developer interview is with Shawna Brookes, a self-taught full-stack LAMP stack developer. Shawna is making a path all her own and working on a vision for a better web experience.

Don’t miss this interview. Head over to the OpenLampTech publication page and …

As you know, MySQL 8.0 can be used as JSON Document Store to store your documents without being linked to any schema. You can also use CRUD operations to deal with these documents using the MySQL X DevAPI. Of course in documents, it’s possible to also store temporal attributes like date, time, datetime, … Let’s […]

AlmaLinux generally has Java installed. You can check whether java is installed with this command:

which -a java

It should return:

/usr/bin/java

Then, you can check the Java version with this command:

java -version

For AlmaLinux 9, it should return:

openjdk version "11.0.17" 2022-10-18 LTS
OpenJDK Runtime Environment (Red_Hat-11.0.17.0.8-2.el9_0) (build 11.0.17+8-LTS)
OpenJDK 64-Bit Server VM (Red_Hat-11.0.17.0.8-2.el9_0) (build 11.0.17+8-LTS, mixed mode, sharing)

Next, you check whether javac is installed. You can use the which command to determine whether it is installed. Generally, its not installed and you use this command to

sudo dnf search jdk | egrep -- '-17'

It should return:

Last metadata expiration check: 0:11:17 ago on Mon 19 Dec 2022 11:32:48 PM EST.
java-17-openjdk.x86_64 : OpenJDK 17 Runtime Environment
java-17-openjdk-demo.x86_64 …

When using cloud native application architectures, Functions have an important role for the business logic without managing any infrastructure. Functions is a serverless platform powered by the Fn Project open source engine. These Functions are mostly used to create and run different tasks. They can be executed using Fn Project CLI, OCI CLI or a […]

There’s so much great content across the internet. I do my best to share the best I can find each week in the OpenLampTech newsletter. Enjoy this week’s original and curated content. Thank you.

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.

This week in OpenLampTech issue #57, I’m sharing curated content on:

• A curated piece on JSON-Based SQL Injection
• WordPress backup file best practices
• Working with APIs in Laravel
• Using SQL Window functions for percentage calculations
• A new dev environment …

Operators hide the complexity of the application and Kubernetes. Instead of dealing with Pods, StatefulSets, tons of YAML manifests, and various configuration files, the user talks to Kubernetes API to provision a ready-to-use application. An Operator automatically provisions all the required resources and exposes the application. Though, there is always a risk that the user would want to do something manual that can negatively affect the application and the Operator logic.

In this blog post, we will explain how to limit access scope for the user to avoid manual changes for database clusters deployed with Percona Operators. To do so, we will rely on Kubernetes Role-based Access Control (RBAC).

The goal

We are going to have two roles: …

Hello MySQL enthusiasts!

We are excited to announce the schedule for the MySQL & Friends devroom at FOSDEM 2023. This year’s devroom will feature a diverse lineup of talks and presentations focused on MySQL.

The program is still in draft form as we await confirmation of accepted speakers.

We encourage you to mark your calendars and join us for what promises to be an engaging and informative event.

In addition, don’t miss the chance to extend your stay in Belgium and participate to the preFOSDEM MySQL Days that will take place on 2nd and 3rd February 2023. Registration here.

Sunday, Feb 5th