Planet MariaDB Server
FerretDB – A Quick Look
There is an old saying that what looks like a duck and quacks like a duck is probably a duck. But what looks like MongoDB and acts like MongoDB could…
Using the JSON data type with MySQL 8 – Part II
If you read – Using the JSON data type with MySQL 8 – Part I, you will see that inserting data into MySQL of JSON type is a very common…
How a Database Monitoring Tool Can Help a Developer. The Story of One Mistake.
I will tell you the real story of using database monitoring tools when developing an application. I will show you an example of how I managed to detect and fix…
How To Generate Test Data for Your Database With SQL
Recently, I’ve noticed several posts on the Percona Community blog about test data generation. This is a great trend, as such data enables us to test applications more easily and…
How to prevent unauthorized users from connecting to ProxySQL
ProxySQL is a great load balancer which however suffers from some shortcomings concerning the management of MySQL users. ProxySQL provides a firewall which, in my case, is not complete enough…
Announcing Blip: A New MySQL Monitor
Blip is a new MySQL monitor that collects and reports server metrics. But wasn’t this problem solved long ago? Not really…
How To Optimize the Structure of a Simple PHP Application as Your Project Grows
Let’s discuss the structure of our simple PHP application, folders, files, and functions and transform the project to grow it. You and I have developed a small PHP application that…
How to make a good git commit
As a software developer, your core skill is how to improve an existing code base to make the software better iteratively, patch by patch. To be a good software developer…
Postgres for Oracle DBAs – Parameter Changes
Table of Contents What is included in this blog post ? This is Part 6 of the “Postgres for Oracle DBAs” series where we compare ‘parameter changes’. We covered 1)…
Improve query performance using Optimized Reads on Amazon RDS for MySQL and Amazon RDS for MariaDB
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale MySQL and MariaDB deployments in the cloud. Developers are often required to run complex queries…
KloudDB Shield 1.3 – HTML Feature
Table of Contents What is klouddb_Shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance . Currently we check for 8 RDS controls , 32 controls(Postgres)…
How to Make HTTP Requests to API in PHP App Using GitHub API Example and Write to Percona Server for MongoDB
We learn how to work with HTTP requests in PHP and make API requests using the GitHub API as an example. We’ll get the data from the API and save…
Percona Monitoring and Management 2.36 preview release
Percona Monitoring and Management 2.36 preview release Hello folks! Percona Monitoring and Management (PMM) 2.36 is now available as a preview release. We encourage you to try this PMM preview…
How to Develop a Simple Web Application Using Docker, Nginx, PHP, and Percona Server for MongoDB
I’m developing an application that takes data from different sources, processes it, and prepares reports. In this series of articles, I will explain how to install and configure the tools,…
Some Notable Bugfixes in MySQL 8.0.32
MySQL 8.0.32 came out recently and had some important bugfixes contributed by Perconians. Here is a brief overview of the work done. Inconsistent data and GTIDs with mysqldump Marcelo Altmann…