DZone

OCTOBER 9, 2022

Witness Server and Witness Directory are the most critical components of the Database Availability Group (DAG). DAG requires Witness Server or File Share Witness (FSW) and Directory to maintain the Quorum. In case of Witness Server failure, the Quorum is no longer maintained, leading to inconsistent DAG.

Servers 242

Servers Database Availability 242

DZone

SEPTEMBER 29, 2021

If you run several web servers in your organization or even public web servers on the internet, you need some kind of monitoring. If your servers go down for some reason, this may not be funny for your colleagues, customer, and even for yourself. For that reason, we use monitoring tools.

Monitoring 300

Monitoring Servers Hardware Open Source 300

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

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

FEBRUARY 25, 2023

We will show you exactly how to deploy a Nodejs app to the server using Docker containers, RDS Amazon Aurora, Nginx with HTTPS, and access it using the Domain Name. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database available on AWS. We will deploy a Nodejs app to the server, Nginx, and Certbot as Docker containers.

AWS 274

AWS Servers Internet Internet 274

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 105

Availability Database Open Source Hardware 105

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. Previously, to access data from […].

Servers 99

Servers Availability Virtualization Database 99

Dynatrace

NOVEMBER 3, 2023

address these limitations and brings new monitoring and analytical capabilities that weren’t available to Extensions 1.0: What’s available now and what’s coming later We’ve already started to migrate Dynatrace-developed Extensions 1.0 available, and more are in the pipeline. Extensions 2.0 to the Extension Framework 2.0.

Technology 246

Technology Technology Scalability Availability 246

SQL Shack

NOVEMBER 16, 2020

In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas. Introduction SQL Server Always On Availability Groups gives you the ability to safeguard the SQL databases and implements a solution for high-availability and disaster recovery.

Availability 122

Availability Servers Monitoring Database 122

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

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 98

Availability Monitoring Open Source Traffic 98

SQL Shack

FEBRUARY 8, 2021

In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas. Prerequisites You should follow articles in the series, SQL Server Always On Availability Groups and prepare the following environment.

Availability 92

Availability Servers 92

SQL Shack

OCTOBER 20, 2020

In this 33rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group. Introduction Database professionals’ primary role is to do proactive monitoring for ensuring system availability. You can use […].

Availability 107

Availability Monitoring Servers Database 107

SQL Shack

AUGUST 21, 2020

This is the 12th article in the series of SQL Server Always On Availability Groups. Introduction SQL Server 2016 provides a new feature Distributed Availability Group for disaster recovery purposes. It is a particular type of availability group that helps access the multiple failover clusters.

Availability 104

Availability Servers 104

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. But what happens when traffic bursts overwhelm your system? Queueing requests is a common solution, but what's the best approach: FIFO or LIFO?

Strategy 141

Strategy Latency Availability Traffic 141

SQL Shack

NOVEMBER 19, 2020

In this 37th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases.

Availability 90

Availability Database Monitoring Servers 90

SQL Shack

FEBRUARY 28, 2020

In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.

Availability 98

Availability Servers Database 98

SQL Shack

JANUARY 21, 2021

In this 40th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas. Introduction SQL Server Always On Availability Groups provides high availability and disaster recovery solution for SQL databases.

Availability 67

Availability Servers Database Monitoring 67

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 81

Availability Open Source Architecture Database 81

SQL Shack

AUGUST 28, 2020

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Introduction In the previous articles of SQL Server Always On series, we explored the following topics so far.

Availability 94

Availability Servers Virtualization Database 94

SQL Shack

SEPTEMBER 23, 2020

In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.

Availability 104

Availability Servers Network Processing 104

SQL Shack

OCTOBER 14, 2020

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances. A brief overview of SQL Server Patches It is a recommended practice to apply the regular update to the SQL Server with the service pack (SP) […].

Servers 86

Servers Availability Processing 86

SQL Shack

AUGUST 25, 2020

In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server always on availability group. It is available from Windows Server 2016 and SQL Server 2017.

Availability 76

Availability Servers 76

SQL Shack

AUGUST 26, 2020

In this 14th article of SQL Server Always On Availability Group series, we monitor and failover a distributed AG. Introduction We can implement a distributed availability group between multiple independent failover cluster nodes. In this article, we will […].

Availability 102

Availability Servers Monitoring 102

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

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 94

Architecture Availability Open Source Healthcare 94

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

SQL Shack

JULY 30, 2020

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable. By default, SQL Server […].

Availability 88

Availability Database Servers 88

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

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

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. We plan to make Percona images for PostgreSQL available on Docker Hub shortly.

Availability 106

Availability Open Source Database Servers 106

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. It automates tasks such as provisioning and scaling Dynatrace monitoring components, updating configurations, and ensuring the health and availability of the monitoring infrastructure.

Architecture 169

Architecture Availability Infrastructure Metrics 169

High Scalability

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.

Servers 187

Servers Programming Monitoring Availability 187

SQL Shack

OCTOBER 13, 2020

In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads. Introduction In a SQL Server Always On Availability Group, we configure two or more instances for high availability and disaster recovery.

Availability 93

Availability Servers Database 93

SQL Shack

MARCH 8, 2021

In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks. Introduction SQL Server Always On Availability Groups provides resilience for high availability and disaster recovery solution in a multi-node architecture.

Availability 75

Availability Servers Architecture Monitoring 75

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. Build three Virtual Servers with Windows Server […].

Availability 87

Availability Servers Virtualization Performance 87

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 246

Availability Hardware Latency Traffic 246