DZone

MAY 24, 2024

Let's visualize a situation where we are entrusted with the responsibility of protecting a Linux file server. This article is my endeavor to bridge this gap, to convert the abstract into the tangible and make the complex understandable. So, before you immerse yourself in this article, pause for a moment.

Servers 130

Servers Strategy Processing 130

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 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 242

Servers Java Virtualization Engineering 242

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

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 Database 274

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 Open Source Hardware Operating System 195

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.

Servers 246

Servers Database Systems Operating System 246

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

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

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 118

Servers Availability Architecture Software 118

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

DZone

OCTOBER 1, 2024

The introduction of software has made remarkable changes to how business is conducted. Back then," people would meet in person, and most companies used manual methods, which were not scalable. Software has changed the game, and web applications are essential for a business's success.

AWS 286

AWS Efficiency Games Servers 286

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 106

Availability Servers Database Open Source 106

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

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 128

Database Servers Testing Programming 128

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 88

Servers Software Software 88

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 103

Servers Database Cache C++ 103

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 99

Servers Processing Software Software 99

Percona

SEPTEMBER 13, 2024

The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties.

Servers 89

Servers Software Software 89

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

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 83

Servers AWS Software Software 83

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 89

Servers Database Open Source Scalability 89

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

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 123

Servers Open Source Tuning C++ 123

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

Percona

AUGUST 9, 2024

Upcoming releases of Percona Server for MongoDB extend that mechanism with the KMIP key state polling feature. Data-at-rest encryption (also known as transparent data encryption or TDE) is a necessary mechanism for ensuring the security of a DBMS deployment.

Servers 76

Servers Software Software 76

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 118

Servers Best Practices Database Open Source 118

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 109

AWS Servers Scalability Database 109

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 101

Servers AWS Architecture Efficiency 101

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 83

Database Servers Innovation Open Source 83

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

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

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 75

Innovation Servers Open Source Software 75