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

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 125

Servers Database Testing Open Source 125

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 187

Servers Database Availability Performance 187

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

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 120

Servers Open Source Tuning C++ 120

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 89

AWS Servers Scalability Database 89

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

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

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

Servers Systems C++ Storage 107

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

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 89

Servers Operating System Software Software 89

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 114

Servers Strategy Network 114

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

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 74

Servers 74

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 186

Servers Monitoring Availability Programming 186

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

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 72

Servers Open Source Scalability Database 72

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

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 105

Servers Processing Performance 105

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

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

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

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

NOVEMBER 23, 2021

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified. If a page is modified in […].

Servers 93

Servers Cache Availability Performance 93

Percona

DECEMBER 8, 2022

Percona Server for MySQL 8.0.30-22 The plugin works exactly the same as the MySQL Enterprise FIDO authentication plugin, which is documented in detail in the official MySQL documentation and in the Percona Server for MySQL documentation. 22 introduces a new authentication plugin, named authentication_fido.

Servers 65

Servers Hardware Testing Performance 65

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

DECEMBER 2, 2021

In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm.

Servers 90

Servers Performance 90

SQL Shack

DECEMBER 29, 2021

In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views. What is SQL Server tempdb used for? Tempdb is one of the system databases, that is used by many activities in SQL Server to temporarily store data. Such as when a […].

Servers 100

Servers Monitoring Database Systems 100

Percona

MARCH 13, 2023

Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 It is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database, and Percona Server for MySQL 5.7.41-44 Download Percona Server for MySQL 5.7.41-44 Percona Server for MongoDB 4.2.24-24

Servers 80

Servers Open Source Database Software 80

SQL Shack

FEBRUARY 17, 2021

In this article, we are going to talk about the modes of transactions in SQL Server. SQL Server can operate 3 different transactions modes and these are: […].

Servers 111

Servers Database Monitoring 111

SQL Shack

AUGUST 27, 2020

In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance. SQL Server […].

Tuning 114

Tuning Servers Performance Database 114

SQL Shack

OCTOBER 12, 2021

In this article, we will learn how to monitor SQL Server blocking issues with different methods. How does a blocking occur in SQL Server? SQL Server uses the lock mechanism to protect […]. In relational databases, numerous user transactions are processed concurrently.

Servers 79

Servers Monitoring Database Processing 79

Smashing Magazine

MAY 16, 2022

Rethinking Server-Timing As A Critical Monitoring Tool. Rethinking Server-Timing As A Critical Monitoring Tool. In the world of HTTP Headers, there is one header that I believe deserves more air-time and that is the Server-Timing header. Setting Server-Timing. Sean Roberts. 2022-05-16T10:00:00+00:00.

Servers 82

Servers Monitoring Cache Code 82

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. SQL Server PolyBase Introduction It is a new feature from SQL Server 2016 to query the relational and non-relational database using data virtualization techniques.

Servers 99

Servers Availability Database Virtualization 99

HammerDB

DECEMBER 14, 2022

In this post, we will do a walk through example of installing and configuring unixODBC and the SQL Server on Linux drivers as well as the HammerDB connection options to enable HammerDB on Linux to be able to connect to SQL Server. bin/odbcinst -d -q [ODBC Driver 17 for SQL Server] [ODBC Driver 18 for SQL Server].

Servers 62

Servers Code Testing Virtualization 62