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 117

Servers Best Practices Database Open Source 117

Percona

FEBRUARY 2, 2023

The authentication process is typically accomplished through usernames and passwords and includes other factors such as security tokens and one-time passwords. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 127

Database Servers Testing Programming 127

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

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. You will soon have a healthy slave running again!

Servers 160

Servers Database Processing Availability 160

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

KeyCDN

FEBRUARY 13, 2020

Push Zones are now seamlessly supporting Image Processing ! This allows global image hosting without having the images hosted on another origin server. The complete feature set of Image Processing is now also available for Push Zones. No commitment: Scale up and down anytime and only pay for the images processed.

Processing 78

Processing Storage Latency Servers 78

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. The only value currently accepted is GroupReplication.

Servers 91

Servers Virtualization Open Source Scalability 91

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. Setting up curl (7.74.0-1.3+deb11u7).

Servers 87

Servers C++ Database Systems 87

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 C++ Storage Systems 108

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 92

Servers Monitoring Cache Network 92

DZone

AUGUST 16, 2023

Caching is the process of storing frequently accessed data or resources in a temporary storage location, such as memory or disk, to improve retrieval speed and reduce the need for repetitive processing.

Cache 246

Cache Scalability Performance Latency 246

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 286

Systems C++ Scalability Architecture 286

SQL Server According to Bob

JULY 17, 2018

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The parent process handles basic configuration activities and then forks the child process.

Servers 40

Servers Processing Software Engineering Traffic 40

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? In relational databases, numerous user transactions are processed concurrently. SQL Server uses the lock mechanism to protect […].

Servers 79

Servers Monitoring Database Processing 79

Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. By harnessing MySQL’s binary logging feature, every event is recorded in real-time.

Database 162

Database Strategy Servers Best Practices 162

SQL Shack

SEPTEMBER 28, 2020

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107

Servers Programming Code Software 107

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 76

Servers Database Testing Open Source 76

Dynatrace

MARCH 18, 2024

Are there rogue servers running in the environment where ITOps, CloudOps, or another team can’t assign or identify who’s financially responsible for it? An organization can ask Dynatrace, “Have you seen any oversized servers over X amount of time?” ” But Dynatrace goes further.

Best Practices 228

Best Practices Strategy Cloud AWS 228

The Morning Paper

NOVEMBER 15, 2020

Achieving 100 Gbps intrusion prevention on a single server , Zhao et al., Today’s paper choice is a wonderful example of pushing the state of the art on a single server. Moreover, Pigasus wants to do all this on a single server! Can you really do all this on a single server?? The reassembler: processing fast and slow.

Servers 128

Servers Hardware Latency Design 128

SQL Shack

OCTOBER 6, 2021

This article explains the internals of the Ghost cleanup task for SQL Server Databases. Introduction Each relational database consists of the background process and user processes.Similarly, SQL Server has many internal processes such as Checkpoint, Lazy Writer, Lock Monitor, System_Health_Monitor, Trace Queue Task and Ghost CleanUp.

Database 83

Database Servers Monitoring Processing 83

The Morning Paper

FEBRUARY 20, 2020

Extending relational query processing with ML inference , Karanasos, CIDR’10. The vision is that data scientists use their favourite ML framework to construct a model, which together with any data pre-processing steps and library dependencies forms a model pipeline. Static analysis and the IR. " Query execution.

Processing 72

Processing Hardware Database Azure 72

SQL Shack

APRIL 5, 2021

This article intends to give some details about the query optimization process in SQL Server. The reason for this problem is query optimization processes are a bit complicated and puzzling. In this context, understanding […].

Servers 97

Servers Database Processing Performance 97

DZone

JULY 31, 2019

In the web hosting service industry, it is commonly used for balancing the HTTP traffic across multiple servers which act together as a web front-end. A Load Balancer allows the users to distribute the traffic to a single IP across several servers by using a set of different protocols. How Does a Load Balancer Work?

Servers 109

Servers Traffic Virtualization Infrastructure 109

SQL Shack

OCTOBER 14, 2020

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances. A brief overview of SQL Server Patches It is a recommended practice to apply the regular update to the SQL Server with the service pack (SP) […].

Servers 86

Servers Availability Processing 86

DZone

FEBRUARY 23, 2023

Containerization simplifies the software development process because it eliminates dealing with dependencies and working with specific hardware. You could certainly deploy these containers to servers on your cloud provider using Infrastructure as a Service (IaaS). But, it can be quite confusing how to run a container on the cloud.

Cloud 354

Cloud Lambda Azure AWS 354

SQL Shack

DECEMBER 10, 2020

The SQL Server execution plan (query plan) is a set of instructions that describes which process steps are performed while a query is executed by the database engine. The query plans are generated by the query optimizer and its essential goal is to generate the most efficient (optimum) and economical query plan.

Servers 109

Servers Efficiency Database Engineering 109

Dynatrace

APRIL 23, 2024

When operational disruptions strike—whether it’s a rogue server or a cyberattack—Dynatrace services remain in harmony. Imagine a dashboard that whispers, “Hey, there’s a vulnerability brewing in Server Room B.” Business continuity : We don’t just draft continuity plans; we live them. The show must go on.

Tuning 239

Tuning Strategy Servers Technology 239

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache 264

Cache Servers Architecture Processing 264

DZone

NOVEMBER 2, 2023

It’s an underlying web application architecture that makes this process possible. It defines how the data is delivered through HTTP and ensures that the client-side server and the backend server can understand. Have you ever wondered how computers retrieve this information and what happens in the background?

Architecture 262

Architecture Mobile Website Servers 262

SQL Shack

APRIL 19, 2021

In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it. SQL Server is a common platform for enterprise-grade database workloads.

Tuning 70

Tuning Servers Performance Database 70

O'Reilly

NOVEMBER 21, 2019

This is precisely the kind of problem that robotic process automation (RPA) aims to address. She’s the vestigial human link in a process—insurance claims processing—that has a mostly automated workflow. Prior to RPA, enterprises used several different techniques to automate workflows and back-office processes.

Processing 83

Processing Programming Virtualization Technology 83

SQL Shack

APRIL 7, 2020

This article explains the deadlock definition in SQL Server, and it also mentions how to capture deadlock with extended events. Deadlock is a resource contention issue that occurs between two or more than two processes. Deadlock Definition Deadlock occurs when two processes want […].

Servers 93

Servers Processing Performance 93

SQL Shack

SEPTEMBER 29, 2020

In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server. OLTP (Online Transaction Processing) databases should process a huge number of transactions within the shortest time and concurrently.

Servers 98

Servers Performance Database Processing 98

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

DZone

FEBRUARY 26, 2024

One of its core principles is statelessness, which means that each request from a client to a server must contain all the information needed to understand and process the request. This model stands in contrast to stateful approaches, where the server stores user session data between requests.

Best Practices 152

Best Practices Architecture Servers Processing 152

Particular Software

JULY 12, 2021

In your back-end system, you might benefit from event-driven architecture, automatic message retries, and orchestration of long-running business processes. Ideally, a message receiver could process an incoming message without requiring any specific header. On the.NET side, we can use NServiceBus to process the message.

Processing 52

Processing Transportation Azure C++ 52

Percona Community

MARCH 16, 2023

I’m developing an application that takes data from different sources, processes it, and prepares reports. About the application and choice of tools The application I develop gets data from GitHub, Jira, and websites via API, processes it and creates reports according to the desired requirements.

Servers 63

Servers Development Website Database 63