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 109

Availability Database Open Source Hardware 109

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. What is workload in cloud computing? This need is often referred to as “workload optimization.”

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

JULY 29, 2020

PgBouncer defines one pool per user+database combination. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client. Throughput Benchmark.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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

Dynatrace

SEPTEMBER 23, 2021

Unfortunately, container security is much more difficult to achieve than security for more traditional compute platforms, such as virtual machines or bare metal hosts. Application developers commonly leverage open-source software when building containerized applications. So far, their prediction seems to be spot-on.

Open Source 249

Open Source Benchmarking Best Practices Network 249

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. ” Usually when benchmark results are surprising it is a major hint that something could be misconfigured and that certainly seems the case here, so what could it be?

Benchmarking 63

Benchmarking Performance Hardware C++ 63

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. Figure 1: CPU-Z Benchmark Results for LS16v2. Figure 2: Microsoft Project Olympus.

Azure 42

Azure Virtualization Storage Benchmarking 42

Dynatrace

APRIL 8, 2021

Local development is harder. As such, providing the same environment during local development can be complicated. When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. Also, “serverless” means more than just Lambda functions.

Lambda 220

Lambda AWS Serverless Monitoring 220

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. However HammerDB will not be able to connect to a database yet and the librarycheck command included with the CLI gives an indication why. HammerDB CLI v3.1 HammerDB CLI v3.1 Oratcl 4.6.

Architecture 40

Architecture Virtualization Open Source C++ 40

Dynatrace

APRIL 8, 2021

Local development is harder. As such, providing the same environment during local development can be complicated. When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. Also, “serverless” means more than just Lambda functions.

Lambda 182

Lambda AWS Serverless Monitoring 182

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 62

Cache Database Games Healthcare 62

Alex Russell

APRIL 29, 2021

Apple forces developers of competing browsers to use their engine for all browsers on iOS , restricting their ability to deliver a better version of the web platform. They are, pound for pound, some of the best engine developers globally and genuinely want good things for the web. With each team, benchmarks lost are understood as bugs.

Media 145

Media Games Education Engineering 145

Brendan Gregg

FEBRUARY 9, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. These results aren't final, since more changes are still being developed, such as for Spectre. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings.

Performance 75

Performance Benchmarking Cache Tuning 75

Brendan Gregg

FEBRUARY 8, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. These results aren't final, since more changes are still being developed, such as for Spectre. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings.

Performance 40

Performance Benchmarking Cache Tuning 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

Alex Russell

MAY 9, 2022

Again, these are management problems. --> In the midst of these crises, thoughtful organisations begin to develop a performance management discipline. Teams that develop these advantages progress through a hierarchy of performance management practices. Teams can get stuck at Level 1, treating each turn through a Development ??

Performance 86

Performance Latency Metrics Engineering 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. SQL Server can enable torn page detection on a per-database basis.

Servers 40

Servers Cache Media Hardware 40