Scalegrid

JANUARY 19, 2024

When a MongoDB rollback happens, it can cause trouble to your data integrity and system consistency. Data-bearing members face a higher risk of encountering issues caused by rollbacks, compared to others who utilize different storage methods. Consequences of Rollbacks After a rollback occurs, the consequences can be quite severe.

Database 130

Database Network Servers Monitoring 130

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. Kubernetes is emerging as the “operating system” of the cloud. Kubernetes moved to the cloud in 2022.

Open Source 345

Open Source Java Operating System Programming 345

Scalegrid

DECEMBER 28, 2023

Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum. Its use includes the limit method, which establishes how many documents will be returned in a query result. This can be expressed as db.collection_name.find().limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe. Dynatrace news.

Internet 261

Internet Internet Games Java 261

SQL Performance

JULY 19, 2022

Previously I’ve talked about why logging is required and the architecture and circular nature of the log, so now it’s time to look at the real heart of the logging system—the log records themselves. There are between 70 and 100 log record types, depending on the version of SQL Server (there’s no documented list).

Servers 94

Servers Database Storage Engineering 94

Scalegrid

NOVEMBER 23, 2023

Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security. It represents either an IP address or domain name of the server, where one can find those databases located. Do check your configuration accordingly, however.

Database 130

Database Servers Storage Network 130

Dynatrace

AUGUST 24, 2020

To make this possible, the application code should be instrumented with telemetry data for deep insights, including: Metrics to find out how the behavior of a system has changed over time. Traces help find the flow of a request through a distributed system. Dynatrace VMware and virtualization documentation .

Analytics 243

Analytics Infrastructure AWS Operating System 243

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. “Be

Servers 90

Servers Media Cache Storage 90

Percona

DECEMBER 4, 2023

It is the most stable, scalable, and secure open source MySQL distribution based on Percona Server for MySQL. A release highlight is the implementation of telemetry in Percona Server for MySQL that fills in the gaps in our understanding of how you use Percona Server for MySQL to improve our products. Percona XtraBackup 8.0.35-30

Open Source 83

Open Source Azure Servers Programming 83

Percona

FEBRUARY 10, 2023

Please check Amazon’s Official Documentation for more information. Xbcloud is a tool part of Percona XtraBackup and allows you to upload and download backups to Amazon S3 storage. Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server for MySQL and MySQL.

Storage 96

Storage Open Source AWS Servers 96

Dynatrace

DECEMBER 16, 2020

Source code management systems are only accessible from within the Dynatrace corporate network. The full list of secure development controls, along with many more details, are documented at Dynatrace secure development controls. Every storage location involving data at rest is encrypted as well.

Software 236

Software Software Development AWS 236

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 89

Programming Servers Database Hardware 89

Percona

MARCH 10, 2023

Consider this: we define a capped collection of size 1GB, it will purge out the oldest document if the allocated size of the collection is full and we have to insert a new document. A capped collection guarantees that it will maintain the document’s insertion order. Create an index to avoid collection scan.

Open Source 107

Open Source Storage Speed Servers 107

Percona

AUGUST 30, 2023

Without data backup mechanisms, there can be data loss or system downtime. Even worse, entire operating systems can crash, also resulting in data loss. An incremental backup, which is faster and requires less storage than a full backup, captures changes made since the previous backup. Similarly, accidental deletion is a culprit.

Database 92

Database Hardware Open Source Strategy 92

Percona

NOVEMBER 1, 2023

The key question related to RTO is, “How quickly must the data on this system be restored?” Snapshot Backups: Some file system implementations enable “snapshots” to be taken. These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system.

Best Practices 79

Best Practices Storage Strategy Database 79

Percona

OCTOBER 18, 2023

These vendors often provide integrated stacks that include the database, application server, and other components that seamlessly integrate. Parallel run : Operating both the existing and new database system simultaneously during the transition, allowing for a seamless fallback in case of any issues.

Open Source 96

Open Source Database Hardware Strategy 96

Percona

JULY 17, 2023

5 among all database management systems and No. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Instead of the table-based structure of relational databases, MongoDB stores data in documents and collections, a design for handling large amounts of unstructured data and for real-time web applications.

Open Source 80

Open Source Database Scalability Software 80

Percona

MAY 9, 2023

Many MongoDB clusters use storage-level snapshots to provide fast and reliable backups. Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform. Set spec.image to a specific image version.

Storage 109

Storage Cloud Servers Google 109

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. Make sure your website doesn’t go down with a server or datacenter crash by configuring a master-slave setup for high availability.

Database 166

Database Cloud Website Azure 166

SQL Performance

OCTOBER 7, 2020

The documentation says only the following operators can rewind: Table Spool. Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations. I have not been able to find any official explanation or documentation about it. Row Count Spool. Remote Query.

Servers 106

Servers Cache Azure Performance 106

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. Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks. Why are MongoDB database backups important?

Best Practices 52

Best Practices Database Storage Servers 52

Percona

JUNE 6, 2023

Full backups are most suitable for critical systems or sensitive data that cannot afford any loss or downtime, allowing for a complete recovery of data in the event of data corruption, hacking, system failures, or natural disasters. In addition, they are used for restoring or moving data to a new system.

Storage 68

Storage Strategy Network Efficiency 68

Dynatrace

AUGUST 24, 2020

Metrics to find out how the behavior of a system has changed over time . Traces help find the flow of a request through a distributed system . To provide actionable answers monitoring systems store, baseline, and analyze telemetry data. Dynatrace VMware and virtualization documentation . Kubernetes integration.

Analytics 135

Analytics Infrastructure AWS Operating System 135

The Netflix TechBlog

JULY 30, 2019

If you’re new to Conductor, this earlier blogpost and the documentation should help you get started and acclimatized to Conductor. External Payload Storage External payload storage was implemented to prevent the usage of Conductor as a data persistence system and to reduce the pressure on its backend datastore.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster.

Database 84

Database Servers Storage Strategy 84

SQL Performance

APRIL 17, 2020

Ultimately, tables are stored as a sequence of bytes with some metadata elsewhere in the system to describe what each of those bytes mean, and how they relate to each of the table's various columns. It requires only a few changes to system tables, and a minimal amount of logging. Improvements in SQL Server 2016.

Servers 63

Servers Database Testing Efficiency 63

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 88

Availability Open Source Architecture Database 88

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 5, 2023

to 5.7: [link] The entire “Downgrading MySQL” section of the documentation was basically reduced to a statement that it is not supported; therefore, you can try it at your own risk. Now, the first issue with the logical dump restore approach, as somewhat totally expected though, is with system tables. and restore to 5.7

C++ 122

C++ Database Servers Testing 122

Percona

JANUARY 24, 2023

Our Operators provide built-in backup and restore capabilities, but some users are still looking for old-fashioned ways, like storage-level snapshots (i.e., Both your storage and Container Storage Interface (CSI) must support snapshots. AWS EBS Snapshots). The volumes you created earlier will be used automatically.

Database 70

Database Storage Open Source AWS 70

Percona

SEPTEMBER 6, 2023

Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is. In both examples below, the system sees the query as just WHERE indexed column = ‘constant’ and so the speed of the search is equivalent to any other simple index query.

Speed 86

Speed Virtualization Storage Open Source 86

Percona

AUGUST 17, 2023

In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). How-to documentation is readily available. The widespread use and popularity have come on like gangbusters in recent years, but PostgreSQL wasn’t always the cool kid.

Open Source 83

Open Source Healthcare Social Media Database 83

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. Operating System (OS) settings Swappiness Swappiness is a Linux kernel setting that influences the behavior of the Virtual Memory manager when it needs to allocate a swap, ranging from 0-100.

Best Practices 52

Best Practices Design Tuning Database 52

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

Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. Some disruption might occur, but it will be minimal. Fault tolerance aims for zero downtime and data loss.

Availability 112

Availability Database Open Source Hardware 112

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. As database performance is heavily influenced by the performance of storage, network, memory, and processors, we must understand the upper limit of these key components. Operating System: Ubuntu 22.04

Performance 54

Performance Benchmarking Cache Storage 54

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. Dynamic WiredTiger tickets As a brief recap, WiredTiger tickets in MongoDB serve as the concurrency control mechanism within the WiredTiger storage engine.

Metrics 105

Metrics C++ Storage Database 105