Scalegrid

APRIL 16, 2020

AWS Security Groups and Azure Network Security Groups allow you to lock down access to your servers through advanced virtual firewalls. 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. Security Groups.

Cloud 242

Cloud Azure AWS Database 242

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. Serverless – Deploy OneAgent via ARM templates or Site Extensions for Azure App Server or Azure Functions to get code level insights.

Azure 246

Azure Monitoring Virtualization Metrics 246

The Netflix TechBlog

SEPTEMBER 10, 2024

By Karthik Yagna , Baskar Odayarkoil , and Alex Ellis Pushy is Netflix’s WebSocket server that maintains persistent WebSocket connections with devices running the Netflix application. Where aws ends and the internet begins is an exercise left to the reader. Sample system diagram for an Alexa voice command.

Latency 234

Latency Cache Tuning Efficiency 234

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 172

Servers Testing Best Practices Java 172

Percona

JULY 3, 2023

or higher for a client, metrics will accumulate on the client automatically up to 1GB before any gaps in metrics appear once complete. **There’s a known issue that pmm-client doesn’t pick up the DNS change without restarting the client, but vmagent (what actually sends the metrics to the server) will.as

Open Source 98

Open Source Metrics Monitoring Servers 98

All Things Distributed

OCTOBER 2, 2017

percent availability in the event of a server, a rack of servers, or an Availability Zone failure. DynamoDB automatically re-distributes your data to healthy servers to ensure there are always multiple replicas of your data without you needing to intervene. Auto Scaling is on by default for all new tables and indexes.

Internet 111

Internet Internet AWS Performance 111

Percona

OCTOBER 31, 2023

The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.” ” When we looked at adoption, we were surprised to see almost none; the little we did see was just us.

Open Source 111

Open Source Database Operating System Programming 111

SQL Performance

APRIL 14, 2021

Scan count 2, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 8, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0. Table 'NullBits102400'. Table 'NullBits102400'. Paul’s solution.

Servers 112

Servers C++ Testing Code 112

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 120

Database Servers Open Source Tuning 120

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 103

Database Traffic C++ Servers 103

Percona

DECEMBER 29, 2022

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. In this blog post, I will show you a particular example I faced when working with an upgrade exercise using pg_upgrade. If all is good, perform the upgrade removing the –check flag. Example case.

C++ 84

C++ Open Source Database Programming 84

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!

C++ 111

C++ Database Servers Code 111

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 145

Tuning Open Source Software Software 145

SQL Server According to Bob

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login. – sqlclr.

Servers 40

Servers Network Database Systems 40

SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers 40

Servers Games Azure Testing 40

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

SQL Performance

JANUARY 12, 2022

Despite the poor performance, working on the solution is an interesting exercise. You can enable its consideration without the requirements of batch mode on rowstore , e.g., using SQL Server 2019 Enterprise or later, by creating the following dummy columnstore index: CREATE NONCLUSTERED COLUMNSTORE INDEX idx_cs ON dbo.

Code 116

Code Servers Performance Azure 116

O'Reilly

OCTOBER 19, 2021

but to reference concrete tooling used today in order to ground what could otherwise be a somewhat abstract exercise. There are countless systems that can perform this task for small DAGs on a single server. The intention behind the examples is not to be comprehensive (perhaps a fool’s errand, anyway!),

DevOps 145

DevOps Software Engineering Open Source Infrastructure 145

O'Reilly

JUNE 13, 2023

I didn’t get as many citations in return, possibly because we don’t have preprint servers like ArXiv, and have done little to protest journals’ proprietary lock on scholarship. An essay isn’t an exercise in providing N*1000 words; it’s the outcome of a thought process that involves engaging with the subject matter.

Google 120

Google Programming Database Testing 120

All Things Distributed

NOVEMBER 15, 2010

Configuring kernel execution is not a trivial exercise and requires GPU device specific knowledge. No Server Required - Jekyll & Amazon S3. There are a number of techniques that every programmer has grown up with, such as branching, that are not available, or should be avoided on GPUs if one wants to truly exploit its power.

AWS 125

AWS Programming Latency Architecture 125

MachMetrics

JANUARY 4, 2019

This PageSpeed service offers two types of package for web servers: Apache module and Nginx module. After integrating PageSpeed Module components on the server side, the architecture and files of your website will automatically rewrite for optimal performance. Have you used the Google PageSpeed Module on your server?

Speed 60

Speed Website Open Source Google 60

All Things Distributed

NOVEMBER 21, 2017

However, the slots must be moved manually on the server side. 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.

Games 96

Games Retail Latency Education 96

SQL Performance

OCTOBER 20, 2022

When SQL Server reads data under locking read committed isolation (the default for non-cloud offerings) and chooses row-level locking granularity, it normally only locks one row at a time. SQL Server solves this problem using lock classes. SQL Server needs to hold locks in this case to ensure the by-reference LOB pointers remain valid.

Testing 91

Testing Servers Cache Engineering 91

SQL Performance

DECEMBER 27, 2019

This is a copy of the data, on an idle server (8 cores, 64GB RAM), with plenty of disk space (well over 6TB). mdf' ) TO FILEGROUP FG_CCI ; --. The post Fun with (columnstore) compression on a very large table – part 1 appeared first on SQLPerformance.com.

Database 70

Database Storage Hardware Efficiency 70

CSS - Tricks

APRIL 1, 2021

With all of this in mind, I thought improving the speed of my own version of a slow site would be a fun exercise. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). The traditional path of delivering content is to hit the server, request data, and wait for it to return.

Cache 94

Cache Social Media Media Website 94

Percona

AUGUST 8, 2023

Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. Conclusion Capacity planning is not something you do once a year or more as part of a general exercise.

Traffic 98

Traffic Cache Monitoring Database 98

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 132

Artificial Intelligence Media Google Processing 132

HammerDB

JULY 16, 2021

software running on the same server. This is the same server, same OS and same HammerDB client, the only difference is in the server software. on this server. When we graph the result, we now get a much better picture of the full capabilities of the MySQL 5.7 Now we can see that MySQL 8.0 at 1.51X over MySQL 5.7.33.

Virtualization 58

Virtualization Performance C++ Database 58

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name ) + N'.' + QUOTENAME ( o. name ) + N' '.

C++ 58

C++ Database Servers Performance 58

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. However, nothing easily allows SQL Server to determine what percentage of the leaf level for each index of a table is already in memory.

Efficiency 54

Efficiency Servers Database Cache 54

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

The Agile Manager

SEPTEMBER 30, 2012

Development teams have a lot of specialists, both role (business analyst, developer, user experience designer, quality assurance analyst) and technical (mobile client developer, server-side Java developer, web client developer, etc.) We can invest in people to become mobile solution developers who can write client and server code.

Mobile 49

Mobile Code Java Software 49

The Morning Paper

JULY 4, 2019

They use a combination of timeouts, retries, and fallbacks to try to mitigate the effects of these failures, but these don’t get exercised as often as the happy path, so how can we be confident they’ll work as intended when called upon? RPCs at Netflix are wrapped as Hystrix commands.

Latency 77

Latency Engineering Metrics Traffic 77

The Morning Paper

AUGUST 27, 2019

In a distributed setting with weak consistency, an object is replicated across a set of servers. Unfortunately, to date, the task of identifying whether or not an object is actually invariant confluent has remained an exercise in human proof generation… Hand-written proofs of this sort are unreasonable to expect from programmers.

Programming 59

Programming Processing Database Systems 59

Brendan Gregg

JUNE 30, 2018

sounds like a homework exercise of purely academic value. My colleague began analysis using a packet sniffer on the target, to see if packets were really taking that long to be returned by the server. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? This is really asking "what's the limiter?" He saw nothing.

Benchmarking 47

Benchmarking Latency Cache Network 47

Sutter's Mill

JANUARY 11, 2021

For example, you might make different decisions about enabling assertions if your “run time” is an end user’s machine, or a server farm, or a honeypot. Here they are: Of course this can be even more nuanced. Notes With thanks to Wikipedia for the first two references. [1] Goldstine and J. von Neumann. 2] Alan Turing.

C++ 81

C++ Programming Code Testing 81

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. In this case, we had a table with a couple million rows.

Cache 59

Cache Tuning Database Performance 59