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

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

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 216

Efficiency Virtualization Hardware Performance 216

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 105

Availability Open Source Database Servers 105

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

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 235

Best Practices Strategy Cloud AWS 235

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 109

Servers Best Practices Database Open Source 109

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 102

Performance Monitoring Traffic Database 102

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

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 115

Servers Open Source Tuning C++ 115

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

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 81

Servers Database Open Source Scalability 81

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

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 283

AWS Lambda Serverless Virtualization 283

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 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

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

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 204

Database Metrics Monitoring Servers 204

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 91

Servers AWS Architecture Efficiency 91

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. As a result, the data inconsistency may go undetected.

Servers 160

Servers Database Processing Availability 160

Percona

JULY 24, 2023

To make sure that Percona Backup for MongoDB answers the pains of our customers, we took the common denominator of the pains that anyone using snapshot capabilities faces when performing backups and restores and positioned PBM as the open source, freely available answer to those pains. Now why Technical Preview, you may ask?

Availability 74

Availability Open Source Strategy Storage 74

Scalegrid

OCTOBER 2, 2019

This management solution for Redis™ allows startups up to enterprise-level organizations automate their Redis™ operations on Microsoft Azure dedicated cloud servers, alongside their other open source database deployments, including MongoDB , MySQL and PostgreSQL. PALO ALTO, Calif.,

Azure 100

Azure Availability Open Source Virtualization 100

Percona

JUNE 26, 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 MySQL 8.0.33-25 25 Percona Server for MySQL 8.0.33-25

Servers 69

Servers Open Source Scalability Database 69

Dynatrace

DECEMBER 9, 2020

Application servers use connection pools to maintain connections with the databases that they communicate with. Connection pools are also a great way to improve performance. New extensions enable AI-powered monitoring of connection pool performance. Automatically identify connection leaks in your application code.

Traffic 138

Traffic Performance Database Metrics 138

Dareboost

JANUARY 8, 2024

Comprehensive understanding of website monitoring Website monitoring is a critical component in today’s digital landscape, ensuring optimal website performance, availability, and functionality.

Website 52

Website Monitoring Performance Website Performance 52

Dynatrace

JUNE 5, 2023

The F5 BIG-IP Local Traffic Manager (LTM) is an application delivery controller (ADC) that ensures the availability, security, and optimal performance of network traffic flows. Business-critical applications typically rely on F5 for availability and success. It serves as a crucial component between applications and users.

Traffic 196

Traffic Virtualization Metrics Monitoring 196

SQL Shack

MAY 27, 2019

Introduction to SQL Server Statistics SQL Server Statistics are an essential part of query performance in SQL Server. They help the query optimizer to prepare a query plan using the distribution of values in participating rows. If we do not have updated statistics, it might lead to resource intensive query execution plan.

Servers 53

Servers Availability Performance 53

SQL Shack

NOVEMBER 23, 2021

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93

Servers Cache Availability Performance 93

The Netflix TechBlog

MAY 4, 2023

The first phase involves validating functional correctness, scalability, and performance concerns and ensuring the new systems’ resilience before the migration. These include Quality-of-Experience(QoE) measurements at the customer device level, Service-Level-Agreements (SLAs), and business-level Key-Performance-Indicators(KPIs).

Traffic 339

Traffic Latency Tuning Systems 339

Dynatrace

SEPTEMBER 22, 2021

This results in performance issues or even downtime that could easily be prevented. For self-managed OCP operators, it’s particularly important to understand the health and performance of the platform’s control plane. Issues with the control plane could leave the platform in an unpredictable and uncontrollable state.

Availability 171

Availability Best Practices Infrastructure Monitoring 171

Dynatrace

FEBRUARY 27, 2024

As business goals and technology efforts continue to converge, organizations need to ensure teams are performing to their full potential. When users encounter issues with applications or services, performance and productivity drop. Business considerations are now part of the security, operations, and development framework.

Best Practices 237

Best Practices Metrics AWS Innovation 237