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. cat /usr/lib/systemd/system/postgresql-14.service. 20150623 (Red Hat 4.8.5-44),

Database 99

Database Servers Open Source Tuning 99

Dynatrace

MAY 15, 2020

By virtue of the incredible volume, quality, scope (we actually go far beyond just application monitoring) and granularity of the data the platform provides, our customers have at their fingertips unparalleled insights about their systems, users, and so much more. On further examination you discover an abnormal system process has initiated.

Government 215

Government DevOps Infrastructure Network 215

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 done server stopped 16.

Database 75

Database Traffic C++ Servers 75

Scalegrid

APRIL 16, 2020

Use Follower Clusters keep two independent database systems (of the same type) in sync so you can analyze, optimize and test app performance for MySQL, PostgreSQL and MongoDB® database. AWS Security Groups and Azure Network Security Groups allow you to lock down access to your servers through advanced virtual firewalls. No problem.

Cloud 242

Cloud Azure AWS Database 242

J. Paul Reed

AUGUST 7, 2023

The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning. Even though that remediation task was pretty minor — tweaking some low-level hardware settings on each physical server and rebooting — and could have been done quickly enough, there was intense debate on whether it should be done.

Engineering 52

Engineering Hardware Games Infrastructure 52

Percona

AUGUST 8, 2023

As such, one of the more common questions I get from my clients is whether or not their system will be able to endure an anticipated load increase. Disk IOPS The amount of disk IOPS your system uses will be somewhat related to how much of your data can fit into memory. When you saturate disk IOPS, your system is going to run slow.

Traffic 88

Traffic Cache Monitoring Database 88

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

Dynatrace

APRIL 21, 2022

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. To optimize your back-end systems, you can use the service flow view within Dynatrace to identify layers of application architecture.

Azure 178

Azure Monitoring Virtualization Metrics 178

HammerDB

JULY 16, 2021

When a system ‘scales’ it is able to deliver higher levels of performance proportional to the system resources available to it. In particular, this means as we add CPU cores and increase the system load, we see higher performance. software running on the same server. and MySQL 8.0.25 and MySQL 5.7.33.

Virtualization 57

Virtualization Performance C++ Database 57

The Netflix TechBlog

SEPTEMBER 8, 2020

Functional Testing Functional testing was the most straightforward of them all: a set of tests alongside each path exercised it against the old and new endpoints. With lots of guidance from other platform and backend teams, we took a 3-pronged approach to ensure correctness for each route migrated.

Latency 233

Latency Cache Java Traffic 233

Particular Software

DECEMBER 9, 2019

I once had a client who started out with a very noncomplex server infrastructure. The hosting provider had given them ownership of an internal IP subnet, and so they started out with two load-balanced public web servers: X.X.X.100 It's easy enough to upgrade load-balanced web servers. It's not so easy with a junk drawer server.

Wireless 52

Wireless DevOps Infrastructure Network 52

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. Operating System: Ubuntu 22.04 Operating System: Ubuntu 22.04

Performance 54

Performance Benchmarking Cache Storage 54

O'Reilly

DECEMBER 12, 2023

This ruling in itself raises many questions: how much creativity is needed, and is that the same kind of creativity that an artist exercises with a paintbrush? It may not be possible if you use a generative model configured as a chat server by itself. But that isn’t the end of the story.

Artificial Intelligence 104

Artificial Intelligence Media Google Processing 104

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! To the developer, a strongly consistent system behaves exactly like a single-threaded system running on a single node, so reasoning about the behaviour of the system is simple 1. VLDB’19.

Programming 59

Programming Processing Database Systems 59

Brendan Gregg

JUNE 30, 2018

sounds like a homework exercise of purely academic value. There may be variance (eg, due to caching or turbo boost) or perturbations (eg, system cron tasks, GC) that skew a single benchmark result. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? This is really asking "what's the limiter?" What's the limiter?"

Benchmarking 54

Benchmarking Latency Cache Network 54

The Morning Paper

JULY 4, 2019

Are you ready to take your system assurance programme to the next level? In all cases we need to be able to carefully monitor the impact on the system, and back out if things start going badly wrong. Netflix’s system is deployed on the public cloud as complex set of interacting microservices.

Latency 77

Latency Engineering Metrics Traffic 77

SQL Performance

JUNE 10, 2020

Unlike the conceptual treatment of the data which is based on a mathematical model and a standard language, and hence is very similar in the various relational database management systems out there, the physical treatment of the data is not based on any standard, and hence tends to be very platform-specific.

C++ 109

C++ Database Servers Code 109

Sutter's Mill

JANUARY 11, 2021

Note that “no side effects on normal execution” is always automatically true for violation handlers even when an assertion system such as proposed in [4] allows arbitrary custom violation handlers to be installed, because those are executed only if we discover that we’re in a corrupted state and so are already outside of normal execution. [5]

C++ 66

C++ Programming Code Testing 66

Brendan Gregg

JUNE 29, 2018

sounds like a homework exercise of purely academic value. There may be variance (eg, due to caching or turbo boost) or perturbations (eg, system cron tasks, GC) that skew a single benchmark result. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? This is really asking "what's the limiter?" What's the limiter?"

Benchmarking 40

Benchmarking Latency Cache Network 40

SQL Performance

JUNE 10, 2020

Unlike the conceptual treatment of the data which is based on a mathematical model and a standard language, and hence is very similar in the various relational database management systems out there, the physical treatment of the data is not based on any standard, and hence tends to be very platform-specific.

C++ 93

C++ Database Servers Code 93

HammerDB

JANUARY 5, 2019

If you are going to restore your production backups onto the new server how can you be sure that this data is safe in transit and completely deleted when the test is complete. If not are you going to “clean” your data so it does not present a security risk?

Benchmarking 40

Benchmarking Database Social Media Scalability 40

O'Reilly Software

MARCH 7, 2018

Build a more scalable, composable, and functional architecture for interconnecting systems and applications. Welcome to a new world of data-driven systems. Today, data needs to be available at all times, serving its users—both humans and computer systems—across all time zones, continuously, in close to real time.

Transportation 72

Transportation Java Programming Architecture 72

SQL Performance

SEPTEMBER 25, 2020

However, the problem still exists in SQL Server 2019. Here’s the only item I’ve found that made it to the new feedback system.). Back in 2006, I complained via multiple Connect items about the lack of visibility of the default values for parameters in the catalog views. CreateProcedureStatement. ProcedureReference. SchemaObjectName.

Code 42

Code C++ Database Servers 42

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. The end result is the first major update to BetterTLS since its first release : a new suite of tests to exercise TLS implementations’ certificate path building.

Servers 165

Servers Testing Best Practices Java 165

The Agile Manager

NOVEMBER 26, 2008

User Interface, middle tier, server side, database, specialists in things like ERP systems) or by component (e.g., This means that lots of development tasks may be flagged as “complete” but they’re complete only by assertion of a developer, not by “fact” of somebody who has exercised the code from end-to-end.

Code 40

Code Servers Engineering Programming 40

O'Reilly

JANUARY 17, 2023

You might say that the outcome of this exercise is a performant predictive model. Second, this exercise in model-building was … rather tedious? If your business relied on a hard-and-fast rule, or a predictable sequence of events, someone was bound to write code to do the work and throw that on a few dozen servers to scale it out.

Tuning 133

Tuning Open Source AWS Software 133

O'Reilly

OCTOBER 19, 2021

The applications must be integrated to the surrounding business systems so ideas can be tested and validated in the real world in a controlled manner. but to reference concrete tooling used today in order to ground what could otherwise be a somewhat abstract exercise. Why did something break? Who did what and when?

DevOps 140

DevOps Software Engineering Infrastructure Open Source 140

All Things Distributed

OCTOBER 2, 2017

With these requirements in mind, and a willingness to question the status quo, a small group of distributed systems experts came together and designed a horizontally scalable distributed database that would scale out for both reads and writes to meet the long-term needs of our business. This was the genesis of the Amazon Dynamo database.

Internet 128

Internet Internet AWS Performance 128

Smashing Magazine

AUGUST 5, 2021

We want to ensure that the input is perfectly correct before the data is even sent to the server. Or perhaps there is no mistake on our end at all, and it’s a system bug that’s absolutely out of our control. And because something is happening, they usually exercise a good amount of patience first.

Design 145

Design Transportation Code Systems 145

All Things Distributed

NOVEMBER 21, 2017

However, the slots must be moved manually on the server side. The system is more robust. With over 200 million users and seven billion language exercises completed each month, the company's mission is to make education free, fun, and accessible to all. We have also made other enhancements along the way.

Games 112

Games Retail Latency Education 112

All Things Distributed

NOVEMBER 15, 2010

Werner Vogels weblog on building scalable and robust distributed systems. Now that our ability to generate higher and higher clock rates has stalled and CPU architectural improvements have shifted focus towards multiple cores, we see that it is becoming harder to efficiently use these computer systems. All Things Distributed.

AWS 136

AWS Latency Programming Architecture 136

The Netflix TechBlog

OCTOBER 21, 2019

As a streaming microservices ecosystem, the Mantis platform provides engineers with capabilities to minimize the costs of observing and operating complex distributed systems without compromising on operational insights. For example, a five-minute outage today is equivalent to a two-hour outage at the time of our last Mantis blog post.

Open Source 148

Open Source Metrics Engineering Processing 148

The Netflix TechBlog

OCTOBER 21, 2019

As a streaming microservices ecosystem, the Mantis platform provides engineers with capabilities to minimize the costs of observing and operating complex distributed systems without compromising on operational insights. For example, a five-minute outage today is equivalent to a two-hour outage at the time of our last Mantis blog post.

Open Source 101

Open Source Metrics Engineering Processing 101

The Netflix TechBlog

OCTOBER 21, 2019

As a streaming microservices ecosystem, the Mantis platform provides engineers with capabilities to minimize the costs of observing and operating complex distributed systems without compromising on operational insights. For example, a five-minute outage today is equivalent to a two-hour outage at the time of our last Mantis blog post.

Open Source 100

Open Source Metrics Engineering Processing 100