Percona

NOVEMBER 2, 2023

MongoDB is a dynamic database system continually evolving to deliver optimized performance, robust security, and limitless scalability. Our new eBook, “ From Planning to Performance: MongoDB Upgrade Best Practices ,” guides you through the entire process to ensure your database’s long-term success.

Best Practices 111

Best Practices Hardware Tuning Scalability 111

Percona

SEPTEMBER 23, 2024

When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL.

Best Practices 126

Best Practices Database Efficiency Performance 126

Dynatrace

JULY 22, 2024

Metrics are typically aggregated and stored in time series databases for monitoring and alerting purposes. The OpenTelemetry Protocol (OTLP) plays a critical role in this framework by standardizing how systems format and transport telemetry data, ensuring that data is interoperable and transmitted efficiently. Contextualize data.

Latency 264

Latency Best Practices Metrics Open Source 264

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Scalability Best Practices Blockchain 130

SQL Shack

DECEMBER 30, 2022

In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database.

Best Practices 92

Best Practices Database Efficiency Performance 92

Dynatrace

DECEMBER 21, 2023

Most approaches focus on improving Power Usage Effectiveness (PUE), a data center energy-efficiency measure. energy-efficient data centers—cloud providers—achieve values closer to 1.2. This computational efficiency also reduces energy consumption, which in turn reduces carbon emissions. A PUE of 1.0

Cloud 264

Cloud Energy Best Practices Cache 264

Dynatrace

SEPTEMBER 30, 2021

Not only will they get much more out of the tools they use daily, but they’ll also be able to deliver superior functionality, efficiency, and performance to your customers. In addition, 45% of them have gone on to implement efficiencies in their roles, and 43% reported they were able to do their job more quickly after getting certified.

AWS 246

AWS Best Practices Cloud Analytics 246

Dynatrace

JULY 11, 2024

Retention-based deletion is governed by a policy outlining the duration for which data is stored in the database before it’s deleted automatically. For instance, if data is mistakenly ingested into the database, it may need to be deleted to prevent inaccuracies or sensitive data from being stored. Get started New to Dynatrace?

Storage 264

Storage Best Practices Government Media 264

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. In cloud computing environments, infrastructure and services are maintained by the cloud vendor, allowing you to focus on how best to serve your customers. Migrate databases intelligently.

Cloud 241

Cloud Traffic Best Practices Strategy 241

Percona

NOVEMBER 13, 2023

To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End of Life (EOL) – it’s crucial to upgrade your database systems from time to time. One of the most compelling reasons to choose a professional service is the reduced risk.

Database 111

Database Open Source Best Practices Strategy 111

Dynatrace

AUGUST 8, 2024

Employee training in cybersecurity best practices and maintaining up-to-date software and systems are also crucial. Possible scenarios An IT technician accidentally deletes a critical database, causing a service outage. Human error Human error remains one of the leading causes of tech outages.

Software 290

Software Software Infrastructure Network 290

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 132

Availability Database Open Source Hardware 132

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 98

Best Practices Traffic Database Servers 98

Dynatrace

OCTOBER 10, 2023

Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. Reality In practice, while both these categories have equal attention, project improvements hold paramount importance for business outcomes.

Engineering 264

Engineering DevOps Innovation Strategy 264

Percona

APRIL 5, 2024

PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for businesses looking to upgrade or switch their database infrastructure. It is so […]

Best Practices 81

Best Practices Open Source Scalability Database 81

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. Cost and resource efficiency One of Kubernetes’ main advantages is its efficient use of resources. You may already be using it daily and find it makes running applications in the cloud much more manageable.

Efficiency 117

Efficiency Cloud Healthcare Open Source 117

DZone

DECEMBER 11, 2024

MuleSoft is a powerful integration platform that often deals with high-throughput workloads that require robust database connection management. One solution that stands out in optimizing database interactions is HikariCP, a high-performance JDBC connection pool known for its speed and reliability.

Performance 130

Performance Best Practices Speed Database 130

The Netflix TechBlog

DECEMBER 11, 2020

This gives us access to Netflix’s Java ecosystem, while also giving us the robust language features such as coroutines for efficient parallel fetches, and an expressive type system with null safety. For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database.

Architecture 255

Architecture Best Practices Engineering Open Source 255

Dynatrace

APRIL 21, 2022

The Framework is built on five pillars of architectural best practices: Cost optimization. Performance efficiency. Each pillar brings business and technology leaders together to help organizations choose architecture options that best strategically align to their specific business priorities as they begin their cloud journey.

Azure 246

Azure Monitoring Virtualization Metrics 246

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Think of a user login which requires your back-end systems to validate user credentials and query required user profile information from the backend databases. Too much data requested from a database, e.g. Request all and filter in memory.

Cache 214

Cache Database Architecture Government 214

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 111

Open Source Database Hardware Strategy 111

Dynatrace

SEPTEMBER 23, 2021

Best practices for container security. Here is a checklist of best practices for how to approach container security. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery. Pretty neat, isn’t it? Manage secrets.

Open Source 279

Open Source Benchmarking Best Practices Network 279

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

MAY 13, 2019

In this blog post, we describe some best practices for setting up and managing MySQL error logs, general logs and slow query logs for your MySQL deployments. logrotate is a Linux utility that helps with the efficient administration of log files and provides options for automatic rotation, compression, and removal of log files.

Servers 247

Servers Best Practices Efficiency Availability 247

Dynatrace

APRIL 16, 2019

Many of our customers also run their.NET, ASP.NET,NET Core, SQL Server, CRM, SharePoint … applications on AWS and have reached out to us in the past to ask about best practices around optimizing these workloads in order to run more efficiently and more cost effective. Are they receiving traffic? #3:

AWS 186

AWS Database Best Practices Traffic 186

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 107

Database Hardware Open Source Strategy 107

The Netflix TechBlog

MARCH 5, 2019

As a micro-service owner, a Netflix engineer is responsible for its innovation as well as its operation, which includes making sure the service is reliable, secure, efficient and performant. In the Efficiency space, our data teams focus on transparency and optimization.

Infrastructure 185

Infrastructure Cloud Scalability AWS 185

Dynatrace

JULY 7, 2022

Microservices development is intrinsically optimized for continuous integration/continuous deployment ( CI/CD ) processes that apply agile development best practices for the rapid delivery of reliable code. Additionally, typical SOA models use larger relational databases.

Architecture 246

Architecture Serverless Azure Programming 246

SQL Performance

MAY 8, 2019

This article is the second in a series about T-SQL bugs, pitfalls and best practices. As for best practices that can help you avoid such bugs, there are two main ones. They’re also quite efficient, using a Left Semi Join optimization with a short-circuit. This time I focus on classic bugs involving subqueries.

Best Practices 68

Best Practices C++ Code Servers 68

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

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 136

Performance Monitoring Traffic Database 136

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

JANUARY 9, 2024

Governance and compliance are also crucial factors in ensuring enterprise cloud security as they enforce regulatory requirements and best practices within organizations. Data encryption should be applied along with robust access controls and efficient encryption key management procedures.

Strategy 130

Strategy Cloud Best Practices Government 130

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. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

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 Database Efficiency Performance 52

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. In this article, we will explain Redis sharding, explore its pros and cons, and how to apply it. How Does Redis Sharding Work?

Scalability 130

Scalability Java Efficiency Database 130

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 117

AWS Benchmarking Performance Traffic 117