Percona

JUNE 26, 2023

Today’s post includes those releases and updates that have come out since June 12, 2023. On June 15, 2023, Percona Distribution for MySQL (PS-based variation) 8.0.33 This release is focused on the Percona Server for MySQL-based deployment variation and is based on Percona Server for MySQL 8.0.33-25. Take a look!

Servers 75

Servers Open Source Scalability Database 75

Percona

DECEMBER 18, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since December 4, 2023. was released on December 12, 2023. was released on December 5, 2023. Take a look.

Monitoring 93

Monitoring Open Source Servers Database 93

Percona

AUGUST 7, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since July 24, 2023. On August 2, 2023, we released Percona Distribution for MySQL (PXC-based variant) 8.0.33. Take a look.

Open Source 90

Open Source Servers Scalability Database 90

Dynatrace

JANUARY 17, 2024

According to the McKinsey Global Survey, “ The state of AI in 2023: Generative AI’s breakout year ,” 40% of respondents say their organizations will increase their investment in AI overall because of advances in generative AI. Use containerization. Continuously monitor AI models’ performance.

Strategy 234

Strategy Artificial Intelligence Storage Cloud 234

Percona

OCTOBER 2, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since September 18, 2023. was released on September 26, 2023. Percona Server for MySQL 8.0.34-26 Take a look.

Open Source 85

Open Source Scalability Database Servers 85

Percona

AUGUST 21, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since August 7, 2023. was released on August 14, 2023. Percona Server for MySQL 5.7.43-47 Take a look.

Open Source 87

Open Source AWS Servers Database 87

Percona

OCTOBER 31, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since October 16, 2023. PMM) was released on October 20, 2023. was released on October 16, 2023. Take a look.

Monitoring 85

Monitoring Open Source Scalability Database 85

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 90

Servers Database Open Source Scalability 90

Percona

JUNE 12, 2023

Today’s post includes those releases and updates that have come out since May 29, 2023. On June 5, 2023, we released Percona Monitoring and Management 2.37.1 , which includes a critical CVE fix. We have identified and fixed CVE-2023-34409: PMM-12182 : PMM authentication bypass vulnerability. was released on June 5, 2023.

Open Source 88

Open Source Servers Database Scalability 88

Percona

FEBRUARY 13, 2023

Today’s post includes those releases and updates that have come out since January 30, 2023. On January 30, 2023, Percona Monitoring and Management 2.34.0 , an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB, was released. was released on February 9, 2023.

Open Source 89

Open Source Database Servers Scalability 89

Percona

DECEMBER 4, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since November 13, 2023. On November 27, 2023, Percona Distribution for MySQL (PS- based variant) 8.1.0 Take a look.

Open Source 86

Open Source Azure Servers Programming 86

Percona

OCTOBER 20, 2023

You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. This is how Citus defines sharding: “Sharding is a technique used in database systems and distributed computing to horizontally partition data across multiple servers or nodes.

Scalability 98

Scalability Database Open Source Systems 98

Percona

MARCH 27, 2023

Today’s post includes those releases and updates that have come out since March 13, 2023. was released on March 23, 2023. On March 15, 2023, Percona Distribution for MySQL (Percona XtraDB Cluster-based variant) 8.0.31 Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 Take a look!

Open Source 83

Open Source Servers Scalability Cache 83

Percona

SEPTEMBER 18, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since September 4, 2023. was released on September 14, 2023. On September 7, 2023, Percona Distribution for MongoDB 5.0.20

Open Source 86

Open Source Servers Database Scalability 86

Percona

APRIL 10, 2023

Today’s post includes those releases and updates that have come out since March 27, 2023. was released on March 27, 2023. Release highlights include: Added a new extension pgpool – a middleware between PostgreSQL server and client for high availability, connection pooling, and load balancing. Take a look!

Open Source 83

Open Source Servers Database AWS 83

Percona

JULY 10, 2023

Today’s post includes those releases and updates that have come out since June 26, 2023. On July 3, 2023, Percona Monitoring and Management 2.38 (PMM), an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB, was released. was released on June 28, 2023. Take a look!

Monitoring 82

Monitoring Open Source Database Scalability 82

Percona

MAY 8, 2023

Today’s post includes those releases and updates that have come out since April 24, 2023. On May 2, 2023, Percona Monitoring and Management 2.37 (PMM) was released. was released on May 4, 2023. Release highlights include bug fixes and improvements provided by MongoDB and included in Percona Server for MongoDB 5.0.17-14,

Monitoring 82

Monitoring Open Source Database Servers 82

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. Infrastructure monitoring Infrastructure monitoring reviews servers, storage, network connections, virtual machines, and other data center elements that support applications.

DevOps 231

DevOps Efficiency Monitoring Infrastructure 231

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 88

Servers C++ Database Systems 88

Percona

JULY 24, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since July 10, 2023. PMM) was released on July 13, 2023. was released on July 19, 2023. Take a look. was released.

Open Source 77

Open Source Database Scalability Monitoring 77

Dynatrace

JULY 24, 2023

In the world of DevOps and SRE, DevOps automation answers the undeniable need for efficiency and scalability. When a server experiences an outage, the system promptly triggers an alert and initiates actions like restarting a server or redirecting traffic to a redundant server. Download the free 2023 CIO Report.

DevOps 231

DevOps Traffic Efficiency Servers 231

Percona

OCTOBER 19, 2023

Welcome to the first installment of our series: Scalable Solutions with Percona Distribution for PostgreSQL. sudo percona-release setup ppg-15 # Install "percona-ppg-server-15" package sudo apt install percona-ppg-server-15 Now, let’s verify if the service is operating correctly.

Scalability 91

Scalability Database Open Source Traffic 91

Percona

MAY 15, 2023

As said, the last one is probably the most powerful, scalable, and difficult to design, and unfortunately, it represents probably less than 5% of the solution currently deployed. As well, very few cases are in need to have a full system/solution to provide scalability with sharding. The POC Why this POC?

Traffic 128

Traffic Scalability Database Servers 128

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. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. mysqlserver01=127.0.0.2 [RW] RW] [ver: 8.0.31-23]

Testing 106

Testing Database Servers Open Source 106

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 96

Servers Database Testing Open Source 96

Percona

SEPTEMBER 14, 2023

Once we configured the setup, the ClickHouse server will act as a replica. sec) From the ClickHouse end Make sure you have MySQL port access from the ClickHouse server to the MySQL server. file: /etc/clickhouse-server/users.xml) #vi /etc/clickhouse-server/users.xml <profiles> <default> <!--

Engineering 95

Engineering Database Servers Analytics 95

Percona

DECEMBER 20, 2023

we have been able to resize the InnoDB buffer pool online, which allows administrators to adjust the buffer pool size dynamically without requiring a server restart, offering a flexible solution for optimizing system resources. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool.

Monitoring 94

Monitoring Code Open Source Cache 94

InfoQ

MAY 14, 2024

Building reliable stateful services at scale isn’t a matter of building reliability into the servers, the clients, or the APIs in isolation. By combining smart and meaningful choices for each of these three components, we can build massively scalable, SLO-compliant stateful services at Netflix. By Joseph Lynch

Systems 109

Systems Scalability Servers Design 109

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Let’s click “Apache Web Server apache” now. Register now!

Metrics 182

Metrics Monitoring Database Network 182

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 102

Database Performance C++ Engineering 102

Percona

APRIL 17, 2023

reaches end of life in October 2023. support, beyond its end-of-life in October 2023. If you have not been keeping up with MySQL news, MySQL 5.7 This means no more bug fixes or security updates for MySQL 5.7. Users will be effectively forced to upgrade to MySQL 8. Upgrading to MySQL 8 from 5.7 please get in touch with us.

Open Source 78

Open Source Servers Scalability Database 78

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). DBAs and developers appreciate its combination of flexibility, scalability, and performance. Redis ranks right after MongoDB as the sixth most popular database management system ( DB-Engines, July 2023 ). It ranks No. Couchbase — No.

Open Source 80

Open Source Database Scalability Software 80

Percona

JULY 27, 2023

on July 17th, 2023. is in October of 2023. is an evolution of the MySQL server and related software. Seems like a lot of work to do while servers are failing, but it should save the data in a better state. Do you have suspicious group replication servers showing up? Suspicious servers? Tempus Fugit!

Servers 87

Servers Open Source Cache Tuning 87

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 85

Cloud Open Source Strategy Best Practices 85

Percona

APRIL 28, 2023

Your apps, therefore, must run on one particular server. This option couples the cost-efficiency and scalability of open source with the simplicity (task-focused), cohesiveness (components work together), and security of proprietary software. And even when those needs are met, they’re soon to evolve.

Open Source 119

Open Source Database Software Software 119

Percona

JUNE 2, 2023

But, for a long time, you needed to be comfortable with mysqldump or other backup / restore methods to move servers or providers. You could cram servers full of users with their own small slice of resources for cheap. As of May 2023; those numbers will no doubt change over time.) Sometimes too many.

Open Source 102

Open Source Traffic Tuning Database 102

Percona

AUGUST 3, 2023

And try now the SELECT * again: mysql&gt; SELECT * FROM articles; + -+ + + | id | ts | article | + -+ + + | 1 | 2023-07-28 13:15:03 | This is first article | | 2 | 2023-07-28 13:15:03 | This is second article | | 3 | 2023-07-28 13:15:03 | This is third article | + -+ + + You see, the column is not returned.

Best Practices 82

Best Practices Open Source Code Engineering 82