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. Why Do MySQL Backups Matter? From MySQL 5.6

Best Practices 79

Best Practices Storage Strategy Database 79

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 107

Availability Database Open Source Hardware 107

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

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 83

Availability Open Source Architecture Database 83

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 79

Database Servers Storage Strategy 79

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

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

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

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

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 87

Open Source Storage Database Big Data 87

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

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

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 92

Database Analytics Storage Processing 92

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

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

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52

All Things Distributed

APRIL 5, 2012

Troy: We moved our service from internal servers to AWS. When we first attempted to load our production database it took 28 hours – after a few days of attempts to reduce the load time through well-known optimizations ( mostly documented on the RDS website ) we were stuck at 8 hours. the recoverability of data.

Innovation 146

Innovation AWS Education Network 146

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

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. Cells are spread across a mesh of nodes (each node running on a single server). This paper is a real joy to read.

Database 106

Database AWS Network Design 106

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

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., Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. Main-document scrolling (assuming no active touch listeners). Parsing CSS.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. What does it mean?

Performance 145

Performance Cache Network Metrics 145

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

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. The following shows one of the slides I use to answer the question: What happens if I move this group of servers? Optimize Query Performance and Data Storage Cost.

Cloud 31

Cloud Traffic Database Network 31

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

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

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). I will compare AWS Aurora with MySQL (Percona Server) 5.6

Cache 46

Cache C++ AWS Airlines 46

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. It is well hidden in the Optimization: Optimizing the MySQL Server chapter. Or maybe modify the Servers layout such as adding a Slave and dedicating it to ETL reads. I am talking about resource groups. Currently, CPU affinity (i.e., Conclusion.

Tuning 45

Tuning Virtualization Testing Servers 45

All Things Distributed

JANUARY 18, 2012

Behind the scenes, Amazon DynamoDB automatically spreads the data and traffic for a table over a sufficient number of servers to meet the request capacity specified by the customer. After the successful launch of the first Dynamo system, we documented our experiences in a paper so others could benefit from them. The growth of Amazonâ??s

Scalability 167

Scalability Database Ecommerce Latency 167