Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 90

Open Source Database Hardware Strategy 90

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 103

Database Benchmarking Latency C++ 103

Percona

JANUARY 29, 2024

PostgreSQL differs from certain other databases as it lacks a native solution to encrypt data on disk transparently. At Percona, we are in the process of developing PG_TDE, a tool designed to encrypt data using the AES-CTR encryption algorithm.

Testing 91

Testing Database Design Code 91

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read. Requirements.

Database 106

Database AWS Network Design 106

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 110

Open Source Database Software Software 110

Percona

OCTOBER 16, 2023

This software is under active development and at a very early stage of design and implementation. 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. What is TDE? Debian 16.0-1.pgdg120+1))

Open Source 110

Open Source Testing Database Design 110

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Linux native Input/Output (I/O) statistics Pipe viewer utility By following these approaches, we can effectively monitor the restoration process and manage your MySQL database restoration efficiently.

Database 80

Database Monitoring C++ Speed 80

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

Percona

AUGUST 9, 2023

This upgrade has vastly improved the management and storage of metadata, resulting in better reliability and scalability for various database objects. The primary goal of the Transaction Data Dictionary (TDD) is to enhance the overall performance, stability, and scalability of MySQL databases. In MySQL 5.7,

Database 75

Database Storage Scalability Games 75

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 83

Scalability Database Open Source Traffic 83

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources. To observe model drift and accuracy, companies can use holdout evaluation sets for comparison to model data.

Cache 206

Cache Azure Infrastructure Monitoring 206

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. We randomly pick a record (id = 245) from a table as a subject to describe the test case. Every database object has a pre-defined format.

Database 116

Database Hardware Storage Programming 116

Dynatrace

APRIL 30, 2021

As organizations develop more applications and microservices, they are discovering they also need to run more performance tests in the same amount of time or less to meet service-level objectives (SLOs) that fulfill service-level agreements (SLAs). How can organizations address this process bottleneck and run more tests in less time?

Engineering 202

Engineering Testing Performance Performance Testing 202

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 used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions.

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Testlodge

JULY 19, 2023

SOX compliance testing validates changes made to code and verifies adherence to internal controls. Testers are responsible for testing code changes to ensure accuracy. The overall intention of SOX testing is to protect stakeholders and other investors from corporate fraud. The first step in SOX compliance is test planning.

Testing 81

Testing Energy Programming Government 81

Alex Podelko

SEPTEMBER 8, 2020

Some time ago Federico Toledo published Performance Testing with Open Source Tools- Busting The Myths. I remember really liking the technical side of these tests. But I must confess I was not too fond of having to report the results to stakeholders or deal with political/personal issues related to (poor) test results.

Open Source 223

Open Source Performance Testing Testing Performance 223

Testlodge

APRIL 14, 2021

A software tester’s work life includes making sure that systems that have been designed to achieve specific results behave exactly as they should. 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?

Testing 89

Testing Hardware Virtualization Operating System 89

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. Most times, these are Greenfield projects where the bulk of the effort is on its design and architecture. Database migration, a POC in action Objective Perform a database migration from MySQL to PostgreSQL.

Open Source 119

Open Source Database Architecture Design 119

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Dynatrace

APRIL 10, 2023

” Uninterrupted testing and multicloud observability Cluster monitoring also helped the company avoid performance issues during the A/B testing it conducted to evaluate the user experience. Such testing is critical to identifying customer shopping patterns that inform decisions about application design and user experience.

Cloud 173

Cloud Ecommerce Performance Retail 173

Dynatrace

JULY 7, 2022

It’s easy to see why, with benefits such as better testing, easier deployment, faster performance, and more. These teams typically use standardized tools and follow a sequential process to build, review, test, deliver, and deploy code. Testing can be more complicated. Dynatrace news. Common problems with monolithic architecture.

Architecture 203

Architecture Serverless Azure Programming 203

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

Dynatrace

OCTOBER 10, 2023

A few avenues for elevating CI/CD pipelines are: Enhancing the extent of automated test coverage during the testing phase. Additionally, introduce annotation events to notify Dynatrace of the progress within your testing phase. It also returns valuable time back to the SRE team.

Engineering 229

Engineering DevOps Innovation Strategy 229

Scalegrid

FEBRUARY 8, 2024

At its core, a distributed storage system comprises three main components: a controller for managing the system’s operations, an internal datastore where information is held, and databases geared towards ensuring scalability, partitioning capabilities, and high availability for all types of data.

Storage 130

Storage Systems Big Data Azure 130

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Testlodge

NOVEMBER 1, 2021

A central goal of software testing is to find issues, especially critical ones, before they cause a problem in production. For example, it’s usual for software to have been designed with a specific use in mind, but the user doesn’t always understand the same way as the developers and testers. What is Destructive Testing?

Systems 81

Systems Testing Software Software 81

Testlodge

JANUARY 19, 2022

ETL Testing is a process used to test the transformation of raw data fetched from a certain source, before authenticating it according to business rules to make sure the particular data is loaded to the data warehouse (or a target system). Well-planned testing activities can ensure the data’s smooth migration from one place to another.

Testing 73

Testing Strategy Design Technology 73

Dynatrace

MAY 23, 2022

As developers move to microservice-centric designs, components are broken into independent services to be developed, deployed, and maintained separately. Shifting from monolith to microservices makes it easier to test, develop, and release innovative features more rapidly. This is usually a relational database management system.

Architecture 197

Architecture DevOps Monitoring Programming 197

O'Reilly Software

JUNE 12, 2018

Data is all-important—vital for the continued success of our businesses—but has also been seen as a massive constraint in how we design and evolve our systems. This meant a lot of time was spent on things like cycle time analysis, build pipeline design, test automation, and infrastructure automation.

Database 72

Database Cache Architecture Latency 72

Testlodge

JUNE 17, 2020

What is End to End Testing? End to end testing is an important technique used to validate the flow of an application from start to finish. The main objective of this testing is to simulate user behavior and thoroughly test components to identify any integration issues. Why End to End Testing is Needed.

Testing 73

Testing Government Database Systems 73