Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. This means that as your application grows and more clients connect to the database, pgpool-II can distribute the load across multiple servers, preventing any one server from becoming overwhelmed.

Cache 118

Cache Open Source Benchmarking Database 118

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 116

Servers Best Practices Database Open Source 116

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. OpenTelemetry, the open source observability tool, has emerged as an industry-standard solution for instrumenting application telemetry data to make it observable. OpenTelemetry is a free and open source take on observability.

Metrics 182

Metrics Open Source Traffic Cache 182

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 139

Tuning Cache Servers Benchmarking 139

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB.

Open Source 82

Open Source Servers Scalability Cache 82

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client. PHP is an open-source programming language that allows businesses to use it for free.

Development 98

Development Ecommerce Open Source Website 98

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 108

Performance Monitoring Traffic Database 108

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 106

Cache Hardware Servers Benchmarking 106

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 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. Initializing a DD engine and the cache adds complexity and other server dependencies.

Cache 89

Cache Benchmarking Servers Design 89

Percona

JULY 17, 2023

MongoDB replica sets enable data redundancy and automatic failover, setting the stage (there’s that term again) for high availability. Not really open source : Even the MongoDB Community version is not open source; it’s source-available and is under the SSPL license (introduced by MongoDB itself).

Open Source 80

Open Source Database Scalability Software 80

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., It’s a pretty impressive effort to pull together and make available in open source (not yet available as I write this) such a suite, and I’m sure explains much of the long list of 24 authors on this paper.

Open Source 61

Open Source Hardware Benchmarking Systems 61

HammerDB

JUNE 27, 2022

These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 130

Performance Hardware Tuning Storage 130

Percona

JULY 27, 2023

MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. 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. Suspicious servers? Tempus Fugit!

Servers 87

Servers Open Source Tuning Cache 87

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use. PHP can work perfectly on shared hosting and private servers, making it an excellent choice for building websites.

Website 59

Website Development Open Source Database 59

Percona

APRIL 3, 2023

Below are some of the upgrade options available to upgrade to PG11 or above. Upgrade Complete - Optimizer statistics are not transferred by pg_upgrade so, once you start the new server, consider running: /analyze_new_cluster.sh Pg_dump and pg_restore: We can refer to PostgreSQL Upgrade Using pg_dump/pg_restore on dump/restore methods.

C++ 106

C++ Database Cache Storage 106

Dynatrace

APRIL 21, 2022

Missing caching layers. With the reliability pillar of the Well-Architected Framework, organizations must ensure they build resilient and available applications. Some principles Microsoft provides to help organizations across this area include: Define and test availability targets such as service level agreements (SLAs) and SLOs.

Azure 190

Azure Monitoring Virtualization Metrics 190

IO River

NOVEMBER 2, 2023

Started years ago with a focus on cloud management, Terraform built a massive community around its open-source license–up until two weeks ago, but more on that later. A significant factor that contributed to Terraform's rise to prominence is its open-source nature. ‍Why Manage Infrastructure by Code?

Open Source 52

Open Source DevOps AWS Azure 52

Smashing Magazine

AUGUST 3, 2023

Time To First Byte (TTFB) This is the time it takes for the first piece of information from the server to reach the user’s browser. You need to beware that slow server response times can significantly increase TTFB, often due to server overload, network issues, or un-optimized logic on the server side.

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

JUNE 29, 2021

Without build optimizations (incremental builds, caching, we will get to those soon) this will eventually become unmanageable as well — think about going through all images in a website: resizing, deleting, and/or creating new files over and over again. Under the hood, it simplifies a lot of the work to the server-side.

Cache 129

Cache Website Strategy Traffic 129

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. There are many tools allowing you to achieve that: SiteSpeed.io Large preview ).

Performance 145

Performance Cache Media Metrics 145

CSS - Tricks

JUNE 5, 2020

It took a few months for major CDN players to support Brotli, but meanwhile it was seeing widespread adoption in tools, services, browsers and servers. The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. We only cache hot files in memory at edge servers.

Cache 79

Cache Website Servers Open Source 79

IO River

NOVEMBER 2, 2023

significant factor that contributed to Terraform's rise to prominence is its open-source nature. Being open-source, Terraform invited a vast community of developers and companies to rally around it. Take Cloudflare as an example; they have an entire service called Cloudflare Terraform.

Open Source 40

Open Source DevOps AWS Azure 40

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. These table cache instances could be accessed concurrently, allowing DML to use cached table descriptors without locking each other.

Cache 64

Cache Database Games Healthcare 64

Percona

DECEMBER 19, 2022

include: Offline metric collection during PMM server outages or loss of PMM client-server network connectivity. Client-side caching minimizes potential for metrics loss. This new feature ensures that the PMM Client saves the monitoring data locally when a connection to the PMM server is lost, preventing gaps in the data.

Metrics 52

Metrics Monitoring Servers Open Source 52

Percona

DECEMBER 20, 2023

The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. This is available only for the log_error_verbosity=3. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5, Try Percona Distribution for MySQL today!

Monitoring 91

Monitoring Code Open Source Cache 91

The Netflix TechBlog

MARCH 5, 2019

the order of the rows on your Netflix home page, issuing content licenses when you click play, finding the Open Connect cache closest to you with the content you requested, and many more). Security Events Platform See open source project such as StreamAlert and Siddhi to get some general ideas.

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

Smashing Magazine

OCTOBER 26, 2021

We will go through how to set up an Nx server, how to add a plugin to an existing server, and the concept of a monorepo with a practical visualization. Nx uses distributed graph-based task execution and computation caching to speed up tasks. Nx also stores the cached project graph. framework and TypeScript. What Is Nx?

Cache 109

Cache Servers Code Storage 109

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. There is an issue with this, which causes the OS to swap even with memory available. Spoiler alert: This post focuses on MongoDB 3.6.X 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks.

Performance 145

Performance Cache Network Metrics 145

Percona

MAY 2, 2023

Also, we will take a look at our open-source backup utility custom-built to help avoid costs and proprietary software – Percona Backup for MongoDB or PBM. Hence, the node would still be available for other operations. A logical backup with MongoDB means you’ll be dumping the data into a BSON-formatted file.

Best Practices 52

Best Practices Database Storage Servers 52

Dotcom-Montior

MARCH 27, 2022

Any website request initially goes to the DNS server to fetch the IP address of the website and accesses it on the responded address. If the DNS caches are manipulated to contain wrong IP addresses, it’s called DNS poisoning. Here is how you can address the issues caused by censorship with available tools and techniques.

Website 82

Website Internet Internet Performance 82

Percona

MAY 1, 2023

Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. This parameter sets how much dedicated memory will be used by PostgreSQL for the cache.

Tuning 52

Tuning Efficiency Database Performance 52

Brendan Gregg

JULY 2, 2021

opensnoop Files opened table. cachestat File system cache statistics line charts. The architecture is: While the bpftrace binary is installed on all the target systems, the bpftrace tools (text files) live on a web server and are pushed out when needed. execsnoop New processes (via exec(2)) table. at the time.

Latency 145

Latency Cache Energy Systems 145

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. about to fork child process, waiting until server is ready for connections. connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb

Scalability 62

Scalability Best Practices Servers Database 62