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 84

Servers Database Open Source Scalability 84

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 78

Monitoring Open Source Scalability Database 78

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 73

Open Source Scalability Database Monitoring 73

Dynatrace

MARCH 18, 2024

Yet, in 2023, 82% of cloud decision makers reported that managing cloud spend was their top challenge, according to one source. Following FinOps practices, engineering, finance, and business teams take responsibility for their cloud usage, making data-driven spending decisions in a scalable and sustainable manner.

Best Practices 242

Best Practices Strategy Cloud AWS 242

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 84

Servers C++ Database Systems 84

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 91

Servers Database Testing Open Source 91

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 106

Systems Scalability Servers Design 106

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 88

Monitoring Code Open Source Cache 88

Official Blog - World Web Technology

JUNE 13, 2023

It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. In that case, the developer should be able to build scalable WordPress themes and plugins. The post How to Become a WordPress Developer in 2023 appeared first on World Web Technology.

Development 52

Development Website Ecommerce Code 52

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]

Database 100

Database Testing Servers Open Source 100

Official Blog - World Web Technology

APRIL 12, 2023

JavaScript is a server-side programming language and is also known as a scripting language as well. This is a server-side programming language and one of the most preferred languages for website development. The post What Skills Are Required For WordPress Developer In 2023? Take your time and choose the best one.

Development 52

Development Website Ecommerce Programming 52

Percona

AUGUST 18, 2023

2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. to MySQL 8.x

Open Source 67

Open Source Database Storage Engineering 67

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 83

Servers Open Source Tuning Cache 83

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 96

Database Performance C++ Engineering 96

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 80

Cloud Open Source Strategy Best Practices 80

Percona

AUGUST 3, 2023

And try now the SELECT * again: mysql> 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 78

Best Practices Open Source Code Engineering 78

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Whether it is a production server, a test environment, or a developer’s workstation, this encapsulation makes it easier to deploy MongoDB instances in a variety of scenarios, making it more portable and scalable. docker-entrypoint."

Scalability 59

Scalability Best Practices Servers Database 59

Percona

AUGUST 17, 2023

In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). Craig Kerstiens, crunchydata, August 2023 ) That evolution has created lots of reasons for its expanding popularity.

Open Source 79

Open Source Healthcare Social Media Database 79

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 96

Open Source Traffic Tuning Database 96

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. Elevate your MariaDB environment with Percona Support for MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

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 87

Monitoring Open Source Servers Scalability 87

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 82

Open Source Programming Database Servers 82

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. An improperly configured server may not allocate sufficient resources or be optimized for the specific workload.

Tuning 52

Tuning Database Performance Hardware 52

Percona

OCTOBER 16, 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 2, 2023. On October 5, 2023, Percona Monitoring and Management 2.40.0 was released on October 3, 2023.

Servers 75

Servers Monitoring Open Source Scalability 75

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 93

Scalability Database Open Source Systems 93

Percona

NOVEMBER 13, 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 31, 2023. came out on November 2, 2023. was released on November 1, 2023. Take a look.

Innovation 87

Innovation Open Source Scalability 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 79

Monitoring Open Source Scalability Database 79

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 84

Open Source AWS Servers Database 84

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 80

Open Source Servers Database Scalability 80

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 84

Open Source Servers Database Scalability 84

Percona

MAY 29, 2023

Today’s post includes those releases and updates that have come out since May 8, 2023. On May 22, 2023, we released updates to Percona Distribution for PostgreSQL versions 15.2, On May 25, 2023, Percona Distribution for MongoDB 6.0.6 On May 25, 2023, Percona Distribution for MongoDB 6.0.6 Take a look! was released.

Open Source 78

Open Source Servers Scalability Database 78

ACM Sigarch

MAY 31, 2023

To understand the current status, needs, and challenges in HCM, the first workshop for Heterogeneous and Composable Memory was held with HPCA’23 on Feb 26, 2023. Memory disaggregation separates memory pools from traditional server boxes, enabling more flexible resource allocation and potentially reducing costs.

Latency 52

Latency Hardware Cache Architecture 52

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 84

Open Source Database Servers Scalability 84

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

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 78

Monitoring Open Source Database Servers 78

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 78

Open Source Servers AWS Database 78

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Load balancing and replication: Scaling the database system horizontally by distributing the workload across multiple servers using techniques like connection pooling, read replicas, or implementing a primary-replica replication setup.

Tuning 52

Tuning Efficiency Database Performance 52