I started at Percona a few weeks ago and was looking for a quick way to learn about PMM (Percona Monitoring and Management), which is one of my favorite technologies within Percona to monitor the health of our database infrastructure, explore new patterns in the database behavior, manage and improve the performance of our databases, all with customizable dashboards and real-time alerts using Grafana and VictoriaMetrics.

The best of all is that PMM is Open Source, you can check the PMM repository in case you want to contribute.

There are many flavors for PMM installation, here I will describe the steps to install PMM on Ubuntu 20.04, using Docker for PMM Server on an Amazon EC2 instance.

This image summarizes our goal.

Requirements

…

Connect a Python app to MySQL database with mysqlclient mysql-connector-python PyMySQL and aiomysql.

Connect a Python app to MySQL database with mysqlclient mysql-connector-python PyMySQL and aiomysql.

MySQL Summit at Oracle CloudWorld in Las Vegas, OCT 17-20, is the biggest MySQL event. It includes 80+ sessions, from MySQL sessions, hands-labs, tutorials, birds-of-a-feather, and more. The event represents a unique opportunity to boost your MySQL knowledge and skills, learn what's new with MySQL, meet leading community experts, experts from companies who rely on MySQL, as well as the MySQL Engineering Team. Register now to save $200!

In part one and part two of this series, we introduced the different ways to manage MySQL configurations and precedence when using the Percona XtraDB Cluster (PXC) object and ConfigMap. In this post, we will see the precedence when secrets are used for MySQL configurations in Percona Operator for MySQL based on Percona XtraDB Cluster.

CASE-4: Secret with name cluster1-pxc and ConfigMap with name cluster1-pxc but without configuration in PXC object

When the MySQL configuration is present in the ConfigMap and secret but not in the PXC …

Just as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article.

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.

Image by Peggy und Marco Lachmann-Anke from  …

The cost of downtime can range from loss of business to severe reputation damage. Database downtime feels inevitable but is often preventable.

The causes of database issues that lead to downtime can be categorized in the following ways:

• Human error
• System immaturity
• Application issues

In this post, we will explore how PlanetScale can mitigate all three.

Downtime due to human error

We’ve all done it, dropped the wrong table or index and caused queries to dramatically slow or fail. This can lead to entire site outages, as well as cascading failure that impacts other systems. With standard MySQL, if you drop a table that you later find out was still in use, you are in a situation where you now have to restore from backup. Selecting the …

Learn how PlanetScale protects against downtime due to human error system immaturity and app issues.

In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator.

Percona Distribution for MySQL Operator based on Percona XtraDB Cluster (PXC) provides three ways for managing MySQL, but the question is, what is the precedence among options? We will walk through several cases of using MySQL configs. For the sake of simplicity, we will play with the values of the Galera cache to see the effects.

configuration: |
   [mysqld] …

We are moving right along with the OpenLampTech publication. This week’s issue has a great developer interview, in addition to all the curated MySQL, PHP, and LAMP stack content you’ve come to expect. Let’s get to it. Enjoy OpenLampTech issue #37!

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 #37, I’m sharing articles on:

• MySQL Generated Columns
• PHP solutions to common problems
• Interview with freelance Laravel web developer Ash Allen
• PHP cURL library article
…