Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

Dynatrace

MAY 12, 2022

Remediation tracking now enables you to view the risk assessment for the process groups affected by a vulnerability. The title size of a tile has been moved from the dashboard definition to the dashboard metadata definition and included in the advanced settings UI for dashboards. Application Security. Dashboards. APM-368026).

Tuning 197

Tuning Metrics Cloud Mobile 197

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 Database Architecture Servers 246

Dynatrace

JULY 11, 2023

IBM Power servers enable customers to respond faster to business demands, protect data from core to cloud, and streamline insights and automation. It simplifies the process of setting up and maintaining Dynatrace observability by encapsulating the necessary configuration and operational logic into a single entity.

Architecture 173

Architecture Availability Infrastructure Metrics 173

Dynatrace

FEBRUARY 14, 2022

Multiple Prometheus servers might be required, creating significant maintenance efforts. Alternatively, if you’re already using a Prometheus Server to gather data from your distributed systems, you can now seamlessly make this data work for you in Dynatrace as well—use your Prometheus server as the endpoint for scraping metrics.

Technology 222

Technology Technology Metrics Infrastructure 222

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 114

Open Source Database Servers Scalability 114

Percona

JULY 19, 2023

In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications and reducing the risk of human error in the deployment process.

Servers 76

Servers Best Practices DevOps Open Source 76

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

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. When I’m talking about any mechanism in SQL Server, I find there’s a chicken-and-egg problem where I need to use a word or phrase before I’ve explained it.

Servers 54

Servers Database Architecture Performance 54

Percona Community

NOVEMBER 29, 2023

After completing the deployment process, I noticed that the status of the Custom Resource Definition for Percona Server for MongoDB was still displaying as ‘initializing’ and two of our Pods remained in a Pending state. Last week, I embarked on the task of deploying our Percona Operator for MongoDB in Kubernetes.

Servers 77

Servers Processing 77

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. So, given a table_id, how do you get the table schema/definition? For that, we have to use undo logs.

Cache 83

Cache Benchmarking Servers Design 83

The Netflix TechBlog

JULY 30, 2019

Many of the Netflix Content and Studio Engineering services rely on Conductor for efficient processing of their business flows. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. The Netflix Media Database (NMDB) is one such example.

Lambda 189

Lambda Media Open Source Metrics 189

CSS Wizardry

DECEMBER 9, 2023

Connection overhead isn’t huge , but too many preconnect s that either a) aren’t critical, or b) don’t get used at all, is definitely wasteful. Further, opening and persisting connections has a CPU overhead on both the client and the server.

Speed 234

Speed Network Analytics Availability 234

Alex Podelko

AUGUST 18, 2019

While there are still quite a lot of cases where it is still applicable, it needs to evolve into more sophisticated processes tightly integrated with development and other parts of performance engineering. Yes, the tools and process should be easier for non-experts to incorporate some performance testing into continuous development process.

Performance Testing 243

Performance Testing Testing Performance Testing Tools 243

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? Your SAP instance is slow, and you don’t know which transactions or users are affected?

Metrics 173

Metrics Monitoring Network Technology 173

Dynatrace

NOVEMBER 14, 2023

These small wins, such as implementing a blameless root cause analysis process, can take many forms and don’t necessarily involve numerical metrics. This is made possible through generative AI’s natural language processing capabilities. For organizations building business-centric SLOs, Aguiar had some recommendations. “If

Best Practices 197

Best Practices Engineering DevOps Software Engineering 197

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. For the HTTP request, we add the request headers we sent, as well as certain details from the response, such as the status code, the length of the response, and server information.

Metrics 185

Metrics Open Source Traffic Cache 185

Dynatrace

FEBRUARY 16, 2023

There are many definitions of environmental sustainability, most of which converge on a common theme: collectively and individually, we have a responsibility to act to protect global ecosystems and support health and wellbeing, now and in the future. Average cloud server idle time exceeds 70%.

Energy 188

Energy Airlines Analytics Transportation 188

Percona

JULY 25, 2023

You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. STDOUT Datasink This diagram displays the process of streaming a backup to object storage utilizing the current STDOUT datasink: XtraBackup spawns multiple copy threads. FIFO ( 8 pipes) – Utilized 1.15

Storage 76

Storage Speed Open Source Servers 76

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

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 But changing this is possible only at the server startup.

Database 99

Database Servers Open Source Tuning 99

Dynatrace

DECEMBER 15, 2022

Typically, these are streamed to a central syslog server. One option is to install OneAgent on that syslog server, which automatically discovers, instruments and sends the log data to the Dynatrace platform. Syslog is a popular standard for transporting and Ingesting log messages. Ingest AWS Fargate logs with Fluent Bit.

Strategy 185

Strategy AWS Open Source Transportation 185

Dynatrace

AUGUST 16, 2019

As microservices and automation continue to drive API usage, most organizations have either already introduced, or plan to introduce, an API testing process. By definition RESTful APIs should be stateless, meaning that each request should be individually validated for authentication/authorization by the receiving server.

Monitoring 157

Monitoring Tuning Google Cloud 157

Percona

DECEMBER 18, 2023

I’ve chosen to minimize the pgloader ETL process by opting to alter the source, MySQL, database’s columnar, and table definitions instead. Document a synthesis of the development process in order to perform the database migration currently in production. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 118

Open Source Database Architecture Design 118

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. Kubernetes/OpenShift workload/pod details.

Azure 221

Azure Metrics AWS Monitoring 221

Randon ASCII

AUGUST 30, 2020

Sometimes tracking down a bug is as simple as paying attention to server dashboards, spending a few minutes in a profiler, or looking at compiler warnings. Server CPU Surprise. A few years ago I spent a few weeks doing some memory investigations on live game servers. The first server process that I profiled was… odd.

Games 142

Games Servers Code Monitoring 142

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. Log entries describe events, such as starting a process, handling an error, or simply completing some part of a workload.

Monitoring 226

Monitoring Metrics DevOps Scalability 226

Brendan Gregg

APRIL 8, 2022

At Netflix, 10% of CPU time somewhere unexpected can be a large costly issue across thousands of server instances. But this process had been up and running for hours, and shouldn't still be doing so much page fault growth of its RSS. Sometimes processes page fault a lot because they call mmap()/munmap() to add/remove memory.

Performance 100

Performance Virtualization Code Servers 100

The Netflix TechBlog

OCTOBER 7, 2021

Hence, it became important to supplement our release decisions with strong evidence received from the field during the update process. In contrast, a server application runs on servers which are typically identical and a routing abstraction can serve sampled traffic to new versions.

Metrics 197

Metrics Mobile Testing Strategy 197

Smashing Magazine

AUGUST 3, 2023

Core Web Vital metrics definitions. However, achieving a good LCP score is often a multi-faceted process that involves optimizing several stages of loading and rendering. 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.

Performance 74

Performance Cache Traffic Metrics 74

SQL Performance

APRIL 14, 2021

Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing. Here’s the function’s definition: -- Helper dummy table. DROP TABLE IF EXISTS dbo. BatchMe ; GO.

C++ 112

C++ Servers Testing Code 112

SQL Performance

SEPTEMBER 8, 2021

To understand the circumstances where you would want to use the CHECK OPTION as part of a view’s definition, we’ll first examine what can happen when you don’t use it. For years I used to think of the CHECK OPTION in a view as serving the same function as a CHECK constraint in a base table’s definition. CHECK OPTION. FastOrders.

Servers 130

Servers Code Engineering Database 130

Smashing Magazine

JULY 20, 2022

There doesn’t seem to be an indication of limitations on file size or the number of files, but it is a slow process if you try to do a bulk conversion. The compression, in this case, seems to be on the server side, so you’ll get much faster results. compresses images on the server. You’ll definitely want to give SVGOMG a try!

Media 134

Media Programming Mobile Website 134

Scalegrid

JANUARY 20, 2020

And since the entire import is performed using storage snapshots, rather than a logical dump, the process is nearly instantaneous. If your application passes on the test dataset, it is definitely fit to deploy in production! With your development and QA clusters set to follow the production cluster, you can rest easy.

Analytics 185

Analytics Storage Database Systems 185

Percona

OCTOBER 17, 2023

The dynamic allocation might have flaws, but it’s definitely a good addition. That’s very welcome after upgrade/downgrade processes when metadata is touched after FCV change. In previous releases, the downgrade process was relatively simple: Have a valid backup. Remove backward-incompatible features.

Metrics 98

Metrics C++ Storage Database 98

SQL Performance

FEBRUARY 10, 2021

I’ll do my testing in tempdb, enabling IO and TIME statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS IO , TIME ON ; The fastest solution from last month applies a join with a dummy table that has a columnstore index to get batch processing. With the above suggested function, you can create it as is with older versions of SQL Server.

C++ 124

C++ Servers Testing Code 124

SQL Performance

JULY 14, 2021

When you create a view, SQL Server records metadata information in a number of catalog objects. It records some general information, which you can query via sys.views, the view definition which you can query via sys.sql_modules, column information which you can query via sys.columns, and more information is available through other objects.

Code 117

Code Database Servers Availability 117