Percona

JULY 15, 2024

We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red Hat Enterprise Linux (RHEL) 8/9 and Oracle Linux (OL) 8/9. The packages with the aarch64.rpm rpm extension can be found on Percona Software Downloads. The aarch64.rpm

Servers 115

Servers Availability Architecture Software 115

DZone

JANUARY 25, 2023

It uses the Docker Client and Docker Server to provide a seamless workflow. Docker can be used across various cloud, desktop, and server platforms. It is available for macOS, Windows, Linux Distributions, Windows Server 2016, AWS, Google Compute Platform, Azure, and IBM Cloud.

Servers 305

Servers Azure AWS Google 305

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. A classic solution for this problem is to deploy a binlog server – an intermediate proxy server that sits between the master and its slaves. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262

Servers Transportation Database Availability 262

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 312

Monitoring Servers Hardware Open Source 312

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. Standby Server Tests.

Availability 277

Availability Servers Network Testing 277

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

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

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

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 111

Availability Database Open Source Hardware 111

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

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

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

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

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 Monitoring Database Servers 90

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 254

Technology Technology Scalability Availability 254

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

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 147

Strategy Latency Availability Traffic 147

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

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

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 104

Availability Monitoring Open Source Traffic 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

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

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

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 86

Availability Open Source Architecture Database 86

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

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

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 100

Architecture Availability Open Source Hardware 100

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

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 254

Availability Hardware Latency Traffic 254