Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. How it Works.

Availability 147

Availability Servers Open Source Database 147

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements.

Availability 84

Availability Open Source Architecture Database 84

Percona

SEPTEMBER 19, 2023

It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. We plan to make Percona images for PostgreSQL available on Docker Hub shortly.

Availability 110

Availability Open Source Database Servers 110

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 98

Architecture Availability Open Source Healthcare 98

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

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.

Database 124

Database Servers Testing Programming 124

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 98

Servers Database Cache C++ 98

Dynatrace

DECEMBER 8, 2022

DevOps platform engineers are responsible for cloud platform availability and performance, as well as the efficiency of virtual bandwidth, routers, switches, virtual private networks, firewalls, and network management. Open source CI/CD pipeline tool with extensible server automation for distributed builds and scaling. Atlassian Jira.

DevOps 191

DevOps Engineering Testing Open Source 191

SQL Shack

SEPTEMBER 8, 2020

In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database. These environments can be development, stage, UAT (user acceptance testing). Requirement Suppose we have multiple database environments for a critical application.

Availability 52

Availability Database Servers Testing 52

Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 79

Availability Hardware Open Source Database 79

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

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 96

Servers AWS Architecture Efficiency 96

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 119

Servers Open Source Tuning C++ 119

SQL Shack

DECEMBER 14, 2020

In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups. You can configure multiple environments such as test, production, execute package, view progress and […].

Availability 60

Availability Servers Database Testing 60

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

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

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. Once node3 becomes available again, the virtual IP should come back to node3.

Servers 88

Servers Virtualization Open Source Scalability 88

Scalegrid

JULY 8, 2020

If you must kill the script at this point, there are two options available: SCRIPT KILL command can be used to stop a script that hasn’t yet done any writes. If the script has already performed writes to the server and must still be killed, use the SHUTDOWN NOSAVE to shutdown the server completely. 26379 @ test 172.31.2.48

Servers 239

Servers Database Availability Monitoring 239

Dynatrace

MARCH 14, 2023

Available directly from the AWS Marketplace , Dynatrace provides full-stack observability and AI to help IT teams optimize the resiliency of their cloud applications from the user experience down to the underlying operating system, infrastructure, and services. How does Dynatrace help?

AWS 281

AWS Lambda Serverless Virtualization 281

Percona

OCTOBER 16, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. This provides multiple benefits, including scalability, resource isolation, reduced load on the PMM server, customization, etc. Percona Server for MongoDB 7.0.2-1 Starting with PMM 2.40.0,

Servers 76

Servers Monitoring Open Source Scalability 76

Percona

OCTOBER 16, 2023

In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to test the extension and provide feedback either via the GitHub repository or in the forum. This is something that is available in other databases but not provided in upstream, vanilla Postgres. What is TDE? Debian 16.0-1.pgdg120+1))

Open Source 113

Open Source Testing Database Design 113

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 74

Servers Database Testing Open Source 74

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 84

Servers C++ Database Systems 84

Scalegrid

JULY 29, 2020

This is shared between all clients, so a pooled connection is available to all clients. High availability. PostgreSQL high availability is supported through Pgpool-II in-built watcher processes. Not supported – PgBouncer recommends use of HAProxy for high availability and load balancing. Performance Testing.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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?? OSDI’20. Please do join us if you can.

Servers 128

Servers Hardware Latency Design 128

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. Three distinct modes are available within MySQL when setting up your binary logs’ format.

Database 162

Database Strategy Servers Best Practices 162

Scalegrid

MARCH 23, 2020

It supports high-availability, provides automated load balancing, and has the intelligence to balance load between masters and slaves so write loads are always directed at masters, while read loads are directed to slaves. Once installed, we must configure Pgpool-II to enable the services we want, and connect to the PostgreSQL server.

Cache 264

Cache Servers Architecture Processing 264

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

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 105

Servers C++ Storage Systems 105

Testlodge

MARCH 15, 2023

White box testing is a software testing approach based on an analysis of the internal structure of the component or system. Why is White Box Testing Performed? Testers perform white box testing for several reasons. Suppose developers perform unit testing before delivering code to testers.

Testing 83

Testing Testing Tools Java Programming 83

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. I have also used the default six test scenarios as defined by the YCSB framework. I have restricted it to 10M records for each test.

Benchmarking 308

Benchmarking Latency C++ Database 308

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. These storage nodes collaborate to manage and disseminate the data across numerous servers spanning multiple data centers.

Storage 130

Storage Systems Big Data Azure 130

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 94

Servers Monitoring Cache Network 94

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

Testlodge

JUNE 16, 2021

Various standardized security methods are available. One such specialized technique is penetration testing, which aims to detect any loophole in the system through which an attacker can gain access and steal critical data, which ultimately causes businesses to suffer monetary losses and lose customers to competitors.

Testing 67

Testing Hardware Open Source Internet 67

Testsigma

SEPTEMBER 23, 2021

Cross-browser testing is performed to be sure that your product is working as expected on the various device, platform, and browser (and their versions) combinations that your customers might be using. However, the pain and efforts associated can be reduced, if the cross-browser testing is cloud-based. Reference: [link].

Cloud 96

Cloud Testing Infrastructure Internet 96

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. 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.

Servers 60

Servers Cache C++ Metrics 60