DZone

JANUARY 3, 2024

The Raspberry Pi is one example of a small, low-cost device that is embracing this idea, even though it has traditionally been associated with powerful servers and expensive computers.

Virtualization 321

Virtualization Education Media Hardware 321

DZone

NOVEMBER 29, 2023

As I mentioned in my previous article Part 1 , let's explore how such a transition can be effectively managed. 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.

Systems 299

Systems C++ Scalability Architecture 299

DZone

MAY 24, 2024

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

Servers 130

Servers Strategy Processing 130

DZone

FEBRUARY 15, 2023

In this article, I’m going to demonstrate how you can migrate a comprehensive web application from MySQL to YugabyteDB using the open-source data migration engine YugabyteDB Voyager. Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters.

Open Source 298

Open Source Scalability Database Servers 298

InfoQ

MAY 14, 2024

Building reliable stateful services at scale isn’t a matter of building reliability into the servers, the clients, or the APIs in isolation. By combining smart and meaningful choices for each of these three components, we can build massively scalable, SLO-compliant stateful services at Netflix. By Joseph Lynch

Systems 109

Systems Scalability Servers Design 109

DZone

MARCH 17, 2021

You might have seen many articles on the internet regarding Nginx and how we can use Nginx for load balancing and reverse proxy. In this article, I would like to share my experience of setting up Nginx for load balancing and reverse proxy with SSL termination in Nginx. The reverse proxy relays the results from servers to the client.

Internet 261

Internet Internet Servers Processing 261

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. In this article, I focus on the distinct predicate and the approximate percentile functions. The DATETRUNC function. So far so good.

Servers 142

Servers Testing C++ Code 142

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. This article will focus on how to set up an internal CA for your organization.

Servers 130

Servers Database Systems 130

DZone

SEPTEMBER 25, 2023

It is the second of a series of articles that is built on top of that project, representing experiments with various statistical and machine learning models, data pipelines implemented using existing DAG tools, and storage services, both cloud-based and alternative on-premises solutions.

Storage 264

Storage AWS Architecture Cloud 264

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 157

Servers Tuning Systems Availability 157

DZone

APRIL 30, 2020

Following on my previous article. Run your own Video Conference Service with Jitsi , I started looking for a reliable solution to monitor my instance that runs Jitsi. I needed basic information on RAM, CPU, Disk, Networking, and I/O to assess the performance bottleneck for the serve.

Monitoring 165

Monitoring Servers Open Source Hardware 165

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements.

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

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, Author & founder of BangDB. About YCSB. YugabyteDB:2.5.0,

Benchmarking 308

Benchmarking Latency C++ Database 308

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

Dynatrace

APRIL 14, 2022

Further, the report lists Tomcat as the most popular Java application server. Figure 2: Spring Controller that maps the DemoObject to requests received at the server. In particular, CVE-2022-22965 affects applications running on an Apache Tomcat server as a web application archive (WAR) deployment. DIRECTORY_OF_CHOICE.

Java 228

Java Servers Code Open Source 228

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

Scalegrid

MAY 13, 2020

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. Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

DZone

APRIL 21, 2023

In this article, I explain how to provide Okta authentication to your web application hosted on a JBoss EAP 6.4.x In this example, we provide authentication to internal users (who are logged in in the customer network) and external users (from the internet) who may be third-party collaborators such as carriers, partners, etc.

Internet 238

Internet Internet Network Servers 238

DZone

OCTOBER 24, 2021

I remember when.Net originally came out some 20 years ago and Microsoft had created a website called "pet shop" or something, where they were able to "prove" that.Net and SQL Server was faster than the Java and Oracle equivalent. Watch me run you through the code below.

Benchmarking 264

Benchmarking Best Practices Java Website 264

DZone

OCTOBER 11, 2024

With the rapid development of Internet technology, server-side architectures have become increasingly complex. Therefore, real online traffic is crucial for server-side testing. This article provides a brief introduction to how TCPCopy works, with the hope of assisting readers.

Traffic 182

Traffic Open Source Internet Internet 182

SQL Shack

NOVEMBER 16, 2020

In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas. Introduction SQL Server Always On Availability Groups gives you the ability to safeguard the SQL databases and implements a solution for high-availability and disaster recovery.

Availability 122

Availability Servers Monitoring Database 122

DZone

NOVEMBER 22, 2022

This is an article from DZone's 2022 Performance and Site Reliability Trend Report. Site reliability engineering aims to keep servers and services running with zero downtime. For more: Read the Report. However, outages and incidents are inevitable, especially when dealing with a complex system that constantly gets new updates.

Servers 240

Servers Engineering Processing Systems 240

Scalegrid

APRIL 28, 2020

In this article, we are going to compare three of the most popular cloud providers, AWS vs. Azure vs. DigitalOcean for their database hosting costs for MongoDB® database to help you decide which cloud is best for your business. See performance tests to determine the impact of the Meltdown CPU kernel patch on your MongoDB servers.

Azure 344

Azure AWS Database Latency 344

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. Querying the current session’s state of session options with the @@OPTIONS function.

Servers 122

Servers C++ Code Cache 122

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) In this article, we’re going to take a look at how logging can help you make sense of your log data without much effort. Though it can feel like more trouble than it’s worth, sorting through logs is crucial.

Best Practices 255

Best Practices Analytics Network Infrastructure 255

DZone

MAY 31, 2022

This article will learn about web performance testing and how Core Web Vitals plays a crucial and strategic part in it. Web performance testing is executed, so that accurate information is provided on the application's readiness by monitoring the server-side application and testing the website. What Is Web Performance Testing?

Performance Testing 244

Performance Testing Testing Performance Website Performance 244

DZone

MAY 8, 2023

In other words, a single API request from a client can be turned into multiple API requests to a set of backend servers, and the responses are aggregated into a single response to the client. It can significantly reduce the number of round trips between the client and server.

Processing 214

Processing Servers Development Performance 214

DZone

MAY 30, 2023

In this article, we will create a custom plugin for Apache APISIX API Gateway to handle client requests that should be called in sequence. It is similar to batch request processing where you group multiple API requests into a single request and send them to the server as a batch. What Is a Chaining API Request, and Why Do We Need It?

Website 236

Website Servers Software Software 236

Scalegrid

SEPTEMBER 5, 2024

If the primary server encounters issues, operations are smoothly transitioned to a standby server with minimal interruption. This article showcases essential elements and techniques for achieving automatic failover within your PostgreSQL environment. Standby servers are activated when the primary server fails.

Availability 257

Availability Servers Database Open Source 257

SQL Shack

AUGUST 27, 2021

This article explores Persist sampling rate feature for automatic SQL Server statistics update. Introduction DBA should always focus on the optimal database performance as it is directly related to the application’s performance. Indexes help DBA to optimize queries based on the user data requirements. […].

Servers 109

Servers Database Monitoring Performance 109

DZone

JANUARY 31, 2020

In today's article, I'm going to discuss common principles that need to be followed if we want to build a scalable application that can handle thousands of connections. I will refer to Netty Framework, TCP and Socket internals and some useful tools if you want to get some insights from your application and underlying system.

Java 352

Java Scalability Network Monitoring 352

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

CSS Wizardry

MAY 31, 2019

A classic example is jQuery, that we might link to like so: There are a number of perceived benefits to doing this, but my aim later in this article is to either debunk these claims, or show how other costs vastly outweigh them. I won’t go into too much detail in this post, because I have a whole article. It’s convenient.

Cache 275

Cache Latency Infrastructure Website 275

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 119

Servers Best Practices Database Open Source 119

CSS Wizardry

JUNE 30, 2023

Honestly, I started writing this article, for no real reason and somewhat without context, in December 2022—over half a year ago! TTFB is a good measure of your server response times and general back-end health, and issues here may have knock-on effects later down the line (namely with Largest Contentful Paint). log ( window.

Metrics 330

Metrics Google Monitoring Code 330

DZone

FEBRUARY 9, 2023

In this article, we will look at gRPC and REST client-server architectures for communication and compare their strengths and weaknesses and the factors you should consider to make the right choice. The popular client-server architecture divides communication into two parts: REST or gRPC, which should you choose?

Architecture 180

Architecture Servers 180