Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. This tutorial will use Ubuntu 20.04 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 85

Scalability Database Open Source Traffic 85

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

Dynatrace

MARCH 20, 2024

Continuously monitoring application behavior, network traffic, and system logs allows teams to identify abnormal or suspicious activities that could indicate a security breach. This approach can determine malicious activity and block it by monitoring the flow of data within the application, all the way from the user to the database.

Monitoring 221

Monitoring Analytics Traffic Best Practices 221

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 97

AWS Benchmarking Performance Traffic 97

All Things Distributed

JUNE 21, 2018

A common question that I get is why do we offer so many database products? To do this, they need to be able to use multiple databases and data models within the same application. Seldom can one database fit the needs of multiple distinct use cases. Seldom can one database fit the needs of multiple distinct use cases.

Database 167

Database AWS Games Latency 167

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. ALTER EVENT SESSION [ ADS_Standard_Azure ] ON DATABASE. DROP EVENT sqlserver.

Azure 96

Azure Database Tuning Network 96

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 140

Traffic Performance Database Metrics 140

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Dynatrace

SEPTEMBER 30, 2021

In case of a spike in traffic, you can automatically spin up more resources, often in a matter of seconds. Likewise, you can scale down when your application experiences decreased traffic. For example, as traffic increases, costs will too. Analyze your resource consumption and traffic patterns.

Cloud 172

Cloud Traffic Best Practices Strategy 172

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. Existing data got updated to be backward compatible without impacting the existing running production traffic.

Media 237

Media Traffic Processing Design 237

Percona

JUNE 2, 2023

WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source. MySQL was the database for phpWebLog, for example, way back in 2000. MySQL was founded in 1995 and went open source in 2000.

Open Source 95

Open Source Traffic Tuning Database 95

Percona

AUGUST 8, 2023

Or worse yet, sometimes I get questions about regaining normal operations after a traffic increase caused performance destabilization. But we can discuss common bottlenecks, how to assess them, and have a better understanding as to why proactive monitoring is so important when it comes to responding to traffic growth.

Traffic 89

Traffic Cache Monitoring Database 89

Dynatrace

MAY 6, 2020

Over the last two month s, w e’ve monito red key sites and applications across industries that have been receiving surges in traffic , including government, health insurance, retail, banking, and media. The following day, a normally mundane Wednesday , traffic soared to 128,000 sessions.

Website 223

Website Monitoring Retail Media 223

The Netflix TechBlog

FEBRUARY 18, 2022

We thus assigned a priority to each use case and sharded event traffic by routing to priority-specific queues and the corresponding event processing clusters. This separation allows us to tune system configuration and scaling policies independently for different event priorities and traffic patterns.

Systems 334

Systems Traffic Architecture Mobile 334

Dynatrace

APRIL 16, 2020

Aside from the huge surge in internal application usage, businesses are also witnessing increased levels of user traffic to their applications. Facilitating an understanding of traffic patterns and potential traffic spikes helps maintain customer experience. One example of these surges was from an unemployment application.

Traffic 206

Traffic Government Database Infrastructure 206

The Morning Paper

NOVEMBER 14, 2019

Taiji: managing global user traffic for large-scale internet services at the edge Xu et al., It’s another networking paper to close out the week (and our coverage of SOSP’19), but whereas Snap looked at traffic routing within the datacenter, Taiji is concerned with routing traffic from the edge to a datacenter. SOSP’19.

Traffic 42

Traffic Internet Internet Latency 42

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 11, 2023

Database monitoring. This ensures the database queries are performant, while also identifying host problems. For example, uptime detection can identify database instability and help to improve mean time to restoration. Website monitoring examines a cloud-hosted website’s processes, traffic, availability, and resource use.

Cloud 230

Cloud Monitoring Best Practices Infrastructure 230

All Things Distributed

MAY 19, 2017

In many, high-throughput, OLTP style applications the database plays a crucial role to achieve scale, reliability, high-performance and cost efficiency. For a long time, these requirements were almost exclusively served by commercial, proprietary databases.

Database 117

Database Design Cloud Storage 117

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 197

Database Traffic Transportation Open Source 197

DZone

AUGUST 28, 2023

If you are running a distributed system where each request talks to more than a couple of services, databases, and a queuing system, pinpointing the cause of an issue is not a trivial affair. There are a plethora of tools aiming to solve this problem to various degrees.

Strategy 100

Strategy Traffic Database Systems 100

Dynatrace

FEBRUARY 10, 2022

WAFs protect the network perimeter and monitor, filter, or block HTTP traffic. Compared to intrusion detection systems (IDS/IPS), WAFs are focused on the application traffic. RASP solutions sit in or near applications and analyze application behavior and traffic.

Traffic 239

Traffic Benchmarking Innovation Java 239

Dynatrace

AUGUST 18, 2022

Such scans enable teams to detect SQL injection attacks that allow someone to maliciously inject code into a database query. Scanning the runtime environment of your services can help to identify unusual network traffic patterns. National Vulnerability Database (NVD) lists over 175,000 known vulnerabilities.

Traffic 171

Traffic Java Network DevOps 171

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Database monitoring Once more, under Applications & Microservices, we’ll also find Databases.

Metrics 179

Metrics Monitoring Database Network 179

Percona

DECEMBER 21, 2023

The integration of those projects, plus the years of Percona expertise in the database space, makes PMM one of the best database monitoring solutions on the market. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. Download Percona Monitoring and Management Today

Availability 100

Availability Monitoring Open Source Traffic 100

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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 104

Performance Monitoring Traffic Database 104

Scalegrid

MARCH 28, 2024

For vertical scaling, Memcached allows augmenting existing servers with additional CPU cores and memory, thereby enhancing the capacity of the caching pool to manage higher traffic volumes and larger data loads. Advanced Redis Features Showdown Big data center concept, cloud database, server power station of the future.

Cache 130

Cache Storage Scalability Architecture 130

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 72

Best Practices Traffic Database Servers 72

Dynatrace

SEPTEMBER 29, 2021

This opens the door to auto-scalable applications, which effortlessly matches the demands of rapidly growing and varying user traffic. Containers can be replicated or deleted on the fly to meet varying end-user traffic. In production, containers are easy to replicate. What is Docker? Networking.

Open Source 310

Open Source Traffic DevOps Cloud 310

Dynatrace

JANUARY 23, 2023

These include improving API traffic management and caching mechanisms to reduce server and network load, optimizing database queries, and adding additional compute resources, just to name some. While some of these are already done, such as adding additional compute, others require more development and testing. Hopefully never.)

Social Media 130

Social Media Cache Traffic Media 130

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

Database 77

Database Traffic C++ Servers 77

DZone

JULY 6, 2020

TiDB is an open-source, distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. For external reasons, application traffic may surge and increase the pressure on the cluster. Ideally, a TiDB cluster should always be efficient and problem-free. However, reality is often unsatisfactory.

Open Source 130

Open Source Latency Traffic Analytics 130

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