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. These APIs will be used to check the status of the app, insert data in the database and fetch and display the data from the database.

AWS 274

AWS Servers Internet Internet 274

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

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community.

Database 82

Database Servers Innovation Open Source 82

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

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

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

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 Open Source 277

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. In this article, we will explore options for a compressed backup of a TDE database. It uses the […].

Database 104

Database Availability Servers 104

Scalegrid

APRIL 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. MongoDB® Database. EC2 instances.

Azure 344

Azure AWS Database Latency 344

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.

Servers 65

Servers Availability Database Mobile 65

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

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

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. The specific requirements were as below.

Servers 67

Servers Availability Database 67

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

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

already address SNMP, WMI, SQL databases, and Prometheus technologies, serving the monitoring needs of hundreds of Dynatrace customers. address these limitations and brings new monitoring and analytical capabilities that weren’t available to Extensions 1.0: available, and more are in the pipeline. Extensions 2.0 Extensions 2.0

Technology 246

Technology Technology Scalability Availability 246

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.

Servers 57

Servers Availability Database 57

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

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 200

Infrastructure Database Monitoring Metrics 200

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. Requirement Suppose we have multiple database environments for a critical application. You might have configured the development database also in […].

Availability 52

Availability Database Servers Testing 52

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

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 Servers Processing 52

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

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

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

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

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 114

Availability Open Source Database Servers 114

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 88

Servers Database Open Source Scalability 88

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.

Availability 56

Availability Database Servers 56

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. Introduction Windows PowerShell is a scripting language that offers useful modules for database professionals (Developer and DBA).

Availability 87

Availability Servers Database Performance 87

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

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. It’s a nice thing to do, but first things first.

Servers 117

Servers Best Practices Database Open Source 117

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. Introduction Monitoring is an essential and critical aspect of database professionals. As you configure SQL Server Always On Availability Group for the […].

Availability 80

Availability Servers Monitoring Database 80

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. Introduction In the earlier articles, we saw that the SQL Server Always On Availability Group provides high availability and disaster recovery solution in SQL Server.

Availability 71

Availability Servers Database 71

SQL Shack

JULY 13, 2020

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

Servers 69

Servers Availability Database 69

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184