DZone

FEBRUARY 12, 2024

Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more. Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance.

Performance 161

Performance Database Strategy Efficiency 161

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

Smashing Magazine

OCTOBER 11, 2022

Sustainable Web Development Strategies Within An Organization. Sustainable Web Development Strategies Within An Organization. All industries have a part to play, and that includes web design and development. For example, changing our database architecture to be more efficient could save on server costs. Michelle Barker.

Strategy 123

Strategy Development Energy Website 123

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 111

Availability Database Open Source Hardware 111

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 91

Database Hardware Open Source Strategy 91

Dynatrace

MARCH 29, 2024

In today’s rapidly evolving landscape, incorporating AI innovation into business strategies is vital, enabling organizations to optimize operations, enhance decision-making processes, and stay competitive. The annual Google Cloud Next conference explores the latest innovations for cloud technology and Google Cloud.

Google 264

Google Innovation Cloud Analytics 264

Percona

JULY 2, 2023

In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. The size of the database and your database environment—if it is on colo or cloud—matters. They also ensure that backup strategies adhere to industry and legal compliance requirements.

Strategy 52

Strategy Database Storage Open Source 52

Dynatrace

JANUARY 31, 2024

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. Development and demand for AI tools come with a growing concern about their environmental cost.

Cache 206

Cache Azure Infrastructure Monitoring 206

Scalegrid

APRIL 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 185

Database Cloud Open Source Azure 185

Scalegrid

FEBRUARY 8, 2024

Data replication strategies like full, incremental, and log-based replication are crucial for improving data availability and fault tolerance in distributed systems, while synchronous and asynchronous methods impact data consistency and system costs. Variations within these storage systems are called distributed file systems.

Storage 130

Storage Systems Big Data Azure 130

Strategic Tech

JULY 21, 2020

Before jumping into either of those scenarios, have a look at what Strategic Domain-Driven Design can offer you. It’s got a selection of free tools you can use for defining your technology strategy, shaping your architectural boundaries, and organising your teams. For this purpose, you can use Core Domain Charts.

Architecture 98

Architecture Design Software Architecture Strategy 98

Dynatrace

DECEMBER 10, 2020

I recently joined two industry veterans and Dynatrace partners, Syed Husain of Orasi and Paul Bruce of Neotys as panelists to discuss how performance engineering and test strategies have evolved as it pertains to customer experience. Then, using a design thinking process , ideate on the future and establish the business vision.

Strategy 180

Strategy Performance Logistics Monitoring 180

Scalegrid

MARCH 28, 2024

Redis Data Types and Structures The design of Redis’s data structures emphasizes versatility. It is designed to cache plain text values, offering fast read and write access to frequently accessed data. Advanced Redis Features Showdown Big data center concept, cloud database, server power station of the future.

Cache 130

Cache Storage Scalability Architecture 130

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. Requirements.

Database 106

Database AWS Network Design 106

Dynatrace

APRIL 10, 2023

And according to recent data from Enterprise Strategy Group, 59% of survey respondents indicated spending on public cloud applications would increase in 2023. The company made these changes to support its ONETractor strategy, which seeks to deliver personalized, convenient shopping experiences anytime, anywhere.

Cloud 173

Cloud Ecommerce Performance Retail 173

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

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

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

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

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. This article cuts through the complexity to showcase the tangible benefits of DBMS, equipping you with the knowledge to make informed decisions about your data management strategies.

Efficiency 147

Efficiency Storage Database Scalability 147

O'Reilly Software

OCTOBER 23, 2018

A look at the roles of architect and strategist, and how they help develop successful technology strategies for business. I'm offering an overview of my perspective on the field, which I hope is a unique and interesting take on it, in order to provide context for the work at hand: devising a winning technology strategy for your business.

Strategy 100

Strategy Architecture Technology Technology 100

Scalegrid

JANUARY 11, 2024

This article strips away the complexities, walking you through best practices, top tools, and strategies you’ll need for a well-defended cloud infrastructure. These include alert fatigue, lack of context, and absence of strategy. These strategies should guarantee compliance with regulations and include endpoint security solutions.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

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. What is workload in cloud computing? Storage is a critical aspect to consider when working with cloud workloads.

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

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. Implementing pagination can be done using two primary strategies: offset-based and cursor-based methods. So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency.

Database 213

Database Latency C++ Scalability 213

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. This feature support required a significant update in the data table design (which includes new tables and updating existing table columns).

Media 237

Media Traffic Processing Design 237

Dynatrace

OCTOBER 10, 2023

This intricate allocation strategy can be categorized into two main domains. This proactive strategy significantly enhances the chances of success for SREs, providing them with more time to focus on substantial project improvements (50%) and broaden the buffer zone (30%).

Engineering 229

Engineering DevOps Innovation Strategy 229

Dynatrace

JANUARY 31, 2024

Data is the foundation upon which strategies are built, directions are chosen, and innovations are pursued. For DevOps teams that inform deployment strategies, optimize processes, and drive continuous improvement, the integrity and timeliness of data are of significant importance.

DevOps 195

DevOps Analytics Airlines Metrics 195

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

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This process is done automatically and does not significantly impact how the database is used.

Storage 94

Storage Scalability Strategy Performance 94

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. Nearly every vendor at Kubecon and every person we spoke to had some form of a multi-cloud requirement or strategy.

Cloud 82

Cloud Open Source Strategy Best Practices 82

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 100

AWS Benchmarking Performance Traffic 100

Dynatrace

SEPTEMBER 30, 2021

A cloud migration strategy, however, provides technical optimization that’s also firmly rooted in the business value chain. Migrating to the cloud is a strategy many organizations pursue to streamline and consolidate their security efforts. Check out our latest eBook to learn how to pick the right migration strategy.

Cloud 167

Cloud Traffic Best Practices Strategy 167

Dynatrace

OCTOBER 17, 2023

Each team had its favorite tool—whether for networking, development, or database management—and Odigo needed to centralize. “We It simplifies the interaction between clients and technical teams,” Lascoux said, though he acknowledged that Odigo is still developing its strategies to identify client-side issues. “We

Innovation 183

Innovation Monitoring Network Strategy 183

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. Ensuring the safety of your PostgreSQL data through regular backups is an important concern for database administrators. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server.

Database 97

Database Open Source Storage Servers 97