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. Through this meticulous process, commits are accurately logged in their respective sequences.

Database 162

Database Strategy Servers Best Practices 162

The Netflix TechBlog

JUNE 13, 2023

This is where large-scale system migrations come into play. Our previous blog post presented replay traffic testing — a crucial instrument in our toolkit that allows us to implement these transformations with precision and reliability. Sticky Canary is an improvement to the traditional canary process that addresses this limitation.

Traffic 279

Traffic Metrics Systems Strategy 279

Testlodge

NOVEMBER 1, 2021

A central goal of software testing is to find issues, especially critical ones, before they cause a problem in production. This article discusses one measure to prevent these kinds of errors, known as destructive testing. What is Destructive Testing? How the system responds is then analyzed. Tools for Testing.

Systems 81

Systems Testing Software Software 81

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

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 102

Database Benchmarking Latency C++ 102

The Netflix TechBlog

MARCH 6, 2019

—?Mounting object storage in Netflix’s media processing platform By Barak Alon (on behalf of Netflix’s Media Cloud Engineering team) MezzFS (short for “Mezzanine File System”) is a tool we’ve developed at Netflix that mounts cloud objects as local files via FUSE. Encoding is not a one-time process?—?large We have one file?—?the

Media 214

Media Storage Processing Cache 214

Particular Software

SEPTEMBER 11, 2023

Migrating a message-based system from on-premises to the cloud is a colossal undertaking. If you search for “how to migrate to the cloud”, there are reams of articles that encourage you to understand your system, evaluate cloud providers, choose the right messaging service, and manage security and compliance.

Cloud 126

Cloud Systems Azure Airlines 126

Percona

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 123

Database Storage Government Open Source 123

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Monitoring the progress of the restore process is essential to estimate completion time and ensure everything is proceeding smoothly.

Database 80

Database Monitoring C++ Speed 80

DZone

JANUARY 23, 2021

If you need to dynamically trace Linux process system calls, you might first consider strace. According to a performance test conducted by Arnaldo Carvalho de Melo, a senior software engineer at Red Hat, the process traced using strace ran 173 times slower, which is disastrous for a production environment.

Systems 166

Systems Performance Software Engineering Performance Testing 166

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

Percona

AUGUST 9, 2023

MySQL 8 brought a significant architectural transformation by replacing the traditional MyISAM-based system tables with the Transaction Data Dictionary (TDD), a more efficient and reliable approach. The primary goal of the Transaction Data Dictionary (TDD) is to enhance the overall performance, stability, and scalability of MySQL databases.

Database 76

Database Storage Scalability Games 76

Dynatrace

OCTOBER 10, 2023

Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. A few avenues for elevating CI/CD pipelines are: Enhancing the extent of automated test coverage during the testing phase.

Engineering 232

Engineering DevOps Innovation Strategy 232

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 82

Scalability Database Open Source Traffic 82

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

Dynatrace

JANUARY 31, 2024

GenAI is prone to erratic behavior due to unforeseen data scenarios or underlying system issues. 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.

Cache 209

Cache Azure Infrastructure Monitoring 209

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.

Database 106

Database AWS Network Design 106

Dynatrace

JANUARY 5, 2022

This guest blog is authored by Raphael Pionke , DevOps Engineer at T-Systems MMS. Credits on content go to him and the work he has been doing around performance & resiliency testing automation. Our Application Performance Management (APM) and load test team at T-Systems MMS helps our customers reduce the risk of failed releases.

Testing 223

Testing Open Source Metrics Infrastructure 223

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 205

Engineering Testing Performance Performance Testing 205

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 94

Database C++ Servers Open Source 94

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. However, data loss is always possible due to hardware malfunction, software defects, or other unforeseen circumstances, just like with any computer system.

Best Practices 130

Best Practices Storage Strategy Database 130

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

Dynatrace

JANUARY 16, 2023

As Kubernetes adoption increases and it continues to advance technologically, Kubernetes has emerged as the “operating system” of the cloud. Kubernetes is emerging as the “operating system” of the cloud. The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Kubernetes moved to the cloud in 2022.

Open Source 347

Open Source Java Operating System Programming 347

Scalegrid

JANUARY 8, 2024

Key Takeaways AI integration in cloud computing increases operational efficiency by automating processes, optimizing resource allocation, and improving scalability, leading to cost savings and allowing IT teams to concentrate on strategic initiatives. Discover how AI is reshaping the cloud and what this means for the future of technology.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

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

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. There are four major types of controls.

Testing 81

Testing Energy Programming Government 81

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application performance for MongoDB , MySQL and PostgreSQL.

Analytics 185

Analytics Storage Database Systems 185

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. These systems are a combination of different hardware and software which have been configured to perform the desired task. What is Configuration Testing?

Testing 89

Testing Hardware Virtualization Operating System 89

Dynatrace

APRIL 10, 2023

Further, Tractor Supply’s transition to Kubernetes introduced many new processes—particularly regarding security. With Dynatrace deep cluster monitoring, “we were able to do upfront detection of security processes consuming higher CPU time on the cluster,” Bollampally said. Further, as Tractor Supply Co.

Cloud 176

Cloud Ecommerce Performance Retail 176

Dynatrace

JANUARY 31, 2024

Data observability involves monitoring and managing the internal state of data systems to gain insight into the data pipeline, understand how data evolves, and identify any issues that could compromise data integrity or reliability. . “Every year, poor data quality costs organizations an average $12.9

DevOps 198

DevOps Analytics Airlines Metrics 198

The Morning Paper

MARCH 15, 2020

Understanding, detecting and localizing partial failures in large system software , Lou et al., Partial failures ( gray failures ) occur when some but not all of the functionalities of a system are broken. Here are the key findings: Partial failures appear throughout the release history of each system, 54% within the last three years.

Systems 98

Systems Software Software Programming 98

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. On modern Linux systems, the difference in overhead between forking a process and creating a thread is much lesser than it used to be.

Architecture 200

Architecture Database Latency Servers 200

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? mongodump --host=mongodb1.example.net

Best Practices 52

Best Practices Database Storage Servers 52

Scalegrid

JULY 29, 2020

It uses only one process which makes it very lightweight. If we require N parallel connections, this forks N child processes. By default, there are 32 child processes that are forked. PgBouncer defines one pool per user+database combination. Pgpool-II defines one process per child process. Pooling modes.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

The Netflix TechBlog

DECEMBER 3, 2022

The most commonly used one is dataflow project , which helps folks in managing their data pipeline repositories through creation, testing, deployment and few other activities. Thanks to the Netflix internal lineage system (built by Girish Lingappa ) Dataflow migration can then help you identify downstream usage of the table in question.

Best Practices 358

Best Practices Code Testing Data Engineering 358