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. This file is present in /proc/$pid/oom_score_adj.

Servers 110

Servers Best Practices Database Open Source 110

Dynatrace

JANUARY 11, 2023

Cloud monitoring is a set of solutions and practices used to observe, measure, analyze, and manage the health of cloud-based IT infrastructure. Continuous cloud monitoring with automation provides clear visibility into the performance and availability of websites, files, applications, servers, and network resources. Website monitoring.

Cloud 227

Cloud Monitoring Best Practices Infrastructure 227

Dynatrace

FEBRUARY 27, 2024

Organizations can also drill deeper to discover what’s happening on the server side. “Dynatrace PurePath can trace hop to hop what went on in a user interaction to give a highly sophisticated root-cause analysis,” Chandler noted. The unified observability and security platform presents data in intuitive, user-friendly ways.

Best Practices 241

Best Practices Metrics AWS Innovation 241

SQL Performance

MAY 8, 2019

This article is the second in a series about T-SQL bugs, pitfalls and best practices. Since the reference to custid in the inner query is unqualified, SQL Server has to resolve which table the column is coming from. As for best practices that can help you avoid such bugs, there are two main ones. custid FROM dbo.

Best Practices 68

Best Practices C++ Code Servers 68

SQL Performance

SEPTEMBER 12, 2019

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. Here I'll describe the trap, the potential bug, and a best practice that prevents the bug. In the meanwhile, there's a best practice that can help you avoid the bug. This month I cover pivoting and unpivoting.

Best Practices 103

Best Practices C++ Code Design 103

SQL Performance

JUNE 14, 2019

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. All of these bugs are related to T-SQL querying fundamentals, and are easy to avoid if you follow simple best-practices.

Best Practices 93

Best Practices C++ Database Processing 93

Dynatrace

APRIL 25, 2023

However, serverless applications have unique characteristics that make observability more difficult than in traditional server-based applications. Serverless applications have several benefits over server-based applications: Eliminate the need to provision, manage and maintain servers or containers.

Serverless 213

Serverless Lambda Azure AWS 213

Scalegrid

JANUARY 12, 2024

While managing cloud workloads offers numerous benefits, it also presents several challenges such as security risks, compliance issues, and resource optimization, which can be addressed effectively with tools like ScaleGrid, offering features like encryption, disaster recovery, and real-time resource optimization for diverse databases.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

DECEMBER 28, 2023

into manageable portions to avoid potential discrepancies related to the enormous amounts of data present. The reason is that every time the query is executed, the full result set is built up, then the server has to walk from the beginning of the collection to the specified offset. skip(pagesize*(n-1)).limit(pagesize)

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Scalegrid

JANUARY 9, 2024

This presents enterprises with a wide range of options that cater specifically to their needs within this new framework created by multiple trusted cloud service providers. Governance and compliance are also crucial factors in ensuring enterprise cloud security as they enforce regulatory requirements and best practices within organizations.

Strategy 130

Strategy Cloud Best Practices Government 130

Dynatrace

DECEMBER 16, 2020

Dynatrace has implemented several specific security controls and uses industry best practices to protect Dynatrace software components like OneAgent, ActiveGate, and Dynatrace Cluster installation packages from malicious manipulation by attackers on the way to our customers’ infrastructure. The diagram below provides an overview.

Software 239

Software Software Development AWS 239

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Connected_slaves provides information about replication status while Used_memory tracks utilized amount of server’s total capacity. You can pick a smart selection of relevant metrics from these.

Metrics 130

Metrics Monitoring Latency Cache 130

Scalegrid

NOVEMBER 23, 2023

Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security. It represents either an IP address or domain name of the server, where one can find those databases located. Do check your configuration accordingly, however.

Database 130

Database Servers Storage Network 130

Smashing Magazine

NOVEMBER 8, 2021

From connecting back-office operations to front-of-the-house A/B testing and dynamic personalization for each customer, the shared foundation is fast server-side rendering powered by fast storefront data access. Hydrogen fuels dynamic commerce by uniting React Server Components, streaming server-side rendering, and smart caching controls.

Cache 136

Cache Best Practices Strategy Servers 136

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. For this reason sysbench presents a vastly more simplified workload than HammerDB. . System Setup: CPU, Memory and I/O Configuration. perf special.

Best Practices 40

Best Practices Scalability Performance C++ 40

The Netflix TechBlog

OCTOBER 14, 2021

The “USERTrust RSA Certificate Authority” was relatively new and not directly trusted by many clients and so most servers would send certificates 1, 2, and 3 to clients. In the context of TLS, that collection of certificates is sent from the server to the client as part of the TLS handshake. 500 Distinguished Name and public key).

Servers 165

Servers Testing Best Practices Java 165

Tim Kadlec

NOVEMBER 2, 2020

Users were presented with a simple “either-or” poll. Instead, they adjusted the design, switching from spinners to a skeleton screen that incrementally filled in as content arrived back from the server. People stopped complaining about wait times, and a new perceived performance “best practice” was born.

Best Practices 145

Best Practices Network Mobile Speed 145

Percona

JULY 19, 2023

Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ cd $HOME $ wget [link] $ tar -xvzf percona-server-8.0.32-24.tar.gz mkdir ~/percona-server-8.0.32-24/plugin/ulid/ 24/plugin/ulid/ $ cd ~/percona-server-8.0.32-24/plugin/ulid/

C++ 80

C++ Servers Benchmarking Best Practices 80

Dynatrace

JUNE 9, 2021

A web application is any application that runs on a web server and is accessed by a user through a web browser. Before one can design an optimal security approach, it helps to understand what kinds of vulnerabilities are commonly present in web applications. Most common vulnerabilities commonly present in web applications.

Open Source 183

Open Source Entertainment Tuning Internet 183

Dynatrace

OCTOBER 5, 2020

The same default behavior is also true for Dynatrace when installing the OneAgent on your servers that host your ASP.NET services. Once you have Dynatrace capturing data from your apps and services simple follow these best practices shared by our friends from triscon so you can get even more out of Dynatrace.

Performance 152

Performance Best Practices Architecture Monitoring 152

Percona

DECEMBER 6, 2023

In reality, relying solely on a replica under the primary server is not sufficient for a robust disaster recovery plan. Additional read Walter’s ultimate guide of MySQL Backup and Recovery Best Practices. Q: What is one of your favourite (and common) security worst practices?

Strategy 77

Strategy Database Best Practices Tuning 77

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 106

Availability Database Open Source Hardware 106

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. This feature will be removed in a future version of Microsoft SQL Server.

Servers 64

Servers Azure Best Practices Monitoring 64

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. When the primary server fails, a standby server takes over as the new primary. This ensures continuous business operations.

Availability 83

Availability Open Source Architecture Database 83

ACM Sigarch

JULY 17, 2023

One such challenge has been the emergence of marginal defect-driven faults that are difficult to address solely using best practices in manufacturing test and screening. The differences in the environment and conditions between Automated Test Equipment (ATE) and regular server platforms also provide challenges.

Energy 52

Energy Hardware Best Practices Architecture 52

Dynatrace

AUGUST 30, 2019

Impacting Server-Side Requests: Dynatrace allows you to drill into your server-side requests to understand why your business logic is executing slow or fails. Dynatrace provides full page load waterfalls with automated optimization findings for all captured user sessions, and also allows you to drill into server-side PurePaths.

Cache 201

Cache Architecture Database Government 201

Dynatrace

DECEMBER 16, 2019

A taste of what’s to come at Perform 2020’s “Release Better Software Faster” track – we highlighted what you can expect to learn about best practices for sessions 1 – 4 at Perform 2020. All seven sessions and a Mainstage presentation will focus on helping organizations move successfully forward on this journey.

DevOps 103

DevOps Software Software Best Practices 103

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. This means that, if the Cache-Control: max-age=60 header is still present, the cached file’s 60 seconds starts again. public and private. 120 seconds overall cache time for one file.

Cache 264

Cache Latency Strategy Servers 264

Percona

AUGUST 30, 2023

Failover testing: If you have a high availability setup or a secondary data center, test to ensure the failover process switches over to the backup database server. SQL Server Management Studio: This software includes backup and recovery tools for use with Microsoft SQL Server. This includes both data and log backups.

Database 86

Database Hardware Open Source Strategy 86

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions. Optimization of Traditional Time-Based Grouping.

Servers 144

Servers Code Best Practices Database 144

Scalegrid

DECEMBER 16, 2019

If you’re running MongoDB on DigitalOcean in production, it’s best practices to deploy using a replica set to ensure high availability and data redundancy for your clusters. Sharding is ideal for very large data sets or high throughput deployments that require more capacity that you can get with a single server.

Azure 187

Azure AWS Latency Database 187

MachMetrics

APRIL 3, 2020

Author Steve Souders writes about the best practices that he gained as the Chief Performance Yahoo!, Souders presents his 14 rules throughout the course of the book while discussing the importance of front-end performance. Even Faster Web Sites: Performance Best Practices For Web Developers.

Speed 85

Speed Performance Best Practices Website 85

The Netflix TechBlog

MARCH 5, 2019

This operational component places some cognitive load on our engineers, requiring them to develop deep understanding of telemetry and alerting systems, capacity provisioning process, security and reliability best practices, and a vast amount of informal knowledge about the cloud infrastructure.

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40

O'Reilly

OCTOBER 19, 2021

As with many burgeoning fields and disciplines, we don’t yet have a shared canonical infrastructure stack or best practices for developing and deploying data-intensive applications. Can’t we just fold it into existing DevOps best practices? How can you start applying the stack in practice today?

DevOps 137

DevOps Software Engineering Infrastructure Open Source 137

Percona

MAY 15, 2023

In short, any data that is written must be consistent with the data present. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. To achieve that, the data needs to be checked with the existing through defined relations and constraints.

Traffic 123

Traffic Scalability Database Servers 123

The Netflix TechBlog

FEBRUARY 25, 2021

Graph i QL: Auto-generated test GUI for the Star Wars API Our experience has led to an architecture with a number of best-practices for teams interested in GQLMS as a platform for rapid development. Documentation can even be embedded in the database comments such that it displays in the GraphQL schema generated by Graphile.

Database 201

Database Entertainment Infrastructure Architecture 201