Dynatrace

FEBRUARY 9, 2023

We recently extended the pre-shipped code-level API definitions to group logical parts of our code so they’re consistently highlighted in all code-level views. Another benefit of defining custom APIs is that the memory allocation and surviving object metrics are split by each custom API definition.

Java 208

Java Metrics Servers Code 208

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

Speed Curve

FEBRUARY 5, 2024

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. I mean, why wouldn't we?

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

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

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 HaProxy was acting as a load balancer in front of the cluster. Commands end with ; or g.

Database 101

Database Performance C++ Engineering 101

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Yes, there is a workaround.

Open Source 121

Open Source Database Servers Scalability 121

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

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

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. But changing this is possible only at the server startup. But they are generally used by client tools.

Database 108

Database Servers Open Source Tuning 108

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 Why use Extensions. So whether you want to….

Metrics 169

Metrics Monitoring Network Technology 169

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. A transaction encompasses a change or a set of changes to a database. Logging, Log Records, and the SQL Server Transaction Log.

Servers 54

Servers Database Architecture Performance 54

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 99

Storage Database Engineering Open Source 99

Percona

NOVEMBER 7, 2023

The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to order a printed copy became available ( [link] ). This 548-page tome from PostgresPro covers the spectrum from data organization to details on the many available indexing options.

Cache 93

Cache Servers Operating System Database 93

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 85

Open Source Programming Database Servers 85

Percona

JULY 25, 2023

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. The redo apply phase wouldn’t make the database consistent with respect to a transaction.

Cache 89

Cache Benchmarking Servers Design 89

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 107

Cache Hardware Servers Benchmarking 107

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. Experienced database administrators learn to spot patterns that can lead to common problems. Monitoring vs. observability.

Monitoring 220

Monitoring Metrics DevOps Scalability 220

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. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. This is not something you can do on a replica node. And we are back at square one.

Analytics 185

Analytics Storage Database Systems 185

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 95

Open Source Database Innovation Cloud 95

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

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 87

Speed Virtualization Storage Open Source 87

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. To improve usability and operability, we added validations, which in practice has greatly helped find bugs during creation of workflow and task definitions.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

APRIL 4, 2023

” While this is definitely a valid use case, I hadn’t personally come across an issue in the wild where the application fix wasn’t trivial. To quickly set up the environment, ProxySQL was installed locally on the host running pt-archiver and set up with a single backend (the target testbed server).

Open Source 112

Open Source Servers Engineering Scalability 112

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. When you create a view, SQL Server records metadata information in a number of catalog objects. Using SELECT * in the view’s inner query is a bad idea.

Code 117

Code Database Servers Availability 117

Dynatrace

APRIL 21, 2022

If you still use the legacy version of Log Monitoring ( Log Monitoring v1 ), the Log Monitoring v1 documentation is still available, but we strongly encourage you to switch to the latest Dynatrace Log Monitoring version and gain direct access to the log content of all your mission-critical processes. General Availability (Build 1.239.178).

Azure 216

Azure Metrics AWS Monitoring 216

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition. After the rapid release 6.2

Metrics 107

Metrics C++ Storage Database 107

SQL Server According to Bob

FEBRUARY 9, 2020

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs.

Servers 40

Servers Database Availability Azure 40

Percona

APRIL 26, 2023

When a project’s source code is available to all, the question of security isn’t far behind. Open source databases, like MySQL and PostgreSQL, are among the most widely used and popular databases for workloads large and small. WordPress, in fact, powers this blog and uses a MySQL database to store its content.)

Open Source 88

Open Source Software Software Social Media 88

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. Normally this solution requires a full code redesign and could be quite difficult to achieve when it is injected after the initial code architecture definition.

Traffic 127

Traffic Scalability Database Servers 127

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. And if the query processes 100 million rows, that’s definitely not trivial!

Database 93

Database Analytics Storage Processing 93

High Scalability

MAY 4, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Make your job search O (1), not O ( n ). Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JULY 18, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Learn more here. Search like you mean it. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 10, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Learn more here. Search like you mean it. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona

AUGUST 3, 2023

The definition looks strange, but everything should be more clear, providing a real use case for this feature. As an experienced database developer, you should know that these kinds of queries should not exist in any production code. You need to use the INVISIBLE keyword in the column definition. Definitively better.

Best Practices 81

Best Practices Open Source Code Engineering 81

High Scalability

FEBRUARY 1, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. Pinecone is a vector database that makes it easy to add semantic search to your applications. Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100