Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. Load balancers can detect when a component is not responding and put traffic redirection in motion.

Availability 109

Availability Database Open Source Hardware 109

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 86

Programming Servers Database Hardware 86

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

MAY 2, 2023

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. Keep in mind that setting the buffer pool size too high may result in other processes on your server competing for memory, which can impact performance. Q: I have a MySQL server, and my application is writing at a rate of 100 MB/hour in my redo logs.

Social Media 122

Social Media Database Servers Cache 122

Dynatrace

AUGUST 10, 2019

Windows 2016 Server (or a supported Linux distribution ). Compliance with hardware requirements. See private locations documentation for further details and requirements. What you need to start synthetic monitoring with Windows ActiveGates. A synthetic-enabled environment ActiveGate: ActiveGate version 1.173+.

Monitoring 103

Monitoring Hardware Tuning Mobile 103

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40

Servers Hardware Database Availability 40

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Configuration of the CPU metrics can be changed in the dashboard.

Cloud 120

Cloud Serverless AWS Storage 120

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 85

Availability Open Source Architecture Database 85

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

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. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Testsigma

APRIL 4, 2022

Mocking Component Behavior Useful in IoT & Embedded Software Testing Can also reduce (or eliminate) actual hardware/component need Test Reporting Generating summary report/email. Here are some examples: Test Environment Setup: Installing libraries using scripts Setting configuration variables, etc. Linking screenshots/logs to the reports.

Testing 95

Testing Open Source IoT Programming 95

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster.

Database 81

Database Servers Storage Strategy 81

Brendan Gregg

MARCH 16, 2024

The x86-64 ABI documentation shows how a CPU register, %rbp, can be used as a "base pointer" to a stack frame, aka the "frame pointer." It was also a virtual machine that lacked low-level hardware profiling capabilities, so I wasn't able to do cycle analysis to confirm that the 10% was entirely frame pointer-based.

Java 145

Java Cache Google Hardware 145

Randon ASCII

OCTOBER 4, 2020

The behavior of the Windows scheduler changed significantly in Windows 10 2004, in a way that will break a few applications, and there appears to have been no announcement, and the documentation has not been updated. I think the new behavior is an improvement, but it’s weird, and it deserves to be documented.

Programming 145

Programming Games Hardware Operating System 145

ACM Sigarch

JULY 17, 2023

An example of a specification is the correct operation of the hardware of a microprocessor. An SDC is the worst possible outcome of a fault, as it can have an arbitrary impact on the correctness of software running on the hardware. Background A fault is a condition that causes the inability to meet a specification. core lock-stepping).

Energy 52

Energy Hardware Best Practices Architecture 52

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

Percona

NOVEMBER 1, 2023

MySQL backups play a pivotal role in safeguarding the integrity of your data, providing defense against various unforeseen calamities, hardware malfunctions, data loss, corruption, and inadvertent deletions. on, you can use mysqlbinlog to stream binary logs from a remote server. 30 days of binlog backups locally on the backup server.

Best Practices 79

Best Practices Storage Strategy Database 79

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52

HammerDB

OCTOBER 23, 2023

Note that for all tests, we used the local loopback address and port to provide the lowest possible network latency between client and server and also so we don’t have any concerns about bandwidth limitations. the amount of data from the server to the client to achieve the same result. On MySQL, we saw a 1.5X client (i.e.

Benchmarking 62

Benchmarking Database Network C++ 62

J. Paul Reed

AUGUST 7, 2023

The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning. See, this data center had originally been provisioned over a decade ago, and back then, the provisioning practices weren’t as automated (or even documented) as they are now.

Engineering 52

Engineering Hardware Games Infrastructure 52

Smashing Magazine

JUNE 18, 2020

That’s because they are meant for user preferences, as mentioned here in the case of iOS and here in the Android documentation when talking about the Security library which is designed to provide wrappers to the SharedPreferences specifically to encrypt the data before storing it. Secure Storage On Mobile. No, not at all. Solving Both.

Storage 93

Storage Mobile Website Java 93

SQL Performance

JULY 3, 2019

A recent consulting engagement was focused on blocking issues inside of SQL Server that were causing delays in processing user requests from the application. Depending on which DMV you look at for SQL Server, a session can have a few different statuses. So, we had to dig in further. Understanding Session Status.

Servers 64

Servers Hardware Code Virtualization 64

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.

Servers 40

Servers Media Engineering Virtualization 40

Percona

JANUARY 19, 2023

You can refer to the documentation for further details. Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers.

Open Source 89

Open Source Storage Database Big Data 89

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

CSS - Tricks

AUGUST 18, 2020

Even if you render components on the server and hydrate them on the client, it still churns because component hydration is computationally expensive. When even a bit of React can be a problem on devices slow and fast alike, using it is an intentional choice that effectively excludes people with low-end hardware. I think JSX is great.

Performance 101

Performance Mobile Servers Code 101

HammerDB

NOVEMBER 22, 2021

include/server -I/opt/postgresql-14.1/include/internal adds the functionality to view the PostgreSQL active session history for benchmark workloads, enabling the user to find and diagnose bottlenecks in hardware and software configurations in a PostgreSQL environment. git clone [link] cd pgsentinel/src opt/postgresql-14.1/pgsentinel/src$

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

APRIL 19, 2023

There are several ways to find out this information with the easiest way being by referring to the documentation. For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement. and 8.0.32 HammerDB 4.5 Concurrency at 80 VU’s 1.00

Performance 54

Performance Benchmarking Cache Storage 54

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. Documentation : Always be documenting! ” This can lead to uneven resource utilization and slower performance for certain partitions.

Strategy 40

Strategy Storage Database Best Practices 40

All Things Distributed

JUNE 28, 2017

The body and hardware still reflect HARTING's standard of perfection. It refrains from seeking "culprits" Instead it documents learning experiences and derives actions that ultimately improve the availability of our systems. The web servers reported timeouts. Why were the web servers overloaded?

Innovation 113

Innovation Website Servers Technology 113

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). There's a lot about Linux containers that isn't well documented yet, especially since it's a moving target. amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. Both are well documented and standardized, but most of the discussion occurs around attributional accounting. The first thing to understand is that doing things consumes time and energy and has a carbon footprint of its own.

Energy 52

Energy Cloud Traffic Transportation 52

HammerDB

FEBRUARY 25, 2021

When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels. It used to provide an insight into how quickly the server outputs any data. Large preview ).

Performance 145

Performance Cache Media Metrics 145

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications. Instead all of the client servers are connecting to the TP monitor.

C++ 40

C++ Benchmarking Virtualization Open Source 40