Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it.

Availability 110

Availability Database Open Source Hardware 110

DZone

MARCH 14, 2023

As an engineer, you probably know that server performance under heavy load is crucial for maintaining the availability and responsiveness of your services. In this post, we'll explore both strategies through a simple simulation in Colab, allowing you to see the impact of changing parameters on system performance.

Strategy 141

Strategy Latency Availability Traffic 141

DZone

JANUARY 3, 2022

An access log is generated by the web server to log the details about the request that it has processed. While doing any performance analysis, these logs play an important role. Most people are aware of the application server log but many of them are not aware of the web server/load balancer access log.

Performance 246

Performance Servers Code Availability 246

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Percona

DECEMBER 21, 2023

Being software composed of different, multiple technologies can add complexity to a well-known concept: High Availability (HA). As you can see, stats are available via the port 8404. And here is the not-so-easy part: One has to deploy at least two PMM instances on at least two different servers AND set up replicas. How to do it?

Availability 103

Availability Monitoring Open Source Traffic 103

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements.

Availability 85

Availability Open Source Architecture Database 85

DZone

OCTOBER 26, 2021

Database Availability Group (DAG) is a built-in framework in Microsoft Exchange Server that uses continuous replication and failover clustering to ensure high availability and site resilience. In DAG, there is one active server and a copy of the database on the active server is replicated across all passive servers.

Servers 188

Servers Database Availability Performance 188

Scalegrid

OCTOBER 31, 2019

Wondering which high availability framework to use for your PostgreSQL deployments ? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni , in our Managing High Availability in PostgreSQL series. PostgreSQL High Availability Framework Infographic.

Availability 187

Availability Azure AWS DevOps 187

Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. How it Works.

Availability 147

Availability Servers Open Source Database 147

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. The obvious answer is this: To achieve high availability.

Architecture 99

Architecture Availability Open Source Healthcare 99

Dynatrace

JULY 11, 2023

IBM Power servers enable customers to respond faster to business demands, protect data from core to cloud, and streamline insights and automation. Intelligent root cause analysis: Use Davis® AI to automatically detect and analyze performance issues across the entire tech stack.

Architecture 167

Architecture Availability Infrastructure Metrics 167

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […].

Servers 69

Servers Availability Virtualization Infrastructure 69

Percona

SEPTEMBER 19, 2023

It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. Improved vacuum freezing performance. PostgreSQL 16 comes packed with features.

Availability 111

Availability Open Source Database Servers 111

Dynatrace

OCTOBER 23, 2023

Secondly, determining the correct allocation of resources (CPU, memory, storage) to each virtual machine to ensure optimal performance without over-provisioning can be difficult. This presents a challenge for IT operations teams, specifically in identifying and addressing performance issues or planning how to prevent future issues.

Efficiency 210

Efficiency Virtualization Hardware Performance 210

Dynatrace

JUNE 25, 2020

Dynatrace Managed is intrinsically highly available as it stores three copies of all events, user sessions, and metrics across its cluster nodes. Our Premium High Availability comes with the following features: Active-active deployment model for optimum hardware utilization. Dynatrace news. Minimized cross-data center network traffic.

Availability 244

Availability Hardware Latency Traffic 244

SQL Shack

DECEMBER 10, 2020

In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it. Usually, we use SQL Server Management Studio to perform administrative tasks using the interactive windows.

Availability 87

Availability Servers Database Performance 87

SQL Shack

JULY 23, 2020

This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups. Introduction In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group. We performed the following steps at a high level.

Availability 87

Availability Servers Virtualization Performance 87

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 80

Availability Hardware Open Source Database 80

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 127

Performance Hardware Tuning Storage 127

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142

Servers Testing C++ Code 142

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. This can negatively impact performance and cause delays.

Servers 115

Servers Best Practices Database Open Source 115

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 106

Performance Monitoring Traffic Database 106

Dynatrace

MARCH 18, 2024

In a Dynatrace Perform 2024 session, Kristof Renders, director of innovation services, discussed how a stronger FinOps strategy coupled with observability can make a significant difference in helping teams to keep spiraling infrastructure costs under control and manage cloud spending. Wrong-sized resources. Unnecessary data transfer.

Best Practices 228

Best Practices Strategy Cloud AWS 228

Percona

MARCH 1, 2023

EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Adding ANALYSE causes the query to execute, and the numbers returned to report the real numbers of the query’s performance. Why Percona Server for MySQL? And Percona Server for MySQL is free.

Servers 120

Servers Open Source Tuning C++ 120

Scalegrid

AUGUST 26, 2020

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. ScaleGrid MySQL on Azure so you can see which provider offers the best throughput and latency performance.

Azure 299

Azure Benchmarking Database Latency 299

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 86

Servers Database Open Source Scalability 86

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. But the available manipulation was limited and often resulted in complicated logic.

Servers 122

Servers C++ Code Cache 122

DZone

MARCH 31, 2020

The true power of cloud computing lies in the way it can be optimized for maximum performance and efficiency. While it wasn’t always possible to run an efficient environment while maximizing performance with on-premise servers and data centers, cloud clusters are particularly flexible in this respect.

AWS 170

AWS Performance Efficiency Scalability 170

DZone

JANUARY 14, 2020

Find out more about client-side performance! Client-Side Performance Testing Importance and Introduction. If you're worried about the performance of your web application, you need to test and analyze not only with what happens on the server but also with what happens in the browser.

Performance Testing 130

Performance Testing Performance Testing Open Source 130

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. When undertaking any sort of performance optimisation work, one of the very first things we learn is that before you can improve performance you must first measure it. Browsers now even have performance audits built right in.

Servers 87

Servers Performance Metrics Database 87

SQL Shack

DECEMBER 12, 2023

This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed.

Monitoring 52

Monitoring Servers Speed Database 52

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

Dynatrace

MARCH 14, 2023

Amazon’s new general-purpose Linux for AWS is designed to provide a secure, stable, and high-performance execution environment to develop and run cloud applications. This is done by detecting availability and performance problems in real time across an entire technology stack while presenting teams with answers — not alert storms.

AWS 278

AWS Lambda Serverless Virtualization 278

Percona

FEBRUARY 27, 2023

The good news is we’ve got you covered with ARM64 container images for Percona Server for MongoDB 6. While it’s possible to run x86_64 images on an ARM-based Mac, it’s not the most efficient or performant way to do so. With the release of Percona Server for MongoDB 6.0.4, we’ve added native Docker container images for ARM64.

Servers 97

Servers AWS Architecture Efficiency 97

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience.

Servers 57

Servers Cache Retail Benchmarking 57

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Server for MongoDB 7.0.2-1 1 (Release Candidate) Percona Server for MongoDB 7.0.2-1

Servers 77

Servers Monitoring Open Source Scalability 77

Dynatrace

SEPTEMBER 5, 2023

Additionally, monitoring allows for proactive maintenance and optimization, leading to improved system performance and user experience. Database monitoring with topology context With Dynatrace, you can easily monitor the performance of your database layer, even in complex environments. What’s next?

Database 197

Database Metrics Monitoring Servers 197