Planet MariaDB

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7 and 8.0 have been […]… Read more

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s. Over the years, it has evolved into a robust and […]… Read more

Greetings everyone!!!!! Let’s begin the phase II of our blog on Aurora serverless-V2. Part 1 – https://mydbops.wordpress.com/2022/05/22/exploring-auAurora-serverless-v2-for-mysqlHere, I have focused primarily on the migration strategies, hence this blog will be helpful for those who are in a stance to migrate towards serverless V2. Before entering into the migration strategies, let’s take a look at the … Continue reading Exploring Aurora serverless for MySQL Part 2 – Migration →… Read more

One of the installation methods we support for our database software is through Helm. We have a collection of Helm charts, in this repository, for the following Percona software: Percona Operator for MySQL Percona XtraDB Cluster Percona Operator for MongoDB Percona Server for MongoDB Percona Operator for PostgreSQL Percona Distribution for PostgreSQL Percona Monitoring and […]… Read more

I recently heard about a company that left the public cloud; by their calculations, this company would save about $7 million dollars in server expenses over 5 years without changing the size of their ops team. The CTO wrote: “Bandwidth, power, and boxes on an amortization schedule of five years… And we’ll have much faster hardware, many more cores, incredibly cheaper NVMe storage, and room to expand at a very low cost (as long as we can still fit in four racks per DC). It may seem arduous, but there are ways to build a customized database stack for mission-critical… Read more

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 in MySQL and MariaDB environments to create a dashboard or run simple ad hoc reports. Furthermore, application developers use complex stored procedures with user-created temporary […]… Read more

In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking capabilities when processing replicated transactions as of MySQL 8.0.18. It does this to carry […]… Read more

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested! Introduction Recently, Percona introduced Percona Builds for Neon (Introducing Percona Builds for Serverless PostgreSQL), which makes it easy to install and experiment with serverless PostgreSQL. And I followed it with how you can run […]… Read more

Our global user conference, MariaDB OpenWorks, is happening May 9-10, 2023. We’ve structured the event so everyone around the globe … Continued… Read more

With a special focus on Percona Operator for MySQL 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, many components need to be considered before deciding on the best solution. When deciding […]… Read more

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 it to the database. In the previous article, we developed a simple application that connects to the MongoDB database (Percona Server for MongoDB) and writes documents in a loop. We only used Composer packages to work with MongoDB. We have set up the Docker-compose environment and have the app/ directory where the application code is located…. Read more

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 release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming week. You can find the Release Notes here Percona Monitoring and Management server docker installation Instructions… Read more

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 […]… Read more

I started to use huge pages for the benchmarks I do with Postgres and MySQL/InnoDB. It helps performance but requires a few more steps to get working and this will be another source of failures for production deployments. See here for an example of the perf improvements.Disclaimer – I am new to this and far from an expert.PostgresAs always, the Postgres docs are useful:Figure out how many huge pages will be needed, call this XEdit /etc/sysctl.conf with vm.nr_huge_pages=$Xsudo sysctl -pCompact the Linux VM (optional, not in the PG docs)Add huge_pages=try or huge_pages=on to the Postgres configurationStart PostgresTo estimate the number… Read more

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, application, and database to develop and run the application. About the application and choice of tools The application I develop gets data from GitHub, Jira, and websites via API, processes it and creates reports according to the desired requirements. The application is developed with PHP version 8+ and Nginx as a web server, and Percona Server for MongoDB as a database…. Read more