Percona

MAY 6, 2024

MongoDB offers powerful features and scalability, but like any database system, it has security challenges that must be addressed to protect sensitive data as well as comply with regulatory standards like GDPR, HIPAA, PCI DSS, and AM/ATF.

Best Practices 84

Best Practices Database Scalability Systems 84

DZone

NOVEMBER 21, 2023

With the help of exporters, Prometheus can provide insightful data and effectively monitor a variety of services, including databases, web servers, and custom-made applications. Paired with Prometheus exporters, the tool can adapt to a variety of surroundings, which is one of its strongest points.

Best Practices 292

Best Practices Scalability Monitoring Database 292

Dynatrace

MARCH 27, 2024

As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow. A dedicated workflow allows automatic synchronization of the database information with Dynatrace and keeps the ownership team information up-to-date.

Best Practices 199

Best Practices Azure Database Code 199

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 83

Best Practices Hardware Tuning Scalability 83

Scalegrid

NOVEMBER 20, 2019

There will be a short duration (tens of seconds) during which you will lose connectivity to your database due to the failover, but this can be overcome by having application-level retries. Best Practice for Creating Indexes on your #MySQL Tables Click To Tweet. Performance Benefits of Rolling Index Creation.

Best Practices 239

Best Practices Latency Tuning Database 239

Scalegrid

DECEMBER 16, 2020

Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL service providers.

Best Practices 290

Best Practices Database Servers Performance 290

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

Percona

JUNE 4, 2024

MongoDB’s flexibility and speed make it a popular database choice, but as your data grows, managing and querying massive datasets can become challenging. This is where partitioning, also known as sharding, comes to the rescue.Partitioning strategically divides your data collection into smaller, more manageable chunks.

Best Practices 72

Best Practices Scalability Performance Speed 72

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

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. What is the Recovery Time Objective? How do you know the backup succeeded?

Best Practices 77

Best Practices Storage Strategy Database 77

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 53

Best Practices Open Source Scalability Database 53

DZone

MAY 23, 2019

How do you tune the Snowflake data warehouse when there are no indexes, and few options available to tune the database itself? This article summarizes the top five best practices to maximize query performance. Snowflake was designed for simplicity, with few performance tuning options.

Best Practices 100

Best Practices Tuning Performance Database 100

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

Simform

SEPTEMBER 22, 2022

Amazon DynamoDB is one of the fastest-growing database services today. However, it is a NoSQL database that requires data modeling quite different from SQL databases. In this blog post, you will find out some best practices by our experts for working with DynamoDB.

Best Practices 64

Best Practices AWS Performance Database 64

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 89

Database Open Source Best Practices Strategy 89

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 69

Best Practices Traffic Database Servers 69

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 83

Open Source Database Best Practices Strategy 83

Software Testing Help

FEBRUARY 10, 2021

Learn what is Database Security and related concepts like security threats, best practices to follow, testing types, techniques, testing process, etc: In this tutorial, we will explore what is database. Read more What Is Database Security Testing – Complete Guide.

Database 101

Database Best Practices Testing Software 101

DZone

JULY 6, 2023

Azure Cosmos DB is a highly scalable and globally distributed NoSQL database service offered by Microsoft. In this blog post, we will explore best practices and tips for optimizing performance in Azure Cosmos DB. Indexing Strategy As with the other databases, indexing is the first go-to option to improve query performance.

Azure 265

Azure Performance Best Practices Strategy 265

Percona

AUGUST 1, 2023

Source: “Meowing” attack completely destroyed more than 1000 databases These are the words of Bob Diachenko, one of the most respected cybersecurity researchers in relation to a “Meowing” attack, which destroyed between 1000-4000 databases around the world. MongoDB databases commonly exceed a terabyte of data.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. At any rate, make sure to remember the best practice here!

Best Practices 108

Best Practices Servers Database Azure 108

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 103

Availability Database Open Source Hardware 103

SQL Performance

SEPTEMBER 12, 2019

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. In the meanwhile, there's a best practice that can help you avoid the bug.

Best Practices 103

Best Practices C++ Code Design 103

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 120

Database Servers Testing Programming 120

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 88

Open Source Database Hardware Strategy 88

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) We'll talk about best practices and habits and use some of the Log Analytics tools from Sumo Logic as examples. Let’s blast off and turn that cosmic trash into treasure!

Best Practices 256

Best Practices Analytics Infrastructure Network 256

SQL Performance

JUNE 14, 2019

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. In my examples I’ll use a sample database called TSQLV5. Previously I covered determinism and subqueries.

Best Practices 93

Best Practices C++ Database Processing 93

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 84

Database Hardware Open Source Strategy 84

Dynatrace

JANUARY 11, 2023

Database monitoring. This ensures the database queries are performant, while also identifying host problems. For example, uptime detection can identify database instability and help to improve mean time to restoration. Best practices to consider. Website monitoring. Cloud storage monitoring.

Cloud 223

Cloud Monitoring Best Practices Infrastructure 223

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. This month I covered subquery-related bugs, pitfalls and best practices. This time I focus on classic bugs involving subqueries. Conclusion.

Best Practices 68

Best Practices C++ Code Servers 68

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

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 9, 2024

Governance and compliance are also crucial factors in ensuring enterprise cloud security as they enforce regulatory requirements and best practices within organizations. They seamlessly integrate with popular databases including MongoDB, Redis, MySQL, and PostgreSQL while utilizing their respective built-in security frameworks.

Strategy 130

Strategy Cloud Best Practices Government 130

SQL Shack

JANUARY 13, 2020

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred.

Database 83

Database Best Practices Design Performance 83

Dynatrace

JANUARY 31, 2024

SAP Basis teams have established best practices for managing their SAP systems. Teams benefit from a boost in aligning SAP operations practices with the operation of all surrounding systems that SAP depends on and those that depend on SAP. It can also directly access database tables under the strict control of DBAs.

Java 189

Java Analytics Best Practices Monitoring 189

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

Dynatrace

DECEMBER 21, 2023

The Application Performance Management (APM) best practices we recommend to optimize user experience and application performance—driven initially by on-premises workloads and finite compute capacity—contribute to improved computational efficiency by reducing CPU cycles, optimizing inter-process communications, and lowering memory footprints.

Cloud 209

Cloud Energy Best Practices Cache 209