DZone

FEBRUARY 15, 2024

When it comes to Java web servers, Apache Tomcat remains a strong favorite. Red Hat JBoss Web Server (JWS) combines the servlet engine (Apache Tomcat) with the web server (Apache HTTPD), and modules for load balancing (mod_jk and mod_cluster).

Servers 251

Servers Java Virtualization Engineering 251

DZone

DECEMBER 11, 2023

NTP servers, which manage the Network Time Protocol, are essential in achieving this. This article delves into the significance of NTP servers, their functionality, and the impact they have on the seamless functioning of our digital age.

Network 173

Network Servers Systems 173

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. We will deploy a Nodejs app to the server, Nginx, and Certbot as Docker containers. Hence, here we are to help you with the steps to deploy a Nodejs app to AWS.

AWS 274

AWS Servers Internet Internet 274

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 104

Servers Availability Architecture Software 104

DZone

APRIL 19, 2023

As you know, the SQL Server on Linux is becoming mature and easy to use. Still, it does not support MMC consoles in Linux which makes the administration of the SQL Server a little bit complicated. In this article, I will explain how we can move the system databases to different locations in Ubuntu Linux.

Database 246

Database Servers Systems Operating System 246

DZone

JANUARY 25, 2023

Linux could be a fantastic choice for your next cloud server. Although connecting to a server just using a single line command, you are keeping it secure could be a bit tricky. Although connecting to a server just using a single line command, you are keeping it secure could be a bit tricky.

Servers 195

Servers Hardware Open Source Operating System 195

DZone

MARCH 4, 2023

In any organization, it is a best security practice to have an SSL certificate installed on servers, applications, and databases. SSL Certificates and CA make communication secure between client and server or application. We will use a Windows server for it. You can use any number of SSL certificates free of cost.

Servers 130

Servers Database Systems 130

Percona

JULY 17, 2024

In the previously posted blog, Compaction in Percona Server for MongoDB (PSMDB), we discussed how compact works before version 4.4. In this blog, we will see how compact works on PSMDB 6.0. I recommend reading the blog post linked above to understand what compact does, how to check dataSize, and how much space we can […]

Servers 77

Servers Software Software 77

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

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

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 247

Servers Best Practices Efficiency Availability 247

Addy Osmani

DECEMBER 21, 2020

React Server Components aim to enable modern UX with a server-driven mental model. In this post I will share some notes I took while catching up on the latest RFC and talk around this work.

Servers 145

Servers 145

Percona

OCTOBER 10, 2023

Why choose Percona Server for MongoDB? The difference between Percona Server for MongoDB and MongoDB CE is that we strive to provide a gap-closing set of features for users who want to use MongoDB in production. Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

Availability 92

Availability Servers Database Open Source 92

Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 118

Database Servers Testing Programming 118

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142

Servers Testing C++ Code 142

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 90

Servers Database Cache C++ 90

Percona

MARCH 27, 2024

Percona Server for MongoDB currently has several external authentication options, such as LDAP with SASL, LDAP, Kerberos, and AWS IAM. What is amazing is that SASL can authenticate with Pluggable Authentication Modules (PAM) too.

Servers 75

Servers AWS Software Software 75

Percona

NOVEMBER 8, 2023

39 , Percona XtraBackup (PXB) allows a backup on server version 8.0.35 We have removed the server version check because the MySQL 8.0 To ensure a valid backup, use a PXB version equal to or higher than your source server version. added the no-server-version-check option. added the no-server-version-check option.

Servers 86

Servers Processing Software Software 86

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

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. Instead, starting with SQL Server 2022 you simply use the SET_BIT function.

Servers 122

Servers C++ Code Cache 122

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 78

Servers Database Open Source Scalability 78

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements. STRING_SPLIT.

Servers 145

Servers C++ Code Database 145

SQL Shack

AUGUST 27, 2021

In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples. Getting Started with SQL Server statistics SQL Server statistics are one of the key inputs for the query optimizer during generating a query plan.

Servers 109

Servers Processing Performance 109

Dynatrace

JULY 19, 2024

Dynatrace does this by automatically creating a dependency map of your IT ecosystem, pinpointing the technologies in your stack and how they interact with each other, including servers, processes, application services, and web applications across data centers and multicloud environments. It is as if the server is turned off.

Airlines 295

Airlines Retail Servers Monitoring 295

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

DZone

NOVEMBER 15, 2022

Ransomware attacks on on-premises Exchange Servers are quite common as they store sensitive and confidential information and business data. Even if attackers do not succeed in encrypting the data, they may leave a backdoor or cause other damage that can leave your server unusable or cause permanent data loss.

Strategy 113

Strategy Servers Network 113

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. Percona plans As you read this on the Percona Blog, you may be interested in Percona’s plan for Percona Server for MySQL regarding announced changes.

Database 78

Database Servers Innovation Open Source 78

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 105

Servers Best Practices Database Open Source 105

Percona

MARCH 1, 2023

EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL? That more is enterprise server features that you would have to pay Oracle extra to obtain.

Servers 111

Servers Open Source Tuning C++ 111

SQL Shack

AUGUST 23, 2021

In this article, we will go through some details about SQL Server statistics. The first step into SQL Server statistics The query plan is a set of instructions that describes how a query will be executed by the database engine. The query plans are created by the query optimizer in SQL Server and it requires […].

Servers 109

Servers Database Engineering Performance 109

Percona

JULY 27, 2023

The key word is “drop-in,” which means that over the years, we have made an effort to keep Percona Server for MySQL fully compatible with its upstream counterpart from Oracle. Learn more about Percona Server for MySQL

Innovation 70

Innovation Servers Open Source Software 70

InfoQ

JANUARY 26, 2024

Discord optimized its platform to serve over one million online users in a single server while maintaining a responsive user experience.

Servers 104

Servers Tuning Scalability Performance 104

Percona

APRIL 28, 2023

Did you notice that Percona Server for MongoDB 6.0.5-4 One key to rule them all — improvements to master key rotation With the improvements introduced in Percona Server for MongoDB 6.0.5-4, 4, one key path can be used for all servers in a clustered environment. Changes introduced with Percona Server for MongoDB 6.0.5-4

AWS 95

AWS Servers Scalability Database 95

Percona

FEBRUARY 27, 2023

The good news is we’ve got you covered with ARM64 container images for Percona Server for MongoDB 6. With the release of Percona Server for MongoDB 6.0.4, Just replace docker with podman: $ podman run -d --name psmdb --restart always percona/percona-server-mongodb:6.0.4-3-arm64 3-arm64 Note that you’ll want to replace 6.0.4-3-arm64

Servers 88

Servers AWS Architecture Efficiency 88

Percona

MARCH 26, 2024

This aids in getting some useful information related to [configured alerts] directly via querying from the Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to another for some […]

Monitoring 80

Monitoring Servers Database Cloud 80

SQL Shack

AUGUST 17, 2021

This article intends to give information about the SQL Server filtered indexes and their performance impacts. Introduction Indexes are the special data structures that help to improve the performance of the queries in SQL Server.

Servers 110

Servers Performance 110