Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 205

Infrastructure Database Monitoring Metrics 205

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 93

Architecture Availability Open Source Healthcare 93

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 81

Availability Open Source Architecture Database 81

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 77

Availability Hardware Open Source Database 77

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

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here. What’s your documentation plan?

Database 80

Database Open Source Benchmarking Strategy 80

Percona

FEBRUARY 24, 2023

As a result, it becomes increasingly important to protect the confidentiality of information to prevent data leaks and facilitate easy access to relevant data sources and tools for the related teams without having to sift through unrelated databases or environmental data. What options regarding access control are currently available in PMM?

Metrics 104

Metrics Monitoring Database Engineering 104

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

Dynatrace

AUGUST 3, 2020

For example: To provide support, you need a remote desktop service to be available. You also require part of your infrastructure to serve an MS SQL database with MS Distributed Transaction Coordinator. Easily create availability checks for your Windows services. Alerts for Windows service availability.

Infrastructure 156

Infrastructure Availability Monitoring Operating System 156

Dynatrace

MARCH 27, 2024

The automated extraction of ownership information, for example, from Kubernetes annotations, is therefore essential. 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.

Best Practices 204

Best Practices Azure Database Code 204

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 85

Open Source Database Best Practices Strategy 85

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 110

Open Source Database Software Software 110

Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Now, with Oracle database insights, we’re going even deeper, giving you visibility into what’s going on in the database layer.

Database 128

Database Metrics Cache Servers 128

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. significantly enhanced downgrade compatibility by introducing changes that make it easier for downgraded databases to interoperate with older MongoDB versions.

Database 84

Database Artificial Intelligence Servers Operating System 84

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Linux native Input/Output (I/O) statistics Pipe viewer utility By following these approaches, we can effectively monitor the restoration process and manage your MySQL database restoration efficiently.

Database 80

Database Monitoring C++ Speed 80

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Percona

FEBRUARY 24, 2023

Today, we are excited to announce the release of Percona Monitoring and Management (PMM) V2.35 , including a tech preview of label-based access control, the general availability of Helm Chart, and a range of enhancements to our Database as a Service (DBaaS) offerings, among other improvements and features. Stay tuned!

Availability 92

Availability Metrics Monitoring Open Source 92

Dynatrace

MARCH 20, 2024

External dependencies Many applications rely on external services, such as databases, APIs, or third-party services. Infrastructure health The underlying infrastructure’s health directly impacts application availability and performance. Consider a scenario where a web application depends on an external payment gateway.

Open Source 272

Open Source Hardware DevOps Infrastructure 272

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 93

Database C++ Servers Open Source 93

Percona

JANUARY 5, 2023

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. PostgreSQL and other database management systems use MVCC to ensure consistent reads and prevent data loss from concurrent updates. It is essential to run a vacuum to keep the database running smoothly periodically.

Database 105

Database Performance C++ Efficiency 105

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

Percona

NOVEMBER 1, 2023

Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00 MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23.

Servers 93

Servers Database Cache C++ 93

Dynatrace

JANUARY 31, 2024

For example, a Stanford University and UC Berkeley team noted in a research study that ChatGPT behavior deteriorates over time. Using the example of a chatbot, once the user submits a natural language prompt, RAG summarizes that prompt using semantic data. Consequently, AI model drift and hallucinations emerge as primary concerns.

Cache 209

Cache Azure Infrastructure Monitoring 209

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read.

Database 106

Database AWS Network Design 106

High Scalability

APRIL 16, 2019

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability.

Availability 149

Availability Network Azure AWS 149

Dynatrace

FEBRUARY 1, 2024

But organizations must also be aware of the pitfalls of AI: security and compliance risks, biases, misinformation, and lack of insight into critical metrics (including availability, code development, infrastructure, databases, and more). In this example, there is a suspicious increase in scripting events.

Artificial Intelligence 191

Artificial Intelligence Analytics Efficiency Database 191

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc.

AWS 52

AWS Database Serverless Storage 52

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. It opens doors to support more exciting use-cases.

Storage 288

Storage Cache Metrics Database 288

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency. Fault-tolerance.

Database 213

Database Latency C++ Scalability 213

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

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Dynatrace

MAY 17, 2023

For that, we focused on OpenTelemetry as the underlying technology and showed how you can use the available SDKs and libraries to instrument applications across different languages and platforms. Let’s take our previous screenshot as an example. OneAgent is the native telemetry data collector and monitoring solution of Dynatrace.

Metrics 175

Metrics Monitoring Database Network 175

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. 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

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. Load and 2.

Benchmarking 308

Benchmarking Latency C++ Database 308

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. Database monitoring. This ensures the database queries are performant, while also identifying host problems. Website monitoring.

Cloud 227

Cloud Monitoring Best Practices Infrastructure 227