Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 90

Database Hardware Open Source Strategy 90

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Architecture Database Servers 246

SQL Performance

JULY 19, 2022

The simplest definition of a log record: it describes a single change to a database. A single operation in the database may cause multiple changes , but each change will usually have its own log record to describe it. out of space on the log drive), the database must be set offline in the SUSPECT state. Log Record Types.

Servers 94

Servers Database Storage Engineering 94

Dynatrace

MAY 28, 2020

In this blog, I will be going through a step-by-step guide on how to automate SRE-driven performance engineering. Keptn uses SLO definitions to automatically configure Dynatrace or Prometheus alerting rules. Step-by-step guide: SRE-driven performance analysis with Dynatrace. This is what this blog is all about.

Engineering 192

Engineering Performance Metrics Best Practices 192

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience.

Servers 57

Servers Cache Retail Benchmarking 57

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. The first category would fall under integration testing, and you definitely need that. If so, the database is updated. Or is there?

Design 193

Design Testing Software Performance Database 193

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Performance issues from repeated shrinking of the transaction log.

Servers 54

Servers Database Architecture Performance 54

SQL Performance

APRIL 17, 2020

Along with a large number of restrictions on what is even possible with this command, there is always the question of performance. When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016.

Servers 63

Servers Database Testing Efficiency 63

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. This is where the decision to sunset an otherwise successful stack has less to do with performance and more about changing realities and opportunities. The data migration is performed using the CLI pgloader.

Open Source 124

Open Source Database Architecture Design 124

Percona

OCTOBER 13, 2023

In the case of InnoDB tablespaces, this information is incorporated into the tablespace itself, creating a fusion of metadata and data primarily to enhance performance. This helps improve the performance of metadata retrieval and management for InnoDB tables. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 96

Storage Database Engineering Open Source 96

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 200

Infrastructure Monitoring Virtualization Serverless 200

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Large preview ) We’ve known for a long time that fast page performance influences search engine rankings.

Performance 74

Performance Cache Traffic Metrics 74

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). Topology definition and entity extraction rules.

Technology 217

Technology Technology Metrics Infrastructure 217

SQL Performance

SEPTEMBER 29, 2021

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. definition , 500 ) FROM sys. session_id , o.

Servers 55

Servers Games Database Processing 55

Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again.

Cache 88

Cache Benchmarking Servers Design 88

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application performance for MongoDB , MySQL and PostgreSQL.

Analytics 185

Analytics Storage Database Systems 185

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 104

Cache Hardware Servers Benchmarking 104

The Netflix TechBlog

MAY 19, 2023

Netflix Modeling Challenges Before Caveats SpiceDB, being a Relationship Based Access Control (ReBAC) system, expected authorization checks to be performed against the existence of a specific relationship between objects. A cleanup process to prune stale relationships from the database. This is a Caveated SpiceDB relationship.

Cache 249

Cache Google Open Source Systems 249

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

Percona

SEPTEMBER 19, 2023

The effort has definitely paid off, as we can release shortly after upstream. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. Improved vacuum freezing performance. Why should you care about version 16? PostgreSQL 16 comes packed with features.

Availability 111

Availability Open Source Database Servers 111

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

Dynatrace

NOVEMBER 3, 2021

Monitoring , by textbook definition, is the process of collecting, analyzing, and using information to track a program’s progress toward reaching its objectives and to guide management decisions. Because monitoring tends to focus on key indicators such as utilization rates and throughput, monitoring indicates overall system performance.

Monitoring 221

Monitoring Metrics DevOps Scalability 221

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. You want to optimize your Citrix landscape with insights into user load and screen latency per server? Dynatrace Extensions 2.0 We also give you more value than just metrics and events.

Metrics 169

Metrics Monitoring Network Technology 169

Percona

JULY 19, 2023

I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Retrieve the admin password to log in using the CLI: argocd admin initial-password -n argocd Login to the server. Server Side sync Percona relies on OpenAPI v3.0 Server Side sync Percona relies on OpenAPI v3.0

Servers 81

Servers Best Practices DevOps Open Source 81

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. Also, the fan out step does not need to perform a full graph search.

Cache 240

Cache Database Servers Latency 240

SQL Performance

JANUARY 19, 2021

I don't recall ever having a performance issue with sys.partitions. If you look at the definition for sys.partitions , it is basically what Jake described – a UNION ALL of all the columnstore and rowstore partitions, with THREE explicit references to sys.sysrowsets (abbreviated source here): CREATE VIEW sys. partitions AS.

Performance 55

Performance Database Systems Efficiency 55

Percona

MAY 9, 2023

The term is inherently ominous, and a broad definition isn’t much cheerier. To determine whether that perception is warranted in the database software industry — and if so, how to avoid vendor lock-in pitfalls — let’s dig deeper. The organization’s apps, therefore, must run on one particular server.

Open Source 92

Open Source Database Innovation Cloud 92

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Cloud seriously impacts system architectures that has a lot of performance-related consequences. Mitigating performance risks moves to SaaS vendors.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Percona

JANUARY 4, 2023

MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. Unused indexes are indexes that are created in a database but are not being used in any queries. Since MySQL 8.0,

Storage 89

Storage Database Engineering Testing 89

Percona

NOVEMBER 7, 2023

How to read this book The best way to read this book is from the first page to the last, as the author builds on previous definitions and explanations. The author starts with an overview of the operations performed by the WAL and proceeds into the logical structure. This is a great tool for learning the intricacies of PostgreSQL.

Cache 90

Cache Servers Operating System Database 90

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. ii postgresql-11 11.18-1.pgdg20.04+1

C++ 82

C++ Open Source Database Programming 82

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.

Open Source 84

Open Source Programming Database Servers 84

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL. This is it. The POC Why this POC?

Traffic 126

Traffic Scalability Database Servers 126

The Netflix TechBlog

JULY 30, 2019

The Netflix Media Database (NMDB) is one such example. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. While we’re not (yet) actively measuring the nth percentiles, our production workloads speak for Conductor’s performance.

Lambda 189

Lambda Media Open Source Metrics 189