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 114

Innovation Open Source Scalability Servers 114

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 115

Open Source Scalability Database Servers 115

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

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

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

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 111

Open Source Storage AWS Cloud 111

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

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

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

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

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 189

Database Government Servers Games 189

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

Strategy 288

Strategy Artificial Intelligence Storage Cloud 288

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 138

Database Servers Testing Programming 138

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

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

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

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 290

Database Artificial Intelligence Metrics Monitoring 290

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 246

DevOps Traffic Efficiency Servers 246

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 142

AWS Storage Database Open Source 142

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

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 117

Database Open Source Servers Storage 117

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 141

Servers Database Monitoring Testing 141

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 348

Cache Latency Strategy Speed 348

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 103

Servers Open Source Database Systems 103

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 103

Open Source Database Servers Programming 103

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 125

Scalability Database Open Source Systems 125

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 111

Database Open Source Testing Servers 111

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 98

Hardware C++ Database Open Source 98

Scalegrid

JANUARY 10, 2025

According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry. By spreading data across several servers, they support growing applications without sacrificing speed or functionality.

Database 130

Database Scalability Best Practices Blockchain 130

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 98

Programming Servers Database Open Source 98

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 144

Traffic Scalability Database Servers 144

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 234

Latency Cache Tuning Efficiency 234

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 120

Database Servers Open Source Tuning 120

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

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