Scalegrid

JUNE 9, 2020

MySQL and PostgreSQL are the top two open source relational databases in the world, and Redis is the top key-value database. The open source model is not only popular with the developer market, but also enterprise companies looking to modernize their infrastructure and reduce spend.

Availability 227

Availability Open Source Benchmarking Database 227

High Scalability

SEPTEMBER 1, 2020

MySQL is the number one open source database that’s commonly hosted through Azure instances. While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you improve your MySQL performance. In this blog post, we compare Azure Database for MySQL vs.

Azure 137

Azure Database Benchmarking Performance 137

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., A typical architecture diagram for one of these services looks like this: Suitably armed with a set of benchmark microservices applications, the investigation can begin! ASPLOS’19.

Open Source 61

Open Source Hardware Benchmarking Systems 61

Dynatrace

SEPTEMBER 23, 2021

Application developers commonly leverage open-source software when building containerized applications. In fact, the market research firm Forrester says that the average container image is comprised of 70% open-source software.[1] 1] And unfortunately, open-source software is often fraught with security vulnerabilities.

Open Source 252

Open Source Benchmarking Best Practices Network 252

Percona

AUGUST 22, 2023

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. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 77

Availability Hardware Open Source Database 77

Scalegrid

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL DigitalOcean Performance Benchmark. In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL. Read-Intensive Throughput Benchmark.

Database 217

Database Benchmarking Latency Performance 217

Scalegrid

JULY 13, 2020

The unstoppable rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. What’s causing this massive shift?

Open Source 244

Open Source Tuning C++ Database 244

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. In fact, according to ScyllaDB’s performance benchmark report, their 99.9 This number is more inline with our recent 2019 Open Source Database Trends Report where 56.9% year for a total of 48 cores.

Big Data 187

Big Data Database Open Source Azure 187

Percona

DECEMBER 11, 2023

We performed a standard benchmarking test using the sysbench tool to compare the performance of a DLV instance vs a standard RDS MySQL instance, as shared in the following section. Benchmarking AWS RDS DLV setup Setup 2 RDS Single DB instances 1 EC2 Instance Regular DLV Enabled Sysbench db.m6i.2xlarge 2xlarge c5.2xlarge MySQL 8.0.31

AWS 96

AWS Benchmarking Performance Traffic 96

Scalegrid

MARCH 28, 2024

Redis Revealed: An Overview Redis, a renowned open-source, in-memory remote dictionary server, stands out for its diverse data structures and advanced features. Memcached Explained: The Simplicity of Caching Alternatively, Memcached, a high-performance, open-source caching solution, prides itself on its simplicity.

Cache 130

Cache Storage Scalability Architecture 130

Alex Podelko

APRIL 18, 2021

MongoDB shared a lot of information on how we do performance testing and even open sourced some parts of it. The paper Creating a Virtuous Cycle in Performance Testing at MongoDB and pre-recoded video are already available. [Another interesting project in that area is keptn , but that is about it.

Performance Testing 182

Performance Testing Performance Testing Education 182

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. This means that when a query is executed, pgpool-II can check the cache first to see if the results are already available rather than sending the query to the database server.

Cache 113

Cache Open Source Benchmarking Database 113

Dynatrace

SEPTEMBER 21, 2023

Developed using guidance from the Sustainable Digital Infrastructure Alliance (SDIA) and expanding on formulas from the open source project Cloud Carbon Footprint , Carbon Impact measures and reports the IT carbon footprint of all Dynatrace-monitored hosts across an organization’s entire hybrid and multicloud environment in a single interface.

Energy 235

Energy Cloud Airlines Strategy 235

Scalegrid

JUNE 4, 2020

As an open source database, it’s a highly popular choice for enterprise applications looking to modernize their infrastructure and reduce their total cost of ownership, along with startup and developer applications looking for a powerful, flexible and cost-effective database to work with. PostgreSQL Benchmark Setup. Query Mode.

Database 230

Database Latency Benchmarking Performance 230

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 104

Database Benchmarking Latency C++ 104

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

The Netflix TechBlog

NOVEMBER 22, 2019

December 2 1pm-2pm CMP 326-R Capacity Management Made Easy with Amazon EC2 Auto Scaling Vadim Filanovsky , Senior Performance Engineer & Anoop Kapoor, AWS Abstract :Amazon EC2 Auto Scaling offers a hands-free capacity management experience to help customers maintain a healthy fleet, improve application availability, and reduce costs.

AWS 100

AWS Entertainment Open Source Benchmarking 100

The Netflix TechBlog

NOVEMBER 22, 2019

December 2 1pm-2pm CMP 326-R Capacity Management Made Easy with Amazon EC2 Auto Scaling Vadim Filanovsky , Senior Performance Engineer & Anoop Kapoor, AWS Abstract :Amazon EC2 Auto Scaling offers a hands-free capacity management experience to help customers maintain a healthy fleet, improve application availability, and reduce costs.

AWS 100

AWS Entertainment Open Source Benchmarking 100

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. This is particularly true when you’re migrating to an open source database that those on your staff may or may not be intimately familiar with.

Database 82

Database Open Source Benchmarking Strategy 82

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

Scalegrid

MARCH 22, 2024

This process thoroughly assesses factors like cost-effectiveness, security measures, control levels, scalability options, customization possibilities, performance standards, and availability expectations. The challenges in integration come from varying APIs, data structures, and unique deployment schemes specific to each cloud platform.

Strategy 130

Strategy Cloud Government Innovation 130

HammerDB

OCTOBER 18, 2018

Before introducing how this works it is important to acknowledge the ASHMON tool from which this functionality was adopted and more importantly its author Kyle Hailey for giving permission to add it as open source.

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. error_log: Specifies the location of the MySQL error log.

Performance 104

Performance Monitoring Traffic Database 104

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. MySQL Performance Benchmark Configuration. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS.

AWS 183

AWS Latency Performance Benchmarking 183

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 134

Tuning Cache Servers Benchmarking 134

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

High Scalability

OCTOBER 29, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS.

AWS 133

AWS Latency Performance Open Source 133

Percona

MARCH 27, 2023

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 101

Cache Hardware Servers Benchmarking 101

Percona

OCTOBER 12, 2023

That said, your application may not be in the list of supported languages, but if it’s compatible with any of the available profilers, you can still produce flame graphs. In case the application is in Go, the selected profiler will be eBPF. ✔ Launching profiler. ✔ Profiling. Try Percona Distribution for MySQL today!

Code 109

Code Tuning C++ Benchmarking 109

HammerDB

DECEMBER 5, 2020

Additionally both commercial and open source tools based on the specifications also continued to use TPC-C and TPC-H to describe these workloads. In the days before highly performant SSDs and persistent memory, database benchmarks had a significant challenge in comparing performance due to the available I/O performance.

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

JULY 25, 2023

the IBD file is “self-describing”; for example, the table schema is available within an IBD file. Benchmarks xtrabackup –prepare on backup directory of other sizes like 10K, 50K, 100K, and 250K tables. This is a JSON representation of the table. For InnoDB tablespaces, the information is stored within the tablespace.

Cache 84

Cache Benchmarking Servers Design 84

SQL Performance

NOVEMBER 18, 2019

and the overall size will determine the amount of temporary storage available. The common trend is to choose a VM based exclusively on vCPU, memory, and storage capacity without benchmarking the current IO and throughput requirements. Once you select your filter options, if any, you will see a list of available servers.

Azure 76

Azure Benchmarking Storage Virtualization 76

Percona

MARCH 23, 2023

Benchmark before you decide. Typically a good value is 70%-80% of available memory. Innodb_io_capacity (Dynamic) – It defines the number of I/O operations per second (IOPS) available to InnoDB background tasks, such as flushing pages from the buffer pool and merging data from the change buffer.

Performance 124

Performance Hardware Tuning Storage 124

Percona

JANUARY 24, 2023

This will be clearly visible in PostgreSQL performance benchmarks as a “ Sawtooth wave ” pattern observed by Vadim in his tests: As we can see, the throughput suddenly drops after every checkpoint due to heavy WAL writing and gradually picks up until the next checkpoint. They do a much better job than what was available in PostgreSQL (pglz).

Database 115

Database Benchmarking Open Source Latency 115

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

JULY 19, 2023

Look for part two, where we benchmark ULID in MySQL! Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

C++ 79

C++ Servers Benchmarking Best Practices 79