Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

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

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. In order to speed up the benchmark indexes must be added.

Database 103

Database Benchmarking Latency C++ 103

Percona Community

OCTOBER 23, 2020

Tech that makes our databases perform better. In this blog post we’re going to see those technologies at work to give us awesome block storage performance with flexibility and simple operations. Mayastor + SPDK + NVMe = fast databases Mayastor is new tech, it’s fast, and it’s based on SPDK. At MayaData we like new tech.

Storage 52

Storage Latency Speed Database 52

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Storage is a critical aspect to consider when working with cloud workloads. What is workload in cloud computing?

Cloud 130

Cloud Virtualization Storage Efficiency 130

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

Dynatrace

OCTOBER 4, 2022

Traditionally, though, to gain true business insight, organizations had to make tradeoffs between accessing quality, real-time data and factors such as data storage costs. IT pros want a data and analytics solution that doesn’t require tradeoffs between speed, scale, and cost. Modern software intelligence needs a new approach.

Analytics 190

Analytics Software Software Storage 190

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Storage reduction alone results in significant cost savings, and we can save more data in the same space. By default, MongoDB provides a snappy block compression method for storage and network communication.

Storage 106

Storage Network Open Source Latency 106

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

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

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Also, thinking about write process speed & storage capacity must always come first before creating indexes as well. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. The basic tier provides up to 5 DTUs with standard storage. HyperScale Database. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

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

KeyCDN

FEBRUARY 22, 2023

PWAs are designed to work offline, be fast, and provide a seamless user experience across different devices. Motion UI Motion UI is a design trend involving animation and other interactive elements to create a more dynamic and engaging user experience. They thus adapt to the user's browser, screen size, and device specifications.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. For example, if the database name is prepended or the table name has backticks around it.

Database 158

Database Government Games Servers 158

Scalegrid

MARCH 14, 2024

It provides significant advantages that include: Offering scalability to support business expansion Speeding up the execution of business plans Stimulating innovation throughout the company Boosting organizational flexibility, enabling quick adaptation to changing market conditions and competitive pressures.

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. In this case, the backups should be stored on some object storage. You can find all examples from this blog post in this GitHub repository.

Storage 92

Storage Database Media Open Source 92

Dynatrace

JANUARY 31, 2024

million” – Gartner Data observability is a practice that helps organizations understand the full lifecycle of data, from ingestion to storage and usage, to ensure data health and reliability. An erroneous change in the database system leads to a subset of the data being categorized incorrectly.

DevOps 195

DevOps Analytics Airlines Metrics 195

Dynatrace

NOVEMBER 23, 2020

While speeding up development processes and reducing complexity does make the lives of Kubernetes operators easier, the inherent abstraction and automation can lead to new types of errors that are difficult to find, troubleshoot, and prevent. Configuring storage in Kubernetes is more complex than using a file system on your host.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Percona

JULY 24, 2023

PBM) introduced a GA version of incremental physical backups , which can greatly impact both the recovery time and the cost of backup (considering storage and data transfer cost). Well, it is because we believe that open source philosophy is not only about the source but also about design and decision-making.

Availability 74

Availability Open Source Strategy Storage 74

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 74

Open Source Database Scalability Software 74

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. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

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. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 70

Best Practices Traffic Database Servers 70

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. They are a roadmap that speeds up the process of finding specific rows in a large table. What is an Index?

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. According to the Dynatrace Kubernetes in the Wild 2023 report , a significant 71% (with 48% year-over-year growth!)

Cloud 78

Cloud Open Source Strategy Best Practices 78

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects. pg_partman_bgw.dbname : Required.

Storage 98

Storage Open Source Database Efficiency 98

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

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. Columnar storage. speeds up scans, . OLTP vs OLAP. consolidation (roll-up).

Database 92

Database Analytics Storage Processing 92

Percona

JANUARY 24, 2023

There will be a considerable gain if we combine this with other sets of great improvements in WAL archiving in PostgreSQL 15, as discussed in previous posts New WAL Archive Module/Library in PostgreSQL 15 and Speed Up of the WAL Archiving in PostgreSQL 15. Such “torn pages” are corruptions from the database point of view.

Database 115

Database Benchmarking Open Source Latency 115

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Why HammerDB was developed. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Morning Paper

FEBRUARY 6, 2020

’ Stateless is fine until you need state, at which point the coarse-grained solutions offered by current platforms limit the kinds of application designs that work well. On the Cloudburst design teams’ wish list: A running function’s ‘hot’ data should be kept physically nearby for low-latency access.

Lambda 98

Lambda Serverless Cache Latency 98

Smashing Magazine

SEPTEMBER 28, 2022

On design systems, UX, web performance and CSS/JS. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. In a common WebSocket architecture, the Front-end application will connect to a WebSocket API, an event bus, or a database. More after jump!

Cache 125

Cache Performance Servers Social Media 125

Scalegrid

JANUARY 8, 2019

Simply put, in a MySQL semisynchronous replication configuration, the master commits transactions to the storage engine only after receiving acknowledgement from at least one of the slaves. Managing The Execution Speed of The Slaves. The default design of the ScaleGrid HA framework is to avoid falling back to asynchronous mode.

Availability 113

Availability Tuning Speed Network 113

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario. Esv3-series.

Azure 72

Azure Virtualization Servers Storage 72