Percona

JUNE 30, 2023

In addition to that: Run up to four pgBackrest repositories Bootstrap the cluster from the existing backup through Custom Resource Azure Blob Storage support Operations Deploying complex topologies in Kubernetes is not possible without affinity and anti-affinity rules. Please refer to our documentation. In version 1.x,

Availability 96

Availability Open Source Azure Hardware 96

Percona

FEBRUARY 24, 2023

Figure 1: PMM Home Dashboard From the Amazon Web Services (AWS) documentation , an instance is considered over-provisioned when at least one specification of your instance, such as CPU, memory, or network, can be sized down while still meeting the performance requirements of your workload and no specification is under-provisioned.

Cloud 121

Cloud Serverless AWS Storage 121

Smashing Magazine

JUNE 18, 2020

More specifically, we’re going to talk about storage and UI differences, which are the ones that most often cause confusion to developers when writing Flutter code that they want to be cross-platform. Example 1: Storage. Secure Storage On Mobile. The situation when it comes to mobile apps is completely different.

Storage 93

Storage Mobile Website Java 93

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. Encryption Backups have sensitive data, so it’s highly recommended to encrypt, especially for offsite storage.

Best Practices 80

Best Practices Storage Strategy Database 80

HammerDB

APRIL 19, 2023

As database performance is heavily influenced by the performance of storage, network, memory, and processors, we must understand the upper limit of these key components. There are several ways to find out this information with the easiest way being by referring to the documentation. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

AUGUST 18, 2023

The original motivation for FB was due to different hardware generations, especially between regions/data centers. And I agree that in the modern age of cloud and huge flash storage, the vast majority of companies will never need to consider doing this in prod, but there is always a chance of its need. AFAIK Facebook does this.

Programming 86

Programming Servers Database Hardware 86

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. If a primary server fails, a backup server can take over and continue to serve requests.

Availability 110

Availability Database Open Source Hardware 110

Testsigma

MAY 3, 2021

From operating systems to versions to hardware specs, mobile devices stand unique even after being billions in number. But testing this is essential too because data communication over the network cannot be eliminated by putting all the files into the device storage. Collaboration with Multiple Teams.

Mobile 77

Mobile Testing Operating System Hardware 77

Percona

JULY 7, 2023

Also, in general terms, a high availability PostgreSQL solution must cover four key areas: Infrastructure: This is the physical or virtual hardware database systems rely on to run. Can you afford the necessary hardware, software, and operational costs of maintaining a PostgreSQL HA solution? there cannot be high availability.

Availability 85

Availability Open Source Architecture Database 85

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. To make this process work more efficiently and ensure a smooth failover, it is important to have the same hardware configuration on all the nodes of the replica set. MongoDB is popular with developers as it is easy to get started with.

Database 81

Database Servers Storage Strategy 81

Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance. You want to ensure that table lookups go to the correct partition or group of partitions.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JANUARY 19, 2023

You can refer to the documentation for further details. It can help us to save costs on storage and backup times. While MySQL can handle large data sets, it is always recommended to keep only the used data in the databases, as this will make data access more efficient, and also will help to save costs on storage and backups.

Open Source 90

Open Source Storage Database Big Data 90

Percona

APRIL 17, 2023

Since MongoDB usually works with a replica set, it is possible to increase this parameter to get better performance: # edit /etc/mongod.conf storage: journal: enabled: true commitIntervalMs: 300 WiredTiger cache For dedicated servers, it is possible to increase the WiredTiger(WT) cache. By default, it uses 50% of the memory + 1 GB.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Description.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document.

Servers 40

Servers Cache Media Hardware 40

Percona

DECEMBER 14, 2022

The CITUS columnar extension feature set includes: Highly compressed tables: Reduces storage requirements. The complete CITUS feature set which, except for the Columnar storage component, is not covered in this blog, includes: Distributed tables. Columnar storage. There’s actually more documented. References tables.

Database 93

Database Analytics Storage Processing 93

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

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

Tim Kadlec

JANUARY 9, 2019

This point is extremely well documented by now, but warrants repeating. The YouTube feather story —where they improved performance and saw an influx of new users from areas with poor connectivity who could, for the first time, actually use the site—is well documented by now. Hardware gets better, sure. Performance as exclusion.

Performance 111

Performance Energy Internet Internet 111

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. Event driven scaling (asynchronous clients with keying and thinking time).

C++ 40

C++ Benchmarking Virtualization Open Source 40

The Morning Paper

MARCH 3, 2020

It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. This paper is a real joy to read. In practice, however, achieving high availability is challenging.

Database 106

Database AWS Network Design 106

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.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware. Some commenters appear to confuse unlike hardware for differences in software. Where Chrome Has Lagged.

Media 145

Media Games Education Engineering 145

Alex Russell

OCTOBER 22, 2017

This isn’t true (more on that in a follow-up post), and sites which are built this way implicitly require more script in each document (e.g., The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. for router components). Parsing CSS.

Performance 68

Performance Benchmarking Network Mobile 68

All Things Distributed

APRIL 5, 2012

However, the shining moment occurred just last month – during peak load there was a hardware failure on the Server powering a RDS Master Database – RDS automatically failed over to the alternate zone within minutes and our customers experience was fully functional shortly thereafter.

Innovation 146

Innovation AWS Education Network 146

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. After reading ​​ this document you will better understand SQL Server I/O needs and capabilities.

Servers 40

Servers Cache Database Media 40

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

All Things Distributed

JANUARY 18, 2012

In response, we began to develop a collection of storage and database technologies to address the demanding scalability and reliability requirements of the Amazon.com ecommerce platform. After the successful launch of the first Dynamo system, we documented our experiences in a paper so others could benefit from them. Amazon DynamoDBâ??s

Scalability 167

Scalability Database Ecommerce Latency 167

Dynatrace

AUGUST 5, 2019

Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. Optimize Query Performance and Data Storage Cost. Extract less critical data into a cheaper database storage option. Optimize the performance of key queries.

Cloud 31

Cloud Traffic Database Network 31

Alex Russell

MARCH 6, 2021

Unless a site is installed to the home screen as a PWA , any single page is just another in a series of documents that users experience as a river of links. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Hardware Past As Performance Prologue.

Performance 124

Performance Network Cache Metrics 124

O'Reilly

SEPTEMBER 19, 2023

It progressed from “raw compute and storage” to “reimplementing key services in push-button fashion” to “becoming the backbone of AI work”—all under the umbrella of “renting time and storage on someone else’s computers.” A single document may represent thousands of features.

Hardware 99

Hardware Storage Big Data Blockchain 99

Alex Russell

JULY 14, 2021

To quote the Android documentation , a WebView is.: Here, native apps are doing work related to their core function; storage and tracking of user data are squarely within the four corners of the app's natural responsibilities. Hardware access APIs, notably: Geolocation. But neither has to be. What is a WebView? Web Bluetooth.

Google 121

Google Mobile Engineering Internet 121

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). Documentation: [link]. With faster disks (i.e.

Cache 47

Cache C++ AWS Airlines 47

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Currently, CPU affinity (i.e., Good MySQL everyone. References.

Tuning 45

Tuning Virtualization Testing Servers 45

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing and execution times (we’ll talk about them in detail later). Site speed topography , with key metrics represented for key pages on the site. Large preview ).

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). Gatsby (React), Vuepress (Vue) Preact CLI , and PWA Starter Kit provide reasonable defaults for fast loading out of the box on average mobile hardware. ??Also,

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). Gatsby.js (React), Preact CLI , and PWA Starter Kit provide reasonable defaults for fast loading out of the box on average mobile hardware. Getting started with Webpack can be tough though.

Performance 103

Performance Cache Metrics Network 103