Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 269

Database Artificial Intelligence Metrics Monitoring 269

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

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

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 94

Servers Database Cache C++ 94

Scalegrid

MARCH 4, 2019

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. SQL Databases.

Database 255

Database Metrics Systems Strategy 255

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

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

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 77

Database Servers Innovation Open Source 77

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

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs.

Database 130

Database Cloud Hardware Storage 130

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

Percona

DECEMBER 21, 2023

The integration of those projects, plus the years of Percona expertise in the database space, makes PMM one of the best database monitoring solutions on the market. Being software composed of different, multiple technologies can add complexity to a well-known concept: High Availability (HA). With this, the easy part is done.

Availability 98

Availability Monitoring Open Source Traffic 98

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

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

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

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. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 81

Availability Open Source Architecture Database 81

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

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. They’re proven and ready-to-go.

Architecture 94

Architecture Availability Open Source Healthcare 94

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 199

Infrastructure Database Monitoring Metrics 199

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

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

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

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

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

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 77

Availability Hardware Open Source Database 77