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

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

DZone

MAY 31, 2022

A website needs to be constantly tested and optimized to be in line with Google's web and SEO guidelines. This article will learn about web performance testing and how Core Web Vitals plays a crucial and strategic part in it. What Is Web Performance Testing?

Performance Testing 244

Performance Testing Testing Performance Website Performance 244

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

SQL Shack

OCTOBER 7, 2020

In this article, we will learn how to use Apache JMeter to perform a load test on SQL Server. This test type enables us to measure the application behaviors under specific conditions so that it enables us to observe a variety of resource consumptions (CPU, memory, latency, response times, etc) and it also helps to […].

Servers 115

Servers Testing Performance Latency 115

DZone

MARCH 9, 2021

A framework is a collection or set of tools and processes that work together to support testing and developmental activities. It contains various utility libraries, reusable modules, test data setup, and other dependencies. We decided to dive deeper into PHP and find out what the best PHP testing frameworks are.

Testing 246

Testing Programming Website Efficiency 246

DZone

JUNE 28, 2023

Scalability testing is an approach to non-functional software testing that checks how well applications and infrastructure perform under increased or decreased workload conditions. The organization can optimize infrastructure costs and create the best user experience by determining server-side robustness and client-side degradation.

Best Practices 141

Best Practices Scalability Testing Infrastructure 141

DZone

SEPTEMBER 23, 2020

This time I would like to show my experience creating an End2End test for a Camel integration application that connects these layers: Apache Kafka. KIE server ( rules engine ). Apache ActiveMQ Artemis. PostgreSQL. Localstack ( AWS similar ). Red Hat Ingress upload service. Minio ( AWS similar ).

Testing 269

Testing AWS Servers Engineering 269

Dynatrace

DECEMBER 8, 2022

Rob Jahn, Dynatrace senior technical partner manager, and Andreas Grabner, Dynatrace DevOps activist discussed the role of platform engineers in the video “ Deploy, Test, Evaluate, Repeat : The Power of Webhooks for DevOps Platforms Engineers.” Open source automated browser and testing tool. Atlassian Jira.

DevOps 191

DevOps Engineering Testing Open Source 191

Percona

FEBRUARY 27, 2023

The transition to Apple Silicon (the M1, M2 ARM-based CPUs) has been great for macOS fans in many ways, but it’s added some friction when you want to run containers locally for testing or development. The good news is we’ve got you covered with ARM64 container images for Percona Server for MongoDB 6. Prefer working with Podman?

Servers 98

Servers AWS Architecture Efficiency 98

SQL Shack

JULY 28, 2020

In this article, we will learn how to test our storage subsystems performance using Diskspd. The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files.

Storage 82

Storage Servers Testing Engineering 82

The Netflix TechBlog

SEPTEMBER 22, 2021

Martin Tingley with Wenjing Zheng , Simon Ejdemyr , Stephanie Lane , and Colin McFarland This is the second post in a multi-part series on how Netflix uses A/B tests to inform decisions and continuously innovate on our products. An A/B test is a simple controlled experiment. Figure 2: A simple A/B test. Let’s say?—?this

Testing 245

Testing Entertainment Metrics Social Media 245

DZone

DECEMBER 30, 2020

Below are some of the key metrics that need to be monitored during performance testing: CPU utilization. Server page faults/second. Let's take a look at some of the causes of negative impacts on performance testing and some quick resolutions that will help smooth everything out. Heap memory utilization. Cache hit ratio.

Servers 133

Servers Performance Cache Performance Testing 133

Percona

MARCH 1, 2023

EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Add in INVISIBLE INDEXes, and you can test the efficiency of an index without risking a disastrous rebuild after a delete. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL.

Servers 121

Servers Open Source Tuning C++ 121

DZone

JANUARY 29, 2021

API Test is crucial for the software systems to function at high quality. It is mainly the channel that links the client to the server, drives business procedures, and gives the services which give worth to users. What is API Test? Every app you build nowadays completely relies on Application Programming Interfaces.

Testing 207

Testing Programming Performance Database 207

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. Check the replica.

Servers 90

Servers Virtualization Open Source Scalability 90

The Netflix TechBlog

MAY 4, 2023

This blog post will provide a detailed analysis of replay traffic testing, a versatile technique we have applied in the preliminary validation phase for multiple migration initiatives. In this testing strategy, we execute a copy (replay) of production traffic against a system’s existing and new versions to perform relevant validations.

Traffic 339

Traffic Latency Tuning Systems 339

DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. For a complex distributed application with several external dependencies there is nothing that can beat a full end-to-end test. Or is there?

Design 193

Design Testing Software Performance Database 193

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. Default database: 'test'.

Servers 160

Servers Database Processing Availability 160

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 75

Servers Database Testing Open Source 75

DZone

JANUARY 14, 2020

Client-Side Performance Testing Importance and Introduction. If you're worried about the performance of your web application, you need to test and analyze not only with what happens on the server but also with what happens in the browser. You may also like: Client-Side v/s Server-Side Rendering: What to Choose When?

Performance Testing 130

Performance Testing Performance Testing Open Source 130

DZone

SEPTEMBER 11, 2021

Take a simple client-server use case. But most of the time, there are some minor details every developer takes for granted, and the client-side and the server-side developer never discuss, and just a ssume. This assumption may be true at a given time, but can come back and bite us any day.

Testing 237

Testing Servers Development Code 237

Alex Podelko

AUGUST 18, 2019

Following up my post Are Times still Good for Load Testing? , First of all, integrating into agile development (shift-left / continuous performance testing) and integrating into performance information loop with production (shift-right) to form a holistic performance view. I decided to answer multiple comments here separately.

Performance Testing 243

Performance Testing Testing Performance Testing Tools 243

DZone

APRIL 28, 2022

REST (Representational State Transfer) is an architecture that consumes HTTP calls for inter-system communication where a client can access the server resource with a unique URI, and the response of the resource is returned.

Testing 130

Testing Java Architecture Servers 130

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. In our PC test the build started at 11:28:16 and ended at 11:30:27 meaning it took 2 minutes 11 seconds to build our 20 warehouse schema. With the default for v4.9 to have this feature enabled.

Servers 62

Servers C++ Benchmarking Virtualization 62

DZone

OCTOBER 6, 2023

Apache JMeter is an open-source, Java-based tool used for load and performance testing of various services, particularly web applications. JMeter can simulate heavy loads on a server to analyze performance under different conditions. JMeter also supports distributed testing, enabling it to handle multiple test threads simultaneously.

Java 255

Java Government Open Source Performance Testing 255

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 Virtualization Code Testing 62

Dynatrace

APRIL 23, 2024

The regulation covers areas like Information and Communication Technology (ICT) risk management, third-party risk, digital operational resilience testing, and reporting of major ICT-related incidents to competent authorities. When operational disruptions strike—whether it’s a rogue server or a cyberattack—Dynatrace services remain in harmony.

Tuning 243

Tuning Strategy Servers Technology 243

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 C++ Database Systems 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. and xtrabackup 2.4

Servers 108

Servers C++ Storage Systems 108

Testlodge

APRIL 14, 2021

Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. What is Configuration Testing? However, configuration testing is a time-consuming technique, so the team must create a workable plan. Types of Configuration Testing.

Testing 89

Testing Hardware Virtualization Operating System 89

Scalegrid

AUGUST 22, 2019

For test purposes, DCS can be installed on same nodes running PostgreSQL. High Availability Test Scenarios. We conducted a few tests on PostgreSQL HA management using Patroni. All of these tests were performed while the application was running and inserting data to the PostgreSQL database. Standby Server Tests.

Availability 277

Availability Servers Network Open Source 277

Tim Kadlec

JANUARY 12, 2021

Client-side A/B testing has been a performance loving developer’s worst friend for years. From a convenience perspective, running client-side tests is significantly easier to do than server-side testing. With server-side testing, you need developer resources to create different experiments.

Testing 137

Testing Google Traffic Servers 137

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. is out , I thought it might be time to do a bit of testing myself.

Servers 95

Servers C++ Testing Systems 95

Percona

DECEMBER 5, 2022

There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Servers 60

Servers Cache C++ Metrics 60

DZone

AUGUST 28, 2019

These days, our code frequently has to reach out to a remote server as part of its job, usually consuming an API or some other service. Introduction. Frequently, our code communicates with these remote services in a RESTful manner.

Code 223

Code Testing Servers Java 223

DZone

AUGUST 26, 2019

Functional testing isn’t something new. For example, we instruct the testing tool to navigate to the registration page, fill out the form and press the submit button. So we need the testing tool to read the email message, parse it and navigate the link. The first challenge is to connect the testing tool with the mail server.

Testing 100

Testing Testing Tools Servers Performance Testing 100