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

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 129

Database Servers Testing Programming 129

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

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

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. The problem with the IIS server access logs was the headers.

Database 168

Database Government Servers Games 168

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. Continuously monitor AI models’ performance.

Strategy 234

Strategy Artificial Intelligence Storage Cloud 234

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

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

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

JANUARY 30, 2023

Today’s post includes those releases and updates that have come out since January 9, 2023. was made available on January 23, 2023. Percona Distribution for MySQL is a single solution with the most critical enterprise components from the MySQL open source community, designed and tested to work together. Take a look!

Open Source 91

Open Source Storage AWS Cloud 91

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 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

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

Dynatrace

SEPTEMBER 8, 2023

SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. To achieve this, we’ll create a Grail bucket specifically designed to retain data for a duration of 10 years (3,657 days). Configuration details Database configuration Endpoint name: Any label to identify this connection.

Database 279

Database Artificial Intelligence Metrics Monitoring 279

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

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

JULY 24, 2023

Answer-driven DevOps automation goes beyond creating tickets and extends to executing workflows designed to extract ownership information and then route the ticket to the responsible teams. Consider an event-driven automation system designed for incident management. Download the free 2023 CIO Report. Download now!

DevOps 231

DevOps Traffic Efficiency Servers 231

Official Blog - World Web Technology

DECEMBER 1, 2023

You can maintain a competitive edge and produce aesthetically pleasing websites in the dynamic field of web design solutions. You can create a website that is visually attractive and easy to use with the best web design solutions and tools. Web Design Solutions Made Easy! Top 9 Software for a Website Designing Company in India!

Design 59

Design Software Software Website 59

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

Percona

FEBRUARY 23, 2023

It is a common practice that before a backup can be stored in the cloud or on a dedicated backup server, it has to be prepared first locally and later copied to the destination. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 125

AWS Storage Database Open Source 125

CSS Wizardry

OCTOBER 16, 2023

I began writing this article in early July 2023 but began to feel a little underwhelmed by it and so left it unfinished. Concatenating our files on the server: Are we going to send many smaller files, or are we going to send one monolithic file? In this post, I’m going to break these processes down into each of: ? The Client.

Cache 338

Cache Latency Strategy Speed 338

Percona

SEPTEMBER 25, 2023

Example: Parallelizing pgBackRest backup and expire with Custom Lock-File Paths In the example below, we’ll set up pgBackRest with minimal settings to illustrate its functionality: primary database server: 172.31.45.240 pgbackrest server: 172.31.32.62 These files play distinct roles in our backup and expiration processes.

Database 101

Database Open Source Storage Servers 101

Percona

MAY 16, 2023

The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts. The idea behind using a connection control plugin is to configure a MySQL server so that the server will delay its response.

Servers 124

Servers Database Monitoring Testing 124

Percona

DECEMBER 29, 2023

These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive. Pressure builds up, and DBAs give up in most cases and allow settings that the database server cannot accommodate. Most of the applications may not be designed and tested for handling such surprises.

Servers 86

Servers Database C++ Airlines 86

The Netflix TechBlog

SEPTEMBER 10, 2024

By Karthik Yagna , Baskar Odayarkoil , and Alex Ellis Pushy is Netflix’s WebSocket server that maintains persistent WebSocket connections with devices running the Netflix application. To support this growth, we’ve revisited Pushy’s past assumptions and design decisions with an eye towards both Pushy’s future role and future stability.

Latency 233

Latency Cache Tuning Efficiency 233

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 89

Programming Servers Database Systems 89

Percona

OCTOBER 11, 2023

There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/

Database 93

Database Open Source Testing Servers 93

Percona

DECEMBER 14, 2023

Steps to convert streaming replication to logical replication: The lab setup includes two servers: primary (172.31.46.28) and standby (172.31.39.50), currently configured with streaming replication. On the primary server, advance the logical replication slot created in step two. Ensure all tables have a replica identity set.

Servers 83

Servers Open Source Database Systems 83

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 103

Performance Latency Cache Virtualization 103

Percona

MAY 15, 2023

MySQL, as well as other RDBMS, are designed to work respecting the model and cannot scale in any way by fragmenting and distributing a schema, so what can be done to scale? In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 128

Traffic Scalability Database Servers 128

Percona

OCTOBER 3, 2023

Main features of pg_timetable Fully database-driven configuration Cron-style scheduling at the PostgreSQL server time zone Built-in tasks such as sending emails, etc. Create a new job to refresh the materialized view each night at 12:00 Postgres server time zone. psql psql (12.16) Type "help" for help.

Open Source 83

Open Source Database Servers Programming 83

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 121

Performance Latency Hardware Storage 121

Percona

OCTOBER 20, 2023

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. Add Citus as a PostgreSQL library Once Citus is installed, we will add “citus” as a shared library to preload when the PostgreSQL server starts.

Scalability 98

Scalability Database Open Source Systems 98

Percona

JUNE 26, 2023

To restore, we can follow either of below approaches: If the standby server is there and the issue does not persist on that, then we can fix the issue by taking logical backup from the standby server, dropping the table on primary, and recreating it using the backup taken. Download Percona Distribution for PostgreSQL Today!

Hardware 80

Hardware C++ Database Open Source 80

Percona

AUGUST 30, 2023

The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. Here is an example: $ export PGDATA=/home/postgres/data $ export PGPORT=5434 $ pg_ctl start waiting for server to start.2023-08-04 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3

Database 109

Database Servers Open Source Tuning 109

Percona

OCTOBER 17, 2023

5/bin/mongod --replSet replset --dbpath /mongo_data/701_rs1/replset/rs1/db --logpath /mongo_data/701_rs1/replset/rs1/mongod.log --port 7001 --fork --keyFile /mongo_data/701_rs1/keyfile --wiredTigerCacheSizeGB 1 about to fork child process, waiting until server is ready for connections. 7001 closed percona> exit /opt/mongo/6.0.6-5/bin/mongod

Metrics 108

Metrics C++ Database Storage 108