Managing High Availability in PostgreSQL – Part III: Patroni

Scalegrid

In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your PostgreSQL hosting deployment. Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover. Managing High Availability in PostgreSQL – Part II: Replication Manager. Managing High Availability in #PostgreSQL – Part III: Patroni vs. PAF vs. repmgr Click To Tweet.

Meaningful availability

The Morning Paper

Meaningful availability , Hauer et al., > A good availability metric should be meaningful, proportional, and actionable. By "proportional" we mean that a change in the metric should be proportional to the change in user-perceived availability.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Managing High Availability in PostgreSQL – Part II

Scalegrid

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. Managing High Availability in #PostgreSQL – Part II: Open Source repmgr Tool Click To Tweet. High Availability Test Scenarios.

MySQL High Availability Framework Explained – Part III: Failover Scenarios

High Scalability

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. The Corosync and Pacemaker framework detects that the master MySQL is no longer available.

MySQL High Availability Framework Explained – Part II: Semisynchronous Replication

Scalegrid

In Part I , we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Semisynchronous replication, which is natively available in MySQL, helps the HA framework to ensure data consistency and redundancy for committed transactions. Let’s discuss some of the key MySQL settings used to ensure optimal behavior for high availability and data consistency in our framework.

Dynatrace Managed turnkey Premium High Availability for globally distributed data centers (Early Adopter)

Dynatrace

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.

Davis AI now detects infrastructure availability issues as root cause

Dynatrace

Having been named as a Leader in the 2020 Gartner APM Magic Quadrant for the 10 th consecutive time proves that Dynatrace is the best-of-breed application performance monitoring tool available. This capability eliminates the need for default trigger events for process availability issues.

Dynamic management views for monitoring availability replicas and databases for SQL Server Always On Availability Groups

SQL Shack

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

ScaleGrid Fully Managed Hosting for Redis™ Now Available on Azure

Scalegrid

It’s crucial for organizations to properly configure their Redis™ deployments for high availability and disaster recovery, as a couple minutes of downtime can be detrimental to a company’s security and reputation.”. ScaleGrid is the only cloud hosting service for Redis™ that allows you to customize your master-slave and cross-datacenter configurations for 100% uptime and availability across 30 different Azure regions. PALO ALTO, Calif.,

Azure 100

ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis™ Now Available

Scalegrid

PALO ALTO, Calif., June 9, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for their MySQL , PostgreSQL and Redis™ solutions on DigitalOcean.

Monitor SQL Server Always On Availability groups using extended events

SQL Shack

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.

Dynatrace Managed now available on all major cloud platforms

Dynatrace

Dynatrace Managed now available on the Google Cloud Platform. The post Dynatrace Managed now available on all major cloud platforms appeared first on Dynatrace blog. Dynatrace news.

MySQL High Availability Framework Explained – Part II

High Scalability

In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semisynchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup.

Session timeouts in SQL Server Always On Availability Groups

SQL Shack

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.

An overview of distributed SQL Server Always On Availability Groups

SQL Shack

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. AlwaysOn Availability Groups Installation, setup and configuration

Reporting at scale leveraging cross-environment dashboards (General Availability)

Dynatrace

We’re happy to announce the General Availability of cross-environment dashboarding capabilities (having released this functionality in an Early Adopter release with Dynatrace version 1.172 back in June 2019). Keep the token secret available for the second and final configuration step.

Configuring SQL Server Always On Availability Groups on AWS EC2

SQL Shack

In this article, we will review how to set up multi-subnet Always On Availability groups using AWS EC2 instances and AWS FSx as file share witness. AlwaysOn Availability Groups Clustering High Availability

Synchronize logins between Availability replicas in SQL Server Always On Availability Group

SQL Shack

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.

Transparent Data Encryption for SQL Server Always On Availability Groups

SQL Shack

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Always On Availability Groups Transparent Data Encryption (TDE

Explore dynamic management views for monitoring SQL Server Always On Availability Groups

SQL Shack

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. Always On Availability Groups Monitoring

Deploy a distributed SQL Server Always On Availability Group

SQL Shack

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.

SQL Server Always On Availability Groups Interview Questions & Answers

SQL Shack

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. AlwaysOn Availability Groups SQL interview questions

Read Scale Availability Group in a clusterless availability group

SQL Shack

In this article, we will explore configuring Read Scale Availability Group that does not require a failover clustering configuration. Introduction SQL Server Always On is a high availability and disaster recovery solution available starting from SQL Server 2012. AlwaysOn Availability Groups High AvailabilityIt helps to scale read-only connections to the secondary replica in a cluster less configuration.

Explore failover types in SQL Server Always On Availability Groups

SQL Shack

In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases. Always On Availability Groups Installation, setup and configuration

Suspend and Resume Data Movement in SQL Server Always On Availability Groups

SQL Shack

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. Always On Availability Groups

Article: Using the Plan-Do-Check-Act Framework to Produce Performant and Highly Available Systems

InfoQ Articles

The PDCA (plan-do-check-act) framework can be used to outline the performance, availability, and monitoring to enable teams to ensure performant and highly available applications.

Custom policies for AG dashboards of SQL Server Always On Availability Groups

SQL Shack

In this 35th article in SQL Server Always On Availability Groups, we will implement a custom policy for monitoring AG groups. Always On Availability Groups

Column-level SQL Server encryption with SQL Server Always On Availability Groups

SQL Shack

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Always On Availability Groups Security SQL Server 2019

Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups

SQL Shack

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. Always On Availability Groups PolyBase

Make the most of secondary replicas in SQL Server Always On Availability Groups

SQL Shack

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. Always On Availability Groups Transaction log

Monitor and failover a Distributed SQL Server Always On Availability Group

SQL Shack

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. AlwaysOn Availability Groups

Analyze all AWS data in minutes with Amazon CloudWatch Metric Streams available in Dynatrace

Dynatrace

Thanks to centralized configuration, near real-time availability of all services, and potential cost optimization, metric streaming is now the future of performance data distribution. Dynatrace news.

Start monitoring your web application’s availability with one click

Dynatrace

Availability monitoring —Is my application working 24 x 7? With the latest release of Dynatrace, we’ve made it super easy to start monitoring your application’s availability using synthetic monitors. Just select Monitor availability and you‘re done! Dynatrace news.

Backup compression in TDE enabled databases in SQL Server Always On Availability Groups

SQL Shack

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. Always On Availability Groups Backup and restore Transparent Data Encryption (TDE

Lease Timeouts and Health Checks in SQL Server Always On Availability Groups

SQL Shack

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.

Restore an existing availability group database participating in SQL Server Always On Availability Groups

SQL Shack

In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database. Always On Availability Groups Backup and restore

The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups

SQL Shack

In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s. It is available from SQL Server 2008 onwards. Always On Availability Groups

Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups

SQL Shack

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. AlwaysOn Availability Groups Clustering High Availability

Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups

SQL Shack

This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups. AlwaysOn Availability Groups Clustering High Availability

High Availability in Mule 4: Using Clusters

DZone

Mule Enterprise Edition supports scalable clustering to provide high availability (HA) for applications. High availability is essential for any organizations interested in protecting their business against the risk of a system outage, loss of transactional data, incomplete data, or message processing errors. For a business interested in being available at all times, HA clustering is a practical solution.

Configure SQL Server Always On Availability Groups using Windows PowerShell scripts

SQL Shack

In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it. Always On Availability Groups PowerShell

Configure a SQL Server Always On Availability Group on the domain-independent Failover Cluster

SQL Shack

This article continues from the series on SQL Server Always On Availability Group. AlwaysOn Availability Groups Installation, setup and configurationThis is the 11th article in this series.

A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016

SQL Shack

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases.