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 82

Database Open Source Benchmarking Strategy 82

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

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. to monitor and diagnose. +50

Metrics 106

Metrics Monitoring Database Engineering 106

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 87

Open Source Database Best Practices Strategy 87

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. This post will give an overview of the example CLI scripts that you can run directly or use as a template to write your own. Linux example For a first example we will look at the TPROC-C workload in Tcl running on MariaDB on Linux.

C++ 83

C++ Virtualization Benchmarking Database 83

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

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. With PMM API you can easily automate database compliance checks with your existing CICD pipelines. Day-2 operations for databases are complex.

Database 103

Database Open Source Monitoring Innovation 103

Percona

FEBRUARY 16, 2023

We can verify that through the following example: We started MySQL with the configuration of “ early-plugin-load=keyring_file.so keyring_file_data=/var/lib/mysql/keyring_file mysql> create database test; mysql> show create schema testG 1. row Database: test Create Database: CREATE DATABASE `test` /*!40100

Database 116

Database Servers Engineering Testing 116

DZone

MARCH 22, 2024

This is beyond databases that just store information. Here are a few examples: Knowledge graphs are a giant web of information where elements and ideas are linked to show how they are related in the real world. Knowledge graphs also store the connections between information. This makes knowledge graphs very useful in various fields.

Database 278

Database 278

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 95

Database C++ Servers Open Source 95

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. For example, if you have an application that consumes a lot of resources, serverless may not be the cheapest option. Scale down The assumption tends to be that scaling is all about growth.

Database 80

Database Serverless Tuning Cloud 80

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

SQL Shack

OCTOBER 7, 2021

In this article, we will try to find out an answer to the “Could you Define Deadlocks with a Simple Example” question that might be asked for the database administrator interviews. Define Deadlock with a Simple Example Deadlock is a very complicated issue and sometimes it can be laborious to understand this concept.

Database 79

Database 79

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 95

Servers Database Cache C++ 95

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. For example, for GKE, you must create a VolumeSnapshotClass resource first. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. Example for mongod-data-my-cluster-name-cfg-0 : apiVersion: snapshot.storage.k8s.io/v1

Database 65

Database Storage Open Source AWS 65

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. For example, in the image above, . The index used here for example is a primary key index. Every database object has a pre-defined format.

Database 117

Database Hardware Storage Programming 117

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 203

Best Practices Azure Database Code 203

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. With multiverse databases, each user sees a consistent “parallel universe” database containing only the data that user is allowed to see.

Database 90

Database Cache Benchmarking Efficiency 90

SQL Shack

MAY 8, 2020

In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill.

Tuning 86

Tuning Servers Database Performance 86

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

SQL Shack

OCTOBER 14, 2020

Indexes are the database objects that accelerate the performance of data accessing when are designed properly. In this article, we will learn the SQL Server clustered index concept and some internal details. A clustered index is one of the main index types in SQL Server and the working principle is a bit complicated but in […].

Servers 86

Servers Database Design Performance 86

SQL Shack

AUGUST 16, 2019

A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example.

Database 79

Database Servers Monitoring 79

n0derunner

DECEMBER 17, 2018

How to reduce database restore time by 50%. Here’s a real-world example of that improvement in practice. I am using X-Ray to simulate a 1TB data restore into an existing database. The post Nutanix AES: Performance By Example. Unfortunately I only have 10Gbit networking in my lab! appeared first on n0derunner.

Performance 64

Performance Benchmarking Storage Network 64

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

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. ALTER EVENT SESSION [ ADS_Standard_Azure ] ON DATABASE. DROP EVENT sqlserver.

Azure 96

Azure Database Tuning Network 96

Dynatrace

MARCH 20, 2024

External dependencies Many applications rely on external services, such as databases, APIs, or third-party services. For instance, deploying a new version of a web application that introduces inefficient database queries could lead to increased response times and decreased user satisfaction.

Open Source 272

Open Source Hardware DevOps Infrastructure 272

DZone

APRIL 4, 2023

A common data pipeline to ingest and store financial data involves publishing real-time data to Kafka and utilizing Kafka Connect to stream that to databases. For example, the market data team may continuously update real-time quotes for a security to Kafka, and the trading team may consume that data to make buy/sell orders.

Processing 262

Processing Database Infrastructure Testing 262

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 208

Cache Azure Infrastructure Monitoring 208

Percona Community

MARCH 19, 2023

We learn how to work with HTTP requests in PHP and make API requests using the GitHub API as an example. We’ll get the data from the API and save it to the database. In the previous article, we developed a simple application that connects to the MongoDB database (Percona Server for MongoDB) and writes documents in a loop.

Servers 52

Servers Database Code Development 52

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Let’s look at a couple of examples where the sensitive data has been altered or masked. shell> /home/vagrant/pt -rw -. shell> sudo.

Database 91

Database Systems Open Source Engineering 91

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 190

Artificial Intelligence Analytics Efficiency Database 190

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Checking database library for MariaDB Error: failed to load mariatcl - couldn't load file "/home/HammerDB-4.2/lib/mariatcl0.1/libmariatcl0.1.so":

Testing 57

Testing C++ Virtualization Tuning 57

Percona Community

APRIL 6, 2023

I will tell you the real story of using database monitoring tools when developing an application. I will show you an example of how I managed to detect and fix a problem in the application.

Database 52

Database Monitoring Development Availability 52

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

DZone

JULY 11, 2022

If you are a software developer, sooner or later you’ll have to connect to a Linux machine to perform administrative tasks, access remote database servers, or deploy applications, among other things. Getting comfortable using the command-line interface (CLI) is a must if you want to be proficient with Linux.

Virtualization 268

Virtualization Database Servers Software 268

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) We'll talk about best practices and habits and use some of the Log Analytics tools from Sumo Logic as examples. Let’s blast off and turn that cosmic trash into treasure!

Best Practices 249

Best Practices Analytics Infrastructure Network 249