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

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. example.net:27019>" }, { _id : 1, host : "<cfg2.example.net:27019>"

Best Practices 73

Best Practices Traffic Database Servers 73

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. Use ETL (Extract, Transform, Load) tools to assist with this process.

Open Source 89

Open Source Database Best Practices Strategy 89

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

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. It’s a complex process involving various factors and meticulous planning. Flexibility and scalability Open source databases provide much greater flexibility regarding customization and configuration.

Open Source 94

Open Source Database Hardware Strategy 94

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. Figure 1: Plan for Query 1, row-mode processing.

Best Practices 108

Best Practices Servers Database Azure 108

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. Through this meticulous process, commits are accurately logged in their respective sequences.

Database 162

Database Strategy Servers Best Practices 162

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 109

Availability Database Open Source Hardware 109

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

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. Website monitoring examines a cloud-hosted website’s processes, traffic, availability, and resource use.

Cloud 222

Cloud Monitoring Best Practices Infrastructure 222

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 125

Database Servers Testing Programming 125

Dynatrace

DECEMBER 21, 2023

And while these examples were resolved by just asking a few questions, in many cases, the answers are more elusive, requiring real-time and historical drill-downs into the processes and dependencies specific to each host. Reduce the volume of data volumes requested from databases (for example, request all, filter in memory).

Cloud 208

Cloud Energy Best Practices Cache 208

Scalegrid

JANUARY 9, 2024

The selection process for a suitable cloud provider is crucial as it involves aligning business objectives, regulatory requirements, and current technological infrastructure with strong cloud security measures. This process involves converting regular data into a coded form, which helps to protect its privacy and guard against cyber threats.

Strategy 130

Strategy Cloud Best Practices Government 130

Dynatrace

MARCH 20, 2024

With the pace of digital transformation continuing to accelerate, organizations are realizing the growing imperative to have a robust application security monitoring process in place. This approach can determine malicious activity and block it by monitoring the flow of data within the application, all the way from the user to the database.

Monitoring 210

Monitoring Analytics Traffic Best Practices 210

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

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 188

Java Analytics Best Practices Monitoring 188

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. One such solution is pagination, which divides large datasets into manageable “pages” of data to be displayed or processed.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

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 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. In the realm of cloud-based business operations, there is an increasing dependence on complex information processing patterns. What is workload in cloud computing?

Cloud 130

Cloud Virtualization Storage Efficiency 130

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 Netflix TechBlog

MARCH 10, 2023

Hence we built the data pipeline that can be used to extract the existing assets metadata and process it specifically to each new use case. 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.

Media 237

Media Traffic Processing Design 237

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. Streamlining the CI/CD process to ensure optimal efficiency. These tasks collectively ensure uninterrupted production service.

Engineering 225

Engineering DevOps Innovation Strategy 225

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Direct net.ssl.PEMKeyFile to the path of your.pem file.

Servers 130

Servers Best Practices Government Network 130

Dynatrace

MAY 19, 2022

However, many teams struggle with knowing which ones to use and how to incorporate them into the processes. Below, several Dynatrace customers shared their SLO management journey and discussed the resulting dashboards they rely on daily to manage their mission-critical business processes and applications. What are SLOs? Saturation.

Automotive 269

Automotive Latency Architecture Azure 269

Dynatrace

JANUARY 19, 2020

Collected metrics are analyzed in Dynatrace, using the SAP expert community’s established best-practice advice on ABAP platform health indicators, including response time breakdowns of the response times between ABAP-specific application server activities, tasks, and database interaction.

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

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. Cloud migration is the process of transferring some or all your data, software, and operations to a cloud-based computing environment that offers unlimited scale and high availability.

Cloud 165

Cloud Traffic Best Practices Strategy 165

Percona

SEPTEMBER 28, 2023

Let’s review the best practices we usually follow in Managed Services before using your MySQL server in production and stage env, even for home play purposes. You can add a sizable negative score to this file to ensure that OOM killer is less likely to pick up and terminate your process. 1 Let’s quickly fix it.

Servers 114

Servers Best Practices Database Open Source 114

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Understanding the PostgreSQL Hostname Hostname is a key factor for the effective management of PostgreSQL databases and providing secure access.

Database 130

Database Servers Storage Network 130

Dynatrace

SEPTEMBER 30, 2021

It also ensures your team shares common fluency in cloud best practices, which improves collaboration and helps your company achieve a higher standard of performance. This certification is perfect for anyone who needs to learn cloud fundamentals and best practices. Cloud practitioner. Data analytics. Machine learning.

AWS 208

AWS Best Practices Analytics Cloud 208

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

OCTOBER 13, 2021

To get a clearer picture of this essential security practice, we’ll look at its different types, how the practice is changing, and how vulnerability assessment tools fit into your overall approach to managing application security. That said, vulnerability databases such as CVE , help identify known vulnerabilities.

Infrastructure 170

Infrastructure Open Source Virtualization Operating System 170

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

MAY 31, 2019

Collected metrics are analyzed in Dynatrace, using the SAP expert community’s established best-practice advice on ABAP platform health indicators, including response time breakdowns of the response times between ABAP-specific application server activities, tasks, and database interaction.

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

O'Reilly

NOVEMBER 21, 2019

This is precisely the kind of problem that robotic process automation (RPA) aims to address. She’s the vestigial human link in a process—insurance claims processing—that has a mostly automated workflow. Prior to RPA, enterprises used several different techniques to automate workflows and back-office processes.

Processing 83

Processing Programming Virtualization Technology 83

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. This marks the end of an era of chaos, paving the way for efficiency gains, quicker innovation, and standardized practices.

Cloud 81

Cloud Open Source Strategy Best Practices 81

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02 order by c. 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 40

Dynatrace

MARCH 22, 2023

For this, best practices would be to segregate commands from data, use parameterized SQL queries, and eliminate the interpreter by using a safe application program interface, if possible. Security misconfiguration Security misconfiguration covers the basic security checks every software development process should include.

Open Source 197

Open Source Artificial Intelligence Internet Internet 197