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

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 97

Servers Processing Software Software 97

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 100

Servers Database Cache C++ 100

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.

Servers 104

Servers Availability Database Scalability 104

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 186

Servers Database Availability Monitoring 186

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

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.

Servers 126

Servers Database Testing Open Source 126

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 219

Servers Monitoring Availability Code 219

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

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 116

Servers Database Performance Cache 116

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 195

Servers Monitoring Availability Programming 195

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 Code Database 142

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 121

Servers Open Source Tuning C++ 121

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 107

AWS Servers Scalability Database 107

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 98

Servers AWS Testing Architecture 98

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 Code C++ Cache 122

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 190

Servers Best Practices Monitoring Availability 190

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

Servers 73

Servers Innovation Open Source Software 73

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

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.

Servers 108

Servers Strategy Network 108

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.

Servers 81

Servers Database Innovation Open Source 81

Percona

OCTOBER 16, 2023

This provides multiple benefits, including scalability, resource isolation, reduced load on the PMM server, customization, etc. It is the most stable, scalable, and secure open-source MySQL distribution, with two download options: one based on Percona Server for MySQL and one based on Percona XtraDB Cluster. Starting with PMM 2.40.0,

Servers 78

Servers Monitoring Open Source Database 78

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 85

Servers Database Systems C++ 85

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 108

Servers Systems C++ Storage 108

Percona

FEBRUARY 24, 2023

We’re pleased to announce that Percona Server for MongoDB 6.0.4 release you can now run Percona Server for MongoDB 6 on RHEL 7, 8, and 9, as well as Debian 10 and 11, and Ubuntu 18.04, 20.04, and 22.04 You can also, of course, run Percona Server for MongoDB in a Docker container as well. With the 6.0.4

Servers 90

Servers Operating System Software Software 90

DZone

NOVEMBER 29, 2023

The Monolithic Challenge Imagine a scenario where you have a large-scale, monolithic system - possibly a bulky C# console application or an extensive SQL Server stored procedure. This system is tasked with performing reimbursement calculations, typically running overnight through a batch process scheduled in SQL Server.

Systems 283

Systems Servers Scalability Architecture 283

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

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 Code C++ Database 145

Percona Community

FEBRUARY 22, 2023

We will use Docker as a container engine tool and Percona Server for MySQL as a database administration tool. Percona Server for MySQL is a fork of MYSQL, providing much more advanced features. In this blog, we will explore databases on containers. Both are open source tools.

Database 89

Database Servers Open Source Engineering 89

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

DECEMBER 6, 2022

Percona Server for MySQL 8.0.30-22 22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. Because of this, using the simple plugin with an SSL connection between the MySQL server and client should be preferred over the SASL plugin where possible.

Servers 70

Servers Open Source Scalability Database 70

Addy Osmani

MAY 5, 2023

A summary of the state of React Server Components, Next.js App Router, rendering, examples and other related links and thoughts.

Servers 92

Servers 92

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

SQL Shack

OCTOBER 14, 2021

This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues. Introduction to SQL Server Extended Events(XEvent) The SQL Server Extended event (XEvent) is a lightweight tool to collect data for troubleshooting.

Servers 99

Servers Performance Monitoring 99

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. But what if your environment grows and you decide to distribute data between two Dynatrace servers?

Servers 155

Servers Tuning Systems Availability 155

SQL Shack

NOVEMBER 17, 2021

This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions. Introduction SQL Server extended events is a performance monitoring tool that has the ability to collect various event data of the SQL Server.

Servers 89

Servers Monitoring Performance 89

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. Summary The new Use BCP Option for SQL Server accelerates both TPROC-C and TPROC-H schema loads, so you can get to running your benchmarks faster. With the default for v4.9 to have this feature enabled.

Servers 62

Servers Database C++ Benchmarking 62