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 69

Best Practices Traffic Database Servers 69

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. They’re proven and ready-to-go.

Architecture 92

Architecture Availability Open Source Healthcare 92

Dynatrace

JANUARY 11, 2023

With more organizations taking the multicloud plunge, monitoring cloud infrastructure is critical to ensure all components of the cloud computing stack are available, high-performing, and secure. Cloud monitoring is a set of solutions and practices used to observe, measure, analyze, and manage the health of cloud-based IT infrastructure.

Cloud 227

Cloud Monitoring Best Practices Infrastructure 227

SQL Shack

NOVEMBER 9, 2020

In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s. Introduction to policy-based management Policy-Based Management feature allows database professional in defining the best practices, standards for SQL Server and database related configurations.

Availability 89

Availability Servers Best Practices Database 89

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. Three distinct modes are available within MySQL when setting up your binary logs’ format.

Database 162

Database Strategy Servers Best Practices 162

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 80

Availability Open Source Architecture Database 80

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

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 108

Servers Best Practices Database Open Source 108

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. 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. Setting Up MySQL Server Logging.

Servers 247

Servers Best Practices Efficiency Availability 247

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 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. SAP HANA server infrastructure monitored with OneAgent.

Java 194

Java Analytics Best Practices Monitoring 194

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

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. you can now use an external VictoriaMetrics database for monitoring in PMM. Take a look.

Servers 72

Servers Monitoring Open Source Scalability 72

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. All rely heavily on utilizing allocated portions from existing pools made available through specific providers as part of their service offerings.

Cloud 130

Cloud Virtualization Storage Efficiency 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

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.

Servers 130

Servers Best Practices Government Network 130

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. You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. Dynatrace news. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 155

Monitoring Best Practices Infrastructure Servers 155

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.

Open Source 244

Open Source Tuning C++ Database 244

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

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. When all data-bearing replica set members are available, and the index is created with default commitQuorum , below are the details from the Primary and the Secondary nodes. Starting from PSMDB 4.4,

Servers 77

Servers C++ Storage Best Practices 77

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

MAY 19, 2022

Every organization’s goal is to keep its systems available and resilient to support business demands. This view shows the availability SLO for key application functions, like login and vehicle list, as well as a large set of timeframes, like last 30 minutes, last hour, today, and last six days. Dynatrace news. Saturation.

Automotive 275

Automotive Latency Architecture Azure 275

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. 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.

Open Source 203

Open Source Artificial Intelligence Internet Internet 203

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. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 101

Performance Monitoring Traffic Database 101

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 161

Monitoring Best Practices Programming Infrastructure 161

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 169

Cloud Traffic Best Practices Strategy 169

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. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 86

Open Source Best Practices Servers Database 86

The Netflix TechBlog

DECEMBER 11, 2020

For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. We engaged with them to determine graph schema best practices to best suit the needs of Studio Engineering. The schema registry is developed in-house, also in Kotlin.

Architecture 249

Architecture Best Practices Engineering Open Source 249

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

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. We have several YouTube Tutorials and blog posts available that show how you can use Dynatrace RUM data for Web Performance & User Experience Optimization. Too much data requested from a database, e.g. Request all and filter in memory.

Cache 201

Cache Architecture Database Government 201

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. They also make it easier to manage containers at scale.

Architecture 206

Architecture Serverless Azure Programming 206

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. or a later release.

Database 96

Database Engineering Best Practices Open Source 96

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

The Netflix TechBlog

JUNE 25, 2021

Netflix’s internal teams strive to provide leverage by investing in easy-to-use tooling that streamlines the user experience and incorporates best practices. Dynomite is a high-speed in-memory database, providing highly available cross datacenter replication while preserving Redis-like semantics. The server is a Node.js

Metrics 152

Metrics Best Practices Strategy Design 152