Percona

MARCH 13, 2023

Today’s post includes those releases and updates that have come out since February 27, 2023. Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 Download Percona Server for MySQL 5.7.41-44 This release is based on Percona Server for MongoDB 4.2.24-24 Take a look!

Servers 98

Servers Open Source Database Software 98

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 110

Open Source Azure Servers Programming 110

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 107

Monitoring Open Source Scalability Database 107

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 111

Open Source Servers Database Scalability 111

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 125

Scalability Database Open Source Systems 125

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. Cloud-based development and deployment One of the main advantages of cloud-based development and deployment is scalability. Another benefit is cost savings associated with server and data center setup and maintenance.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

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 107

Monitoring Open Source Servers Database 107

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 107

Open Source Servers Database AWS 107

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 98

Open Source Servers Scalability Cache 98

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 103

Open Source Database Servers Scalability 103

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 98

Open Source Servers Scalability Database 98

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 288

Strategy Artificial Intelligence Storage Cloud 288

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 98

Open Source AWS Servers Database 98

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 98

Open Source Servers Database Scalability 98

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 111

Servers Database Open Source Scalability 111

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 103

Monitoring Open Source Database Servers 103

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 98

Monitoring Open Source Database Scalability 98

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 98

Open Source Database Scalability Monitoring 98

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 98

Servers C++ Database Systems 98

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 246

DevOps Efficiency Monitoring Infrastructure 246

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 246

DevOps Traffic Efficiency Servers 246

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 107

Scalability Database Open Source Traffic 107

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Scalability Best Practices Blockchain 130

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 124

Testing Database Servers Open Source 124

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 144

Traffic Scalability Database Servers 144

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 243

Metrics Database Monitoring Network 243

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 107

Servers Database Testing Open Source 107

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 114

Engineering Database Servers Analytics 114

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 114

Monitoring Code Open Source Cache 114

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 98

Open Source Servers Scalability Database 98

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 98

Open Source Database Scalability Software 98

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 114

Database Performance C++ Engineering 114

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 111

Systems Scalability Servers Design 111

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 113

Cloud Open Source Strategy Best Practices 113

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 98

Servers Open Source Tuning Cache 98

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 135

Open Source Database Software Software 135

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 98

Best Practices Open Source Code Engineering 98