Testlodge

MARCH 21, 2023

Black box testing focuses on the requirements to ensure the system responds as expected, according to the documentation. Black box testing focuses on the requirements to ensure the system responds as expected, according to the documentation. White box testing examines the system’s internal structure and architecture.

Testing 67

Testing Architecture Hardware Code 67

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 89

Open Source Database Hardware Strategy 89

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

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. Instead, readers should refer to the HammerDB documentation.

Performance 54

Performance Benchmarking Cache Storage 54

The Netflix TechBlog

AUGUST 30, 2021

Complementing the hardware is the software on the RAE and in the cloud, and bridging the software on both ends is a bi-directional control plane. When a new hardware device is connected, the Local Registry detects and collects a set of information about it, such as networking information and ESN.

Latency 213

Latency Traffic Transportation Hardware 213

HammerDB

NOVEMBER 22, 2021

HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. start the database and then login and create the extensions as follows. Prior to version 4.3, PostgreSQL Metrics Options.

Metrics 62

Metrics Benchmarking C++ Database 62

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. You can refer to the documentation for further details. It supports native sharding being transparent for the application.

Open Source 85

Open Source Storage Database Big Data 85

J. Paul Reed

AUGUST 7, 2023

See, this data center had originally been provisioned over a decade ago, and back then, the provisioning practices weren’t as automated (or even documented) as they are now. The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning.

Engineering 52

Engineering Hardware Games Infrastructure 52

SQL Performance

JULY 3, 2019

However, in this case the application didn't use stored procedures for access to the database, and all of the code was generated by an ORM. The documentation for TransactionScope pretty quickly ruled that out as a possible cause of this. The application enlisting a SqlTransaction() on the connection.

Servers 64

Servers Hardware Code Virtualization 64

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications. Why would this be the case?

C++ 40

C++ Benchmarking Virtualization Open Source 40

VoltDB

MAY 2, 2017

This has always been a supported configuration of VoltDB database replication. Here’s how we explain it in our Documentation: Support for different cluster sizes in passive Database Replication (DR). because they want to use a lower k- factor (even 0) on the replica cluster to lower hardware costs.

Hardware 40

Hardware Database Servers Tuning 40

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 104

Availability Database Open Source Hardware 104

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. More importantly, if this works out well, this could lead to a radical improvement in performance by leveraging hardware trends such as GPUs and TPUs. Learned indexes.

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

SQL Performance

NOVEMBER 1, 2019

Accelerated Database Recovery is in Standard Edition. Keeping in mind that the documentation is not final, this is a great change for a lot of shops, and it makes sense that such an important security feature should not be a differentiator for the most expensive edition. Transparent Data Encryption (TDE) is now in Standard Edition.

Servers 40

Servers Hardware Database Availability 40

Dotcom-Montior

DECEMBER 8, 2021

The IT service catalog is typically a database or resource that an organization creates to provide users with information on their operational services and offerings. Software services still require physical devices and hardware for them to function. Service Catalog. Change management is also sometimes grouped with release management.

Social Media 90

Social Media Monitoring Latency DevOps 90

All Things Distributed

APRIL 5, 2012

One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. Amazon RDS removes the headaches of running a relational database service reliably at scale, allowing Amazon RDS customers to focus on innovation for their customers. hands freeÃ?

Innovation 149

Innovation AWS Education Network 149

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Simplicity.

Serverless 282

Serverless AWS Lambda Storage 282

Dynatrace

MAY 1, 2023

Additionally, ITOA gathers and processes information from applications, services, networks, operating systems, and cloud infrastructure hardware logs in real time. Identify data use cases and develop a scalable delivery model with documentation. NoSQL database. Establish data governance. Provide data literacy for stakeholders.

Analytics 190

Analytics Artificial Intelligence Big Data Open Source 190

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. a majority of nodes).

Database 106

Database AWS Network Design 106

Dynatrace

APRIL 23, 2019

Node size categories in the CMC have been updated to match the node type, as documented in Dynatrace Managed hardware and system requirements. We’ve optimized backups by shrinking their size by excluding the same set of column families in the databases. Also in this release. The import_trusted_certificate.sh

Traffic 23

Traffic Hardware Efficiency Database 23

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. From AWS documentation , Amazon EBS is an easy-to-use, scalable, high-performance block-storage service designed for Amazon EC2.

Cloud 116

Cloud Serverless AWS Storage 116

All Things Distributed

OCTOBER 8, 2014

We are introducing native support for document model like JSON into DynamoDB, the ability to add / remove global secondary indexes, adding more flexible scaling options, and increasing the item size limit to 400KB. The original Dynamo paper inspired many database solutions, which are now popularly referred to as NoSQL databases.

Availability 145

Availability Performance Scalability AWS 145

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak.

Database 78

Database Servers Storage Strategy 78

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more.

Open Source 109

Open Source Artificial Intelligence Google Infrastructure 109

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 82

Programming Servers Database Hardware 82

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently.

Servers 90

Servers Media Cache Storage 90

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 81

Availability Open Source Architecture Database 81

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Werner Vogels weblog on building scalable and robust distributed systems.

Scalability 167

Scalability Database Ecommerce Latency 167

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

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

SQL Server According to Bob

JULY 13, 2016

desktop machine (I won’t tell you the hardware details. This is effectively the same as if you had used the full install and picked the features of Database Engine Services and Client Connectivity SDK as the two components to install. Go install it”. So I proceeded to install SQL Server 4.20 on my Windows NT 3.1 It would scare you).

Servers 40

Servers Media Engineering Virtualization 40

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. Why Do MySQL Backups Matter? What is the Recovery Time Objective?

Best Practices 78

Best Practices Storage Strategy Database 78

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. There’s actually more documented. OLTP vs OLAP. Let’s get back to basics.

Database 92

Database Analytics Storage Processing 92

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

SQL Performance

JANUARY 23, 2020

Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. There is a single SQL Server database at the heart of every SentryOne monitoring environment, and this customer was monitoring around 600 servers with our software. Query Store wait categories are documented here.

Tuning 115

Tuning Servers Monitoring Hardware 115