Percona

JULY 10, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. was released on June 28, 2023. was released on June 29, 2023. Take a look!

Monitoring 79

Monitoring Open Source Scalability Database 79

Percona

APRIL 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. 24 was released on April 18, 2023. 24 (2023-03-20) release notes. Take a look!

Open Source 80

Open Source Storage Servers Database 80

Percona

JULY 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. PMM) was released on July 13, 2023. PMM) was released on July 13, 2023.

Open Source 74

Open Source Scalability Database Monitoring 74

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 87

Servers Database Open Source Scalability 87

Percona

FEBRUARY 27, 2023

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.

Monitoring 71

Monitoring Open Source Database Software 71

Percona

JANUARY 9, 2023

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 87

Open Source Database Servers Software 87

Percona

SEPTEMBER 21, 2023

You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. The expo hall is open Friday – Sunday.

Open Source 115

Open Source Programming Software Software 115

Percona

MARCH 1, 2023

has had a good, long run, but the official End of Life is October of 2023. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL?

Servers 121

Servers Open Source Tuning C++ 121

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 108

Servers C++ Storage Systems 108

Dynatrace

JUNE 15, 2023

Incorporating cloud application security practices is an effective way for organizations to avoid application security risks, ensure a smoothly running software development lifecycle (SDLC), and establish an overall strong security posture. However, open source software is often a vector for security vulnerabilities.

Cloud 177

Cloud Open Source Architecture Monitoring 177

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 83

Cloud Open Source Strategy Best Practices 83

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. bullseye amd64 1.7

Servers 85

Servers C++ Database Systems 85

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Many folks used to create directly on Primary, resulting in the first index being created successfully on Primary and then replicated to Secondary nodes. Starting from PSMDB 4.4, Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function

Servers 82

Servers C++ Storage Best Practices 82

Percona

DECEMBER 6, 2023

The PMM Dump performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server securely with the Percona Support team. 2023-01-05T20:01:33+03:00 INF Processing 1/49 chunk.

Monitoring 101

Monitoring Metrics Analytics Open Source 101

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This partially happened, and we are testing Percona Toolkit with Percona Server for MySQL 5.7 2023-12-21T15:29:22 Creating triggers. 2023-12-21T15:29:22 Created triggers OK. 2023-12-21T15:29:22 Copying approximately 1 rows. 2023-12-21T15:29:22 Copied rows OK. _t1_new` OK.

Operating System 100

Operating System Programming Open Source Testing 100

Percona

FEBRUARY 9, 2023

Welcome to 2023! If you replicate from one server to the next, are you replicating what you need? Take some to check how the server is being accessed, as you do not want a project to use the root access for all queries. Third, double-check the version of the software that is in use. First, how are your backups?

Database 94

Database Open Source Hardware Operating System 94

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 109

C++ Servers Storage Speed 109

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. Continuing this trajectory into the future improvements in the development of our software products will require many decisions. which is scheduled for EOL by the end of October 2023.

Open Source 93

Open Source Database Operating System Programming 93

Dynatrace

MAY 17, 2023

Anyone who’s concerned with developing, delivering, and operating software knows the importance of making software and the systems it runs on observable. That is, relying on metrics, logs, and traces to understand what software is doing and where it’s running into snags. What is OpenTelemetry?

Metrics 180

Metrics Open Source Traffic Cache 180

Percona

AUGUST 4, 2023

Percona has bundled together some great open source pieces of software to create Percona Monitoring and Management (PMM), a very flexible and powerful monitoring solution. sec) Grafana data source Now that we have the power production data in MySQL, we need to configure Grafana to access the MySQL server.

Monitoring 77

Monitoring Open Source Database Metrics 77

Percona

DECEMBER 12, 2023

Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’ s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make the replica in sync with the primary. The print result is good.

Servers 93

Servers Database Testing Open Source 93

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). It has evolved steadily, however, during 25 years as an open source project.

Open Source 80

Open Source Healthcare Social Media Database 80

Percona

SEPTEMBER 19, 2023

PostgreSQL Community released PostgreSQL 16 on September 14, 2023. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. As we are committed to open source, we hope to involve the community in discussing the best approaches for transparent data encryption (TDE) in PostgreSQL.

Availability 112

Availability Open Source Database Servers 112

Percona

MARCH 3, 2023

23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23. One replica with the same software version (in Read-Only and Super-Read-Only mode). sec) Finally, we show you below the topology presented by the client in question: 1.

Database 103

Database Testing Servers Open Source 103

Percona

JULY 27, 2023

on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. is in October of 2023. is an evolution of the MySQL server and related software. Do you have suspicious group replication servers showing up? Suspicious servers?

Servers 84

Servers Open Source Tuning Cache 84

Percona

MAY 2, 2023

out" INFO[2023-04-22 06:54:10] Running pt-stalk --no-stalk --iterations=2 --sleep=30 --host=localhost --dest=/home/vagrant/pt/ --port=3306 --user=root --password= ** INFO[2023-04-22 06:55:42] Creating output file "/home/vagrant/pt/pt-summary_2023-04-22_06_55_42.out" 6032: connect: connection refused" source="exporter.go:169"

Database 96

Database Systems Open Source Engineering 96

Official Blog - World Web Technology

APRIL 12, 2023

Here are the benefits of WordPress: It is a free, open-source CMS and can be used by anyone who wants to develop a website. You can download the software by simply clicking on wordpress.org. JavaScript is a server-side programming language and is also known as a scripting language as well.

Development 52

Development Website Ecommerce Programming 52

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 103

Cache Database Virtualization Servers 103

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Promtail will be in charge of reading the log files and sending new information to the Loki server.

Monitoring 88

Monitoring Servers Metrics Database 88

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Advantages of migrating to open source For many reasons mentioned earlier, organizations are increasingly shifting towards open source databases for their data management needs.

Open Source 96

Open Source Database Hardware Strategy 96

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. added`);END Suffix: ins Time : AFTER -- 2023-07-26T12:22:43 Created triggers OK. 2023-07-26T12:22:43 Copying approximately 4 rows.

Database 99

Database Performance C++ Engineering 99

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. What is MariaDB? Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Percona

OCTOBER 4, 2023

was released on October 3, 2023. They include more vulnerabilities than Open Source tools that we use, can find, and help us improve the quality of Go-based tools. Percona Toolkit 3.5.5 This blog post covers the main changes in this release. Quality control is not only about code fixes but also about testing.

Open Source 104

Open Source Code Testing Systems 104

Percona

JULY 24, 2023

To make sure that Percona Backup for MongoDB answers the pains of our customers, we took the common denominator of the pains that anyone using snapshot capabilities faces when performing backups and restores and positioned PBM as the open source, freely available answer to those pains. I am happy to announce that with PBM 2.2.0,

Availability 78

Availability Open Source Strategy Storage 78

Percona

JUNE 28, 2023

2023-06-22T08:23:29.003334Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:group_post_state_exchange():433: Reversing history: 171 -> 44, this member has applied 127 more events than the primary component.Data loss is possible. sandbox server started At this point, notice that from node1, you have: $./sandboxes/pxc_msb_8_0_31/node1/use

C++ 79

C++ Open Source Servers Monitoring 79

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 140

Performance Latency Hardware Storage 140