HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

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 79

Availability Hardware Open Source Database 79

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. We need to identify whether it was deleted manually by mistake or was due to hardware failure. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below.

Hardware 75

Hardware C++ Database Open Source 75

Percona

NOVEMBER 2, 2023

On October 24th, the Percona Kubernetes Squad held the first Ask-me-Anything (AMA) session to address inquiries regarding the utilization of Kubernetes for database deployment. This blog post will outline the top three questions raised during the session and provide thorough responses from our team of experts.

Open Source 86

Open Source Hardware Storage Database 86

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 125

Performance Hardware Tuning Storage 125

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

Dynatrace

JANUARY 26, 2021

This allows teams to sidestep much of the cost and time associated with managing hardware, platforms, and operating systems on-premises, while also gaining the flexibility to scale rapidly and efficiently. REST APIs, authentication, databases, email, and video processing all have a home on serverless platforms.

Serverless 245

Serverless Efficiency Lambda Azure 245

Dynatrace

MAY 14, 2020

Dynatrace PurePath technology captures and analyzes transactions end to end across every tier of your application technology stack, from the browser all the way down to the code and database level. A Dynatrace Managed cluster may lack the necessary hardware to process all the additional incoming data. Impact on disk space.

Processing 159

Processing Hardware Traffic Storage 159

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Simplicity.

Serverless 289

Serverless AWS Lambda Storage 289

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. They’re proven and ready-to-go.

Architecture 96

Architecture Availability Open Source Healthcare 96

Dynatrace

JUNE 29, 2022

They use the same hardware, APIs, tools, and management controls for both the public and private clouds. Amazon Web Services (AWS) Outpost : This offering provides pre-configured hardware and software for customers to run native AWS computing, networking, and services on-premises in a cloud-native manner.

Infrastructure 190

Infrastructure Cloud Azure AWS 190

Dynatrace

AUGUST 26, 2020

There’s no other competing software that can provide this level of value with minimum effort and optimal hardware utilization that can scale up to web-scale! I’d like to stress the lean approach to hardware that our customers require for running Dynatrace Managed. Support for high memory instances.

Performance 150

Performance Hardware Java Storage 150

Dynatrace

APRIL 5, 2021

These include website hosting, database management, backup and restore, IoT capabilities, e-commerce solutions, app development tools and more, with new services released regularly. A new record entering a database table. Tasks like API requests, database calls, and file system management are perfect candidates for this service.

Lambda 186

Lambda AWS Serverless Hardware 186

Dynatrace

MAY 5, 2020

This is recognition of the successful integration of Dynatrace with the Amazon RDS, which simplifies the installation, operation, and scaling of relational databases in the AWS cloud. Tasks such as hardware provisioning, database setup, patching, and backups are fully automated, making Amazon RDS cost efficient and scalable.

Design 144

Design AWS Education Innovation 144

Dynatrace

SEPTEMBER 30, 2021

It requires purchasing, powering, and configuring physical hardware, training and retaining the staff capable of servicing and securing the machines, operating a data center, and so on. They need enough hardware to serve their anticipated volume and keep things running smoothly without buying too much or too little. Reduced cost.

Cloud 172

Cloud Traffic Best Practices Strategy 172

Testlodge

APRIL 14, 2021

These systems are a combination of different hardware and software which have been configured to perform the desired task. Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. Types of Configuration Testing.

Testing 89

Testing Hardware Virtualization Operating System 89

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. We have several YouTube Tutorials and blog posts available that show how you can use Dynatrace RUM data for Web Performance & User Experience Optimization.

Cache 203

Cache Architecture Database Government 203

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 8.0

Cache 102

Cache Hardware Servers Benchmarking 102

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 104

Performance Monitoring Traffic Database 104

All Things Distributed

JULY 14, 2015

I am excited to share with you that today we are expanding DynamoDB with streams, cross-region replication, and database triggers. In traditional database architectures, database engines often run a small search engine or data warehouse engines on the same hardware as the database. DynamoDB Triggers.

Database 167

Database Lambda AWS IoT 167

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. However, it’s not normal and only happens when there’s too much write activity beyond what the hardware can handle.

Hardware 88

Hardware C++ Storage Cache 88

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. ChatGPT: The innodb_redo_log_capacity parameter specifies the maximum size of the InnoDB redo log buffer, which is used to store changes made to the database before they are written to disk. What could it be?

Social Media 121

Social Media Database Servers Cache 121

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Figure 2: Amazon Elastic Block Storage Running relational or NoSQL databases is one of the use cases where EBS is recommended for.

Cloud 119

Cloud Serverless AWS Storage 119

Dynatrace

AUGUST 5, 2022

In this scenario, message queues coordinate large numbers of microservices, which operate autonomously without the need to provision virtual machines or allocate hardware resources. The problem could be in the database, the HTTP connection, the configuration of the message, or an outage on the sending or receiving end.

Monitoring 209

Monitoring Serverless Programming Speed 209

Dynatrace

AUGUST 5, 2022

In this scenario, message queues coordinate large numbers of microservices, which operate autonomously without the need to provision virtual machines or allocate hardware resources. The problem could be in the database, the HTTP connection, the configuration of the message, or an outage on the sending or receiving end.

Monitoring 208

Monitoring Serverless Programming Speed 208

Dynatrace

APRIL 15, 2022

VA also used Dynatrace to instrument its Consolidated Mail Outpatient Pharmacy Application, a mission-critical app with a heavily distributed database hosted in seven locations across the U.S. In the past, severe database issues seriously hurt system performance, causing delayed shipping times for prescriptions.

Cloud 185

Cloud Infrastructure Innovation Monitoring 185

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Werner Vogels weblog on building scalable and robust distributed systems.

Scalability 167

Scalability Database Ecommerce Latency 167

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). Each shard stores a subset of the data and operates as an independent database.

Best Practices 72

Best Practices Traffic Database Servers 72

Adrian Cockcroft

FEBRUARY 9, 2023

Picture by Adrian — Ka’anapali sunset 2023 There’s been a lot of discussion about platforms recently, I talked about why I think it’s a current hot meme on the WTF Podcast with Charles Humble recently, and Sam Newman just wrote a blog post “ Don’t call it a platform ”.

Engineering 137

Engineering Serverless Lambda AWS 137

Adrian Cockcroft

JANUARY 17, 2022

There were five trends and topics for 2021, Serverless First, Chaos Engineering, Wardley Mapping, Huge Hardware, Sustainability. I blogged a summary of my map camp talk here: Map Camp 2021?—?links These are personal thoughts across a wide range of topics, I’m not speaking for my current or past employers in this post.

Serverless 98

Serverless Hardware AWS Architecture 98

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with illustrative examples. What are MySQL general tablespaces?

Storage 88

Storage Engineering Database Hardware 88

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 84

Availability Open Source Architecture Database 84

Percona

JUNE 20, 2023

So, I decided to gather information and write a detailed blog about this issue. In this blog, I will also cover a scenario that causes “segmentation fault.” However, this blog is written from the database perspective; hence, I would not prefer to dive into those scenarios as they are very high-level programming concepts.

Programming 84

Programming C++ Database Virtualization 84

The Netflix TechBlog

AUGUST 30, 2021

Complementing the hardware is the software on the RAE and in the cloud, and bridging the software on both ends is a bi-directional control plane. In this blog post, we will focus on the latter feature set. In particular, the Kafka integration is the most relevant for this blog post.

Latency 213

Latency Traffic Transportation Hardware 213

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. AFAIK Facebook does this.

Programming 85

Programming Servers Database Hardware 85