Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. So you look at MongoDB Enterprise software, but its costly and complex licensing structure does not meet your budget goals. It ranks No.

Open Source 77

Open Source Database Scalability Software 77

Percona

DECEMBER 12, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 63

Open Source Azure Database Servers 63

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 106

Performance Monitoring Traffic Database 106

Percona

APRIL 14, 2023

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. There is if you have Percona Monitoring and Management (PMM).

Cache 92

Cache Efficiency Database Monitoring 92

Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global memory caches are static in size as they are defined solely by the configuration of the database itself. Let’s take a look at each common resource.

Traffic 90

Traffic Cache Monitoring Database 90

Percona

SEPTEMBER 20, 2023

Introduction of pt-config-diff and the situation As you might know, the Percona Toolkit is a collection of advanced command-line tools used to perform various MySQL, MongoDB, and system tasks that are too difficult or complex to perform manually. Try Percona Distribution for MySQL today! Using the same example.

Open Source 93

Open Source Servers Scalability Database 93

Percona

DECEMBER 2, 2022

Many community members joined Hacktoberfest this year and contributed to various open source projects, and we would like to highlight the most active contributors to Percona software during this fantastic event. This tool is used for automated review comments in PR, and it’s redundant in local setups. PRs: [link]. PRs: [link].

Open Source 56

Open Source Azure Database Speed 56

Percona

OCTOBER 10, 2023

You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover. One convenient way that I’ve found working well is the use of an external POD running the percona-toolkit. Commands end with ; or g. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 97

Database Performance C++ Engineering 97

Percona

JANUARY 4, 2023

MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. For each duplicate key, the tool prints a DROP INDEX statement by default, allowing you to copy-paste the statement into MySQL to get rid of the duplicate key.

Storage 89

Storage Database Engineering Testing 89

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. 2) … 1.3

Servers 85

Servers C++ Database Systems 85

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 74

Servers Database Testing Open Source 74

Percona

DECEMBER 12, 2022

Table modifications are a common task for database administrators. One of the tools in Percona Toolkit is pt-online-schema-change , a utility that alters the structure of a table without interfering with the reads or writes. When the copying is finished, it removes the original table and replaces it with the new one.

Database 60

Database Engineering Testing Processing 60

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. If we combine these components, they become a meaningful tool to help us troubleshoot different issues. Hence, in many cases, Percona Toolkit is helpful without impacting the DB performance.

Performance 98

Performance C++ Monitoring Servers 98