Scalegrid

AUGUST 22, 2019

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.

Availability 203

Availability Open Source Servers Network 203

The Morning Paper

FEBRUARY 25, 2020

Meaningful availability , Hauer et al., This very clearly written paper describes the Google G Suite team’s search for a meaningful availability metric: one that accurately reflected what their end users experienced, and that could be used by engineers to pinpoint issues and guide improvements. > > A good availability metric should be meaningful, proportional, and actionable. ‘five nines availability’). Making availability actionable.

Availability 87

Availability Metrics Google Systems 87

SQL Shack

JULY 6, 2020

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

Availability 87

Availability AWS Servers 87

SQL Shack

SEPTEMBER 29, 2020

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

Availability 56

Availability Database Servers 56

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 79

Availability Servers 79

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

Availability 112

Availability Servers Open Source Database 112

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

Availability 79

Availability Servers 79

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. Always On Availability Groups Transparent Data Encryption (TDE

Availability 79

Availability Virtualization Database Servers 79

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

Availability 79

Availability Network Processing Servers 79

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

Availability 67

Availability Virtualization Database Servers 67

High Scalability

APRIL 16, 2019

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.

Availability 170

Availability Open Source Network Database 170

SQL Shack

SEPTEMBER 8, 2020

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

Availability 52

Availability Database Development Testing 52

Scalegrid

JANUARY 8, 2019

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.

Availability 109

Availability Tuning Network Speed 109

SQL Shack

SEPTEMBER 11, 2020

In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes. As you configure SQL Server Always On Availability Group for the […].

Availability 74

Availability Database Monitoring Servers 74

SQL Shack

SEPTEMBER 16, 2020

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

Availability 73

Availability Database Servers 73

SQL Shack

SEPTEMBER 22, 2020

This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases. Always On Availability Groups Reporting Services (SSRS

Availability 64

Availability Mobile Servers Database 64

SQL Shack

AUGUST 31, 2020

This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs. Introduction Recently, I received a requirement to configure the SQL Replication for the availability group database.

Availability 76

Availability Servers Database 76

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. We’re therefore proud to announce Premium High Availability for Dynatrace Managed to address exactly this need in a completely turnkey manner without any external load balancing or replication technologies. Turnkey high availability across globally distributed data centers. Not available for offline clusters.

Availability 151

Availability Hardware Network Latency 151

Dynatrace

JULY 31, 2020

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. Cloud-based solutions typically aren’t a viable option or enterprises that have strict security or privacy policies that require their data to be maintained on-premise. Unlike other solutions on the market, Dynatrace has its own on-premise deployment model, known as Dynatrace Managed.

Cloud 168

Cloud Availability Azure AWS 168

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

Availability 73

Availability Monitoring Servers 73

Scalegrid

JANUARY 24, 2019

Redis Cluster is the native sharding implementation available within Redis, an open-source in-memory data structure project, that allows you to automatically shard across multiple Redis nodes without having to rely on external tools and utilities. This is available in addition to their Redis replica set solutions that make it easy to spread out your reads across multiple nodes. Some of the advanced benefits of Redis Clusters include: High Availability. PALO ALTO, Calif.,

Availability 101

Availability Open Source Scalability AWS 101

SQL Shack

MAY 27, 2019

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.

Availability 52

Availability Servers 52

Scalegrid

OCTOBER 2, 2019

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

Azure Availability Open Source Virtualization 100

Scalegrid

JUNE 9, 2020

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. This launch is in addition to their current DigitalOcean offering for MongoDB® database , the only DBaaS to support this database on DigitalOcean. MySQL and PostgreSQL are the top two open source relational databases in the world, and Redis is the top key-value database.

Availability 124

Availability Open Source Benchmarking Azure 124

SQL Shack

SEPTEMBER 1, 2020

In this 17h article of the SQL Server Always On Availability Group series, we are going to explore the SQL Server replication for the distribution database in the availability group. Always On Availability Groups Installation, setup and configuration Replication

Availability 66

Availability Servers Database 66

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

Availability 75

Availability Database Servers 75

SQL Shack

SEPTEMBER 4, 2020

In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group. Always On Availability Groups Installation, setup and configuration

Availability 64

Availability Database Servers 64

SQL Shack

SEPTEMBER 17, 2020

This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group. Always On Availability Groups

Availability 64

Availability Database Servers 64

SQL Shack

SEPTEMBER 21, 2020

In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. Introduction As we explored earlier, the database refresh for an availability group database requires a few […].

Availability 52

Availability Database Processing Servers 52

SQL Shack

JUNE 18, 2019

Introduction In SQL Server Always On Availability Groups, we can add a database into an existing availability group using different methods. Full Database and Log backup: It starts data synchronization by taking full and log backup for the availability group database. AlwaysOn Availability Groups High AvailabilityWe get the following option in the Initial Data Synchronization wizard in SSMS.

Availability 57

Availability Database Servers 57

SQL Shack

JULY 13, 2020

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. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations. AlwaysOn Availability Groups Clustering High Availability

Availability 58

Availability Virtualization Network Servers 58

SQL Shack

SEPTEMBER 7, 2020

In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group. Always On Availability Groups Installation, setup and configuration

Availability 56

Availability Database Servers 56

SQL Shack

JULY 13, 2020

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. AlwaysOn Availability Groups Clustering High AvailabilityWe use SQL Server 2019 for configuration.

Availability 56

Availability Database Servers 56

Dynatrace

JULY 31, 2020

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. The post Reporting at scale leveraging cross-environment dashboards (General Availability) appeared first on Dynatrace blog. Dynatrace news.

Availability 133

Availability Monitoring Best Practices AWS 133

SQL Shack

JUNE 18, 2019

In my previous article, Data synchronization in SQL Server Always On Availability Groups, we explored the internal data synchronization for both Asynchronous and Synchronous data commit mode. AlwaysOn Availability Groups High AvailabilityIn the following image, on the secondary replica, we can see two important processes. Log Receive: It receives the log records sent by the primary replica and writes […].

Availability 69

Availability Servers Processing 69

High Scalability

JANUARY 8, 2019

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.

Availability 168

Availability Storage Engineering 168

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. These availability group databases failover manually or automatically depending upon your AG configuration. AlwaysOn Availability Groups Installation, setup and configuration

Availability 60

Availability Database Servers 60

SQL Shack

JULY 14, 2020

This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups. Prerequisites In this series of articles, we will configure the SQL Server always on availability groups from end to end for your learning purpose. AlwaysOn Availability Groups Clustering High Availability

Storage 52

Storage Availability Servers 52

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. AlwaysOn Availability Groups Installation, setup and configurationWe performed the following steps at a high level. Build three Virtual Servers with Windows Server […].

Virtualization 62

Virtualization Availability Servers Performance 62

Dynatrace

DECEMBER 20, 2019

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.

Availability 161

Availability Monitoring Performance 161

SQL Shack

AUGUST 13, 2020

This article continues from the series on SQL Server Always On Availability Group. Introduction In the previous article, Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups, we learned the new capability in Windows Server 2016 to configure a domain-independent Windows failover cluster. […]. AlwaysOn Availability Groups Installation, setup and configuration

Availability 56

Availability Servers 56

SQL Shack

AUGUST 5, 2020

This is the 9th article in the series of SQL Server Always On Availability Groups. Introduction SQL Server Always On is a disaster and high availability feature. AlwaysOn Availability GroupsIn the previous articles, we explored the following features. AG failover in case of primary replica goes down Manual failover Database level health detection that initiates a failover […].

Availability 40

Availability Database Servers 40

SQL Shack

JULY 24, 2020

This article is a 6th article in the series for SQL Server Always On Availability Groups. AlwaysOn Availability Groups Installation, setup and configurationIt covers the configuration of the group managed service account (gMSA) for SQL Services. Introduction DBA uses services accounts to run the various SQL Services. Usually, we should use a separate service account for an individual server SQL Services. […].

Availability 57

Availability Servers 57