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

MARCH 20, 2024

Identification The identification stage of application security monitoring involves discovering and pinpointing potential security weaknesses within an application’s code, configuration, or design. What are application security monitoring best practices?

Monitoring 205

Monitoring Analytics Traffic Best Practices 205

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

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

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

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. Use a safe development life cycle with secure design patterns and components. Apply threat modeling and plausibility checks.

Open Source 191

Open Source Artificial Intelligence Internet Internet 191

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. Core AWS certifications. Cloud practitioner.

AWS 202

AWS Best Practices Analytics Cloud 202

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 10, 2023

Designing systems for reliability Engineering teams must extend their focus beyond functional and load tests to instill assurance in the software release process via automated cycles. In our next blog post in this series, we’ll delve into the step-by-step process of automating the release pipeline using Dynatrace best practices.

Engineering 219

Engineering DevOps Innovation Strategy 219

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. Best practices for a successful cloud migration. By establishing these, you can work backward to ensure every step of the process is designed to serve these outcomes.

Cloud 161

Cloud Traffic Best Practices Strategy 161

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

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 77

Cloud Open Source Strategy Best Practices 77

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 95

Monitoring Scalability Cache Database 95

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 96

Database Engineering Best Practices Open Source 96

Percona

NOVEMBER 2, 2023

On October 24th, the Percona Kubernetes Squad held the first Ask-me-Anything (AMA) session to address inquiries regarding the utilization of Kubernetes for database deployment. Q1: When is it appropriate to use Kubernetes for databases, and when is it not recommended? ” This talk covers this topic exactly.

Open Source 83

Open Source Hardware Storage Database 83

Percona

APRIL 20, 2023

pt-query-digest As best practice dictates gathering and testing all application queries by activating the slow log for a period of time, most companies will end up with an enormous amount of slow log data. The MySQL Shell Upgrade Checker is designed to help users avoid potential issues that may arise during the upgrade process.

Open Source 87

Open Source Best Practices Servers Database 87

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

Adrian Cockcroft

NOVEMBER 26, 2023

In this session, learn how AWS has been supporting customers like the Territorial Intelligence Centre (CIT) in designing cutting-edge tools to address traceability in supply chains with deforestation risks by integrating governmental databases, innovative map services, and land-use data from high spatial resolution satellite imagery.

AWS 52

AWS Energy IoT Best Practices 52

Dynatrace

NOVEMBER 23, 2020

Kubernetes Dashboard as a part of a comprehensive monitoring solution This article introduces the key building blocks to consider when designing your Kubernetes monitoring solution. When designing and running modern, scalable, and distributed applications, Kubernetes seems to be the solution for all your needs. Cloud platform layer.

Virtualization 159

Virtualization Infrastructure Monitoring Cloud 159

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. The first one, written by Peter Zaitsev, was Installing MySQL with Docker.

Scalability 58

Scalability Best Practices Servers Database 58

High Scalability

DECEMBER 18, 2018

You will bring best practices for automating the provisioning and patching of servers, replicating and versioning configuration changes, monitoring and alerting, deploying application and data store updates, and high availability / disaster recovery. Need excellent people? Advertise your job here! Fun and Informative Events.

Healthcare 122

Healthcare Best Practices DevOps Cache 122

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

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 89

Open Source Database Hardware Strategy 89

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

Particular Software

AUGUST 19, 2019

From Udi Dahan's Advanced Distributed Systems Design Course , Day 1 Solutions Unfortunately, security tends to be one of those areas that goes completely overlooked until it's too late. Design secure systems: See what Udi has to say in Day 1 of his Advanced Distributed Systems Design video course. That's just simple economics.

Network 40

Network Best Practices Database Internet 40

Testlodge

NOVEMBER 1, 2021

For example, it’s usual for software to have been designed with a specific use in mind, but the user doesn’t always understand the same way as the developers and testers. It’s often the Marketing or Design team who provide personas. It’s mentioned here as a means of crashing or breaking a system. Conclusion.

Systems 81

Systems Testing Software Software 81

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. 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.

Best Practices 117

Best Practices C++ Database Code 117

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 85

Database Hardware Open Source Strategy 85

Adrian Cockcroft

JUNE 21, 2022

We had specializations in hardware, operating systems, databases, graphics, etc. Jim Mauro and Allan Packer visited on rotation from New Jersey, and Adelaide Australia, and worked out how to produce a database sizing guide for Oracle Financials, which I wrote up and published. Jim also joined the database performance team.

Tuning 52

Tuning Benchmarking Engineering C++ 52

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 121

Database Servers Testing Programming 121

Abhishek Tiwari

APRIL 14, 2018

Generally speaking, formal modeling can reduce implementation time and save money by adopting structural patterns and best-practices when implementing ETL workflows. First and foremost, modeling ETL process helps in designing an efficient, robust and evolvable ETL. Data Mapping Diagrams for Data Warehouse Design with UML ??.

Best Practices 40

Best Practices Database Design Efficiency 40

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 Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Best practices on Building a Big Data Analytics Solution – Michael Rys.

Engineering 40

Engineering Azure Best Practices Servers 40

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 104

Availability Database Open Source Hardware 104

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. In this example, we have a CRM database of user data that we need to page through and display 10 users at a time. So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Tasktop

JANUARY 9, 2020

Moreover, unique (and unpublished) database schemas per tool require in-depth exploration that steals a lot of precious time from software delivery specialists who should be focusing on their job, not on wading through endless data lakes. Ensuring Tools and Practices are Being Adopted.

Software 59

Software Software Metrics Database 59

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 70

Best Practices Traffic Database Servers 70