Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. Make sure you design the data types correctly while planning for the future growth of the table.

Open Source 91

Open Source Storage Database Big Data 91

Adrian Cockcroft

JUNE 21, 2022

Another big jump, but now it was my job to run benchmarks in the lab, and write white papers that explained the new products to the world, as they were launched. I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R.

Tuning 52

Tuning Benchmarking Engineering C++ 52

The Netflix TechBlog

MAY 21, 2019

The device ecosystem is rich with partners ranging from Silicon-on-Chip (SoC) manufacturers, Original Design Manufacturer (ODM) and Original Equipment Manufacturer (OEM) vendors. Solving the above problems could help Netflix and our Partners save time and money during the entire lifecycle of device design, build, test, and certification.

Testing 163

Testing AWS Lambda Network 163

Scalegrid

MARCH 28, 2024

Key Takeaways Redis offers complex data structures and additional features for versatile data handling, while Memcached excels in simplicity with a fast, multi-threaded architecture for basic caching needs. Redis Data Types and Structures The design of Redis’s data structures emphasizes versatility.

Cache 130

Cache Storage Scalability Architecture 130

Dynatrace

OCTOBER 2, 2023

Transforming an application from monolith to microservices-based architecture can be daunting, and knowing where to start can be difficult. Because monolithic applications combine database, client-side interfaces, and server-side application elements in a single executable, they’re difficult to understand, even for their own administrators.

Architecture 230

Architecture Artificial Intelligence Cloud Open Source 230

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 111

Availability Database Open Source Hardware 111

The Morning Paper

MAY 14, 2019

Last time around we looked at the DeathStarBench suite of microservices-based benchmark applications and learned that microservices systems can be especially latency sensitive, and that hotspots can propagate through a microservices architecture in interesting ways. ASPLOS’19. accuracy) and avoided 495 (84%) of them.

Big Data 45

Big Data Cloud Performance Hardware 45

All Things Distributed

NOVEMBER 19, 2010

There was an excellent first benchmarking report of the Cluster GPU Instances by the folks at Cycle Computing - " A Couple More Nails in the Coffin of the Private Compute Cluster " The Top500 supercomputer list. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Amazon DynamoDB â??

AWS 67

AWS Cloud Benchmarking Storage 67

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

HammerDB

NOVEMBER 30, 2018

However if you have downloaded the source code and are looking to add features or make modifications such as adding new databases you may be wondering once you have the source code where to start. However HammerDB will not be able to connect to a database yet and the librarycheck command included with the CLI gives an indication why.

Architecture 40

Architecture Virtualization Open Source C++ 40

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 82

Availability Hardware Open Source Database 82

Percona

JANUARY 24, 2023

Such “torn pages” are corruptions from the database point of view. This is not a problem for PostgreSQL alone; every database software needs to deal with this problem. Lz4 compression can be the choice if the database workload is CPU bound because it is light on the CPU. The actual benefit of compression depends on many factors.

Database 120

Database Benchmarking Open Source Latency 120

Particular Software

SEPTEMBER 20, 2021

Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. If you did such a benchmark, here’s an incomplete picture you might end up with: Graph of microbenchmark showing RPC is faster than messaging.

Benchmarking 97

Benchmarking Latency Servers Systems 97

Percona

MARCH 20, 2023

When designing an architecture, many components need to be considered before deciding on the best solution. In short, each cluster is, in reality, a single database with high availability and other functionalities built in. Anyhow, we are here to talk about Proxies. MySQL Router was never in the game.

Games 124

Games Latency Traffic Cache 124

IO River

NOVEMBER 15, 2023

For example, if a request activates a rule designed to block SQL injection attempts, the WAF might automatically block that request, preventing it from reaching your web application.‍Security Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture.

Traffic 52

Traffic Network Logistics Architecture 52

IO River

NOVEMBER 2, 2023

For example, if a request activates a rule designed to block SQL injection attempts, the WAF might automatically block that request, preventing it from reaching your web application.‍Security Flywheel‍‍When it comes to fortifying web applications, think of security as a flywheel—an ever-revolving cycle that gains momentum with each turn.

Traffic 40

Traffic Network Logistics Architecture 40

Alex Russell

MARCH 6, 2021

Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. Chip design choices and silicon economics are the defining feature of the still-growing Performance Inequality Gap. Today, either method returns a similar answer. A 2021 Global Baseline.

Performance 124

Performance Network Cache Metrics 124

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 107

Database Benchmarking Latency C++ 107

The Morning Paper

SEPTEMBER 3, 2019

Data is replicated across regions, but for every data item one of these regions is designated as its home replica. The most technically challenging problem in the design of LOG is the execution of multi-home transactions. Is my data at home? All writes and linearizable reads of a data item are directed to that replica.

Latency 70

Latency Processing Benchmarking Systems 70

High Scalability

SEPTEMBER 28, 2018

MrTonyD : I was writing production code over 30 years ago (C, OS, database). Martin Sústrik : Philosophers, by and large, tend to be architecture astronauts. Programmers' insight is that architecture astronauts fail. JavaScript benchmark. I acknowledge that. It is much worse to be a software developer now.

Internet 35

Internet Internet Scalability Blockchain 35

Alex Russell

MAY 9, 2022

Design: Performance is the gap between Figma mockups and the user experience of products for many, but not all , users. The extent to which a product performs well, the higher its likelihood of behaving in accordance to the approved design spec. Consistent performance matters just as much as low average latency. Photo by Launde Morel.

Performance 86

Performance Latency Metrics Engineering 86

SQL Server According to Bob

SEPTEMBER 26, 2016

While we were confident in the design of SQL Server 2012, several customers reported to us performance problems that did not appear to be with disk subsystems, CPU, or networks. Our design needed to scale and be adaptable to the modern hardware on the market. First, we looked at the overall architecture of the replica design.

Availability 40

Availability Servers Hardware Benchmarking 40

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

Highly Scalable

MARCH 10, 2015

Although these problems are very different, we are trying to establish a common framework that helps to design optimization and data mining tasks required for solutions. The design of the model heavily depends on the problem. This model helps to design targeted usage expansion campaigns. Propensity to category expansion.

Retail 152

Retail C++ Analytics Metrics 152

High Scalability

NOVEMBER 25, 2019

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. To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. SOA architecture based on REST APIs.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Map design decisions against performance budget and the priorities defined early on.

Performance 145

Performance Cache Network Metrics 145