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. Keeping ownership teams and their properties up to date is essential, as is having the right contact information available when needed. Contact us to schedule a demo.

Best Practices 201

Best Practices Azure Database Code 201

Dynatrace

FEBRUARY 9, 2023

We recently extended the pre-shipped code-level API definitions to group logical parts of our code so they’re consistently highlighted in all code-level views. Another benefit of defining custom APIs is that the memory allocation and surviving object metrics are split by each custom API definition.

Java 211

Java Metrics Servers Code 211

Percona

OCTOBER 10, 2023

mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 92

Database Performance C++ Engineering 92

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

Scalegrid

JANUARY 8, 2019

In Part I , we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Semisynchronous replication, which is natively available in MySQL, helps the HA framework to ensure data consistency and redundancy for committed transactions. rpl_semi_sync_master_timeout.

Availability 113

Availability Tuning Speed Network 113

Dynatrace

AUGUST 9, 2023

Experience with the recent MOVEit vulnerability illustrated some of the key incomplete data challenges organizations face when trying to find definitive answers to questions like “were we exploited?” Security Analytics with Davis® AI , the Grail data lakehouse, AutomationEngine, and Notebooks are all available for customers to use today.

Analytics 220

Analytics Metrics Database Storage 220

Dynatrace

APRIL 10, 2023

We also couldn’t compromise on performance and availability.” But “the benefits are definitely worth the effort, provided you do it in a strategic way,” Bollampally said. “We set up Dynatrace dashboards to help us see the response times of the database and the orders being placed on a day-to-day basis. .

Cloud 173

Cloud Ecommerce Performance Retail 173

Dynatrace

DECEMBER 2, 2021

On the Service-level objectives page, the Actions > Edit SLO entry has been renamed SLO definition. It opens the corresponding SLO on the Service-level objective definitions page, where you can view or edit the SLO definition (depending on your permissions). General Availability (Build 1.231.196). Dashboards.

Lambda 196

Lambda Azure Metrics Monitoring 196

Dynatrace

MAY 19, 2022

Feature flag solutions currently use proprietary SDKs with frameworks, definitions, and data/event types that are unique to their platforms. As the project matures, more robust sources for flag configuration could be used, perhaps a simple REST API, database, or structured configuration file. What’s next?

Java 259

Java Cloud Code Technology 259

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. All the data bound to hosts is analyzed by the Davis AI causation engine and made available on custom dashboards and events pages. Why use Extensions. So whether you want to….

Metrics 171

Metrics Monitoring Network Technology 171

Percona

APRIL 11, 2023

Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. The unique quiz Consider the following MySQL table definition. While these may not be exact duplicates, they can still negatively impact database performance.

Database 88

Database Open Source Testing Design 88

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. Once the authentication succeeds: PgBouncer checks for a cached connection, with the same username+database combination. pgBouncer Architecture | Source.

Cache 246

Cache Database Architecture Servers 246

Percona

NOVEMBER 1, 2023

Deeper dive We will review the differences between cluster-wide and namespace-scoped through the prism of security, availability, and performance. Availability Operators are responsible for deploying new and managing existing database clusters. This is quite similar to the availability problem.

Database 78

Database Availability Strategy Infrastructure 78

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 90

Storage Database Engineering Open Source 90

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. Percona is an open source database software, support, and services company that helps make databases and applications run better. Reserved words added to 8.0 So what happens if I use a reserved word?

Open Source 114

Open Source Database Servers Scalability 114

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. Simply put, infrastructure monitoring is the oxygen to your infrastructure, collecting all the data for a complete picture of availability, performance, and resource efficiency.

Infrastructure 203

Infrastructure Monitoring Virtualization Serverless 203

Dynatrace

NOVEMBER 3, 2021

Monitoring , by textbook definition, is the process of collecting, analyzing, and using information to track a program’s progress toward reaching its objectives and to guide management decisions. Experienced database administrators learn to spot patterns that can lead to common problems. Monitoring vs. observability.

Monitoring 223

Monitoring Metrics DevOps Scalability 223

Percona

MAY 9, 2023

The term is inherently ominous, and a broad definition isn’t much cheerier. To determine whether that perception is warranted in the database software industry — and if so, how to avoid vendor lock-in pitfalls — let’s dig deeper. They both suggest limited or lost freedom. Ask about data portability.

Open Source 87

Open Source Database Innovation Cloud 87

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope.

Database 99

Database Servers Open Source Tuning 99

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, sec) The alteration appears successful, and we see the table definition accordingly modified. However, there are caveats.

Storage 77

Storage Database Open Source Engineering 77

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. This is not something you can do on a replica node. And we are back at square one.

Analytics 185

Analytics Storage Database Systems 185

Percona

NOVEMBER 7, 2023

The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to order a printed copy became available ( [link] ). This 548-page tome from PostgresPro covers the spectrum from data organization to details on the many available indexing options.

Cache 84

Cache Servers Operating System Database 84

Scalegrid

FEBRUARY 7, 2019

Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. High Availability. It also implements a Raft -like consensus approach to ensure availability of the entire cluster.

Java 138

Java Database Availability AWS 138

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 79

Open Source Programming Database Servers 79

The Netflix TechBlog

JULY 30, 2019

The Netflix Media Database (NMDB) is one such example. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. To improve usability and operability, we added validations, which in practice has greatly helped find bugs during creation of workflow and task definitions.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition. After the rapid release 6.2

Metrics 98

Metrics C++ Storage Database 98

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 79

Speed Virtualization Storage Open Source 79

Dynatrace

APRIL 21, 2022

If you still use the legacy version of Log Monitoring ( Log Monitoring v1 ), the Log Monitoring v1 documentation is still available, but we strongly encourage you to switch to the latest Dynatrace Log Monitoring version and gain direct access to the log content of all your mission-critical processes. General Availability (Build 1.239.178).

Azure 218

Azure Metrics AWS Monitoring 218

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. So, given a table_id, how do you get the table schema/definition? This phase has no concept of a row or a transaction.

Cache 83

Cache Benchmarking Servers Design 83

CSS Wizardry

JULY 23, 2023

I am available to help you find and fix your site-speed issues through performance audits , training and workshops , consultancy , and more. But for many queries, there is lots of helpful content available. I’m available for hire to help you out with workshops , consultancy , advice , and development. . You should get in touch.

Engineering 246

Engineering Google Speed Mobile 246

SQL Performance

MAY 24, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. The WINDOW Clause. The Windowing NULL Treatment Clause.

Servers 145

Servers C++ Code Database 145

The Netflix TechBlog

JANUARY 25, 2023

Annotations Sometimes people describe annotations as tags but that is a limited definition. All data should be also available for offline analytics in Hive/Iceberg. A data model in Marken can be described using schema — just like how we create schemas for database tables etc. So the amount of data stored can be large.

Scalability 283

Scalability Latency Media Architecture 283

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. And if the query processes 100 million rows, that’s definitely not trivial!

Database 92

Database Analytics Storage Processing 92

Percona

APRIL 10, 2023

In this blog post, I’m going to present a new functionality that is available in MyDumper and will be available in the next release: we added the possibility to build random data based on a format that the user defines. During export, mydumper sends SELECT statements to the database. How does it work?

Testing 102

Testing C++ Open Source Database 102

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

Percona

APRIL 26, 2023

When a project’s source code is available to all, the question of security isn’t far behind. Open source databases, like MySQL and PostgreSQL, are among the most widely used and popular databases for workloads large and small. WordPress, in fact, powers this blog and uses a MySQL database to store its content.)

Open Source 81

Open Source Software Software Social Media 81

High Scalability

MAY 4, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Make your job search O (1), not O ( n ). Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100