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 84

Database Monitoring C++ Speed 84

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

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. This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure.

Cloud 130

Cloud Virtualization Storage Efficiency 130

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. How to Implement Pagination in MongoDB® Big datasets require efficient data retrieval and processing for effective management. limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. AWS offers four serverless offerings for storage.

Serverless 279

Serverless AWS Lambda Storage 279

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 89

Database Hardware Open Source Strategy 89

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 76

Open Source Database Storage Scalability 76

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Tune and optimize to improve performance Even if you consider your database platform modern, simple database tuning and optimization can speed up your processes significantly.

Database 83

Database Serverless Tuning Cloud 83

Dynatrace

OCTOBER 4, 2022

They can call on dozens of databases and deliver gigabytes of data across myriad devices. In most data storage models, indexing engines enable faster access to query logs. But indexing requires schema management and additional storage to be effective, which adds cost and overhead.

Analytics 219

Analytics Storage Infrastructure Metrics 219

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

Dynatrace

JULY 29, 2022

With the right log management and observability platform, IT teams can efficiently identify the root cause of problems during these peak times and maintain three-nines of availability — or 99.98%. Traditional databases help users and machines find data with a quick search. Cold storage and rehydration. Indexing overhead.

Analytics 213

Analytics Storage Retail Monitoring 213

Scalegrid

DECEMBER 21, 2023

Redis® Monitoring Essentials Ensuring the performance, reliability, and safety of a Redis® database requires active monitoring. With these essential support systems in place, you can effectively monitor your databases with up-to-date data about their health and functioning status at all times.

Strategy 130

Strategy Monitoring Latency DevOps 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

Dynatrace

JULY 29, 2022

With the right log management and observability platform, IT teams can efficiently identify the root cause of problems during these peak times and maintain three-nines of availability — or 99.98%. Traditional databases help users and machines find data with a quick search. Cold storage and rehydration. Indexing overhead.

Analytics 180

Analytics Storage Retail Monitoring 180

Dynatrace

OCTOBER 4, 2022

As a result, organizations need software to work perfectly to create customer experiences, deliver innovation, and generate operational efficiency. 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.

Analytics 189

Analytics Software Software Storage 189

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 110

Storage Network Open Source Latency 110

Scalegrid

MARCH 14, 2024

In practice, a hybrid cloud operates by melding resources and services from multiple computing environments, which necessitates effective coordination, orchestration, and integration to work efficiently. Tailoring resource allocation efficiently ensures faster application performance in alignment with organizational demands.

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

Percona

APRIL 24, 2023

I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them. This post is about PostgreSQL, but most of the problems also apply to other database systems. As the size of the active dataset increases, the cache becomes less and less efficient.

Tuning 127

Tuning Cache Storage Database 127

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

Performance 105

Performance Monitoring Traffic Database 105

Dynatrace

FEBRUARY 16, 2023

As teams try to gain insight into this data deluge, they have to balance the need for speed, data fidelity, and scale with capacity constraints and cost. Grail combines the big-data storage of a data warehouse with the analytical flexibility of a data lake. And without the encumbrances of traditional databases, Grail performs fast. “In

Analytics 184

Analytics Innovation Metrics Database 184

Percona

NOVEMBER 20, 2023

Although the introduction of physical backups in Percona Backup for MongoDB (PBM) made it possible to significantly cut the restore time for big datasets, it’s hard to beat snapshots in speed and efficiency. First, it prepares the database and ensures the data files can be safely copied.

Storage 84

Storage Database Strategy Speed 84

Dynatrace

JANUARY 11, 2023

High storage costs. To make searches more manageable, teams rely on database indexing. To analyze long-term trends using traditional methods, teams must rehydrate data that resides in “cold data storage” (older data that is no longer accessible for daily operations). Search constraints.

Analytics 187

Analytics Strategy Storage Technology 187

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 96

Storage Database Media Open Source 96

Scalegrid

JANUARY 19, 2024

Data-bearing members face a higher risk of encountering issues caused by rollbacks, compared to others who utilize different storage methods. For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines.

Database 130

Database Network Servers Monitoring 130

Dynatrace

AUGUST 5, 2022

For nonurgent messages, texting is a more efficient approach. In a distributed processing environment, message queuing is similar, although the speed and volume of messages are much greater. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them.

Monitoring 198

Monitoring Serverless Programming Speed 198

Dynatrace

AUGUST 5, 2022

For nonurgent messages, texting is a more efficient approach. In a distributed processing environment, message queuing is similar, although the speed and volume of messages are much greater. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them.

Monitoring 197

Monitoring Serverless Programming Speed 197

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. Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 73

Best Practices Traffic Database Servers 73

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. Customers will increasingly prioritize AI efficiency and education to tackle legal and ethical concerns.

Cloud 80

Cloud Open Source Strategy Best Practices 80

KeyCDN

FEBRUARY 22, 2023

Chatbots and virtual assistants Chatbots and virtual assistants are becoming more common on websites and web applications as they provide an efficient and convenient way for users to interact with a business. If you have a large database of user information stored on your servers, consider introducing multi-factor identification.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

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.

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. The read speed is too slow, which usually is a sign of IO congestion.

C++ 106

C++ Servers Storage Speed 106

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 81

Database Servers Storage Strategy 81

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

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 101

Storage Open Source Database Efficiency 101

Smashing Magazine

SEPTEMBER 28, 2022

Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. Server caches help lower the latency between a Frontend and Backend; since key-value databases are faster than traditional relational SQL databases, it will significantly increase an API’s response time.

Cache 126

Cache Performance Servers Social Media 126

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. But while eminently capable of performing OLAP, it’s not quite as efficient.

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 118

Database Benchmarking Open Source Latency 118