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 85

Availability Open Source Architecture Database 85

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Open-source software drives a vibrant Kubernetes ecosystem. Strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Open source software drives a vibrant Kubernetes ecosystem.

Open Source 337

Open Source Java Operating System Programming 337

Scalegrid

AUGUST 22, 2019

In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your PostgreSQL hosting deployment. Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover. Patroni for PostgreSQL.

Availability 277

Availability Servers Network Open Source 277

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 89

Database Hardware Open Source Strategy 89

Percona

SEPTEMBER 21, 2023

You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. First-time presenters welcome! What happens At SCaLE?

Open Source 112

Open Source Programming Software Software 112

Percona

JULY 24, 2023

To make sure that Percona Backup for MongoDB answers the pains of our customers, we took the common denominator of the pains that anyone using snapshot capabilities faces when performing backups and restores and positioned PBM as the open source, freely available answer to those pains. Now why Technical Preview, you may ask?

Availability 77

Availability Open Source Strategy Storage 77

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 98

Database C++ Servers Open Source 98

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool?

Open Source 262

Open Source Database Azure Cloud 262

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 106

Database Benchmarking Latency C++ 106

Dynatrace

FEBRUARY 12, 2024

The various presenters in this session aligned platform engineering use cases with the software development lifecycle. This is so they see all the things they are used to from open source tools from other solutions, and from kubectl right within Dynatrace.

Engineering 175

Engineering Development Infrastructure Cloud 175

Alex Podelko

APRIL 18, 2021

MongoDB shared a lot of information on how we do performance testing and even open sourced some parts of it. David Daly’s presentation at LTB 2020 , How to Waste Time and Money Test ing the Performance of a Software Product, is probably a good introduction [Video] — [Slides]. The MongoDB Podcast, Ep.

Performance Testing 182

Performance Testing Performance Testing Education 182

Dynatrace

NOVEMBER 23, 2020

To ensure observability, the open source CNCF project OpenTelemetry aims at providing a standardized, vendor-neutral way of pre-instrumenting libraries and platforms and annotating UserLAnd code. Getting specific metrics from libraries that are pre-instrumented with OpenTelemetry (for example, database drivers).

Metrics 150

Metrics Open Source Tuning Analytics 150

Dynatrace

OCTOBER 6, 2022

OpenTelemetry is an exciting open source observability standard that provides a common collection of tools, APIs, and SDKs to help collect observability signals. You can ingest OpenTelemetry data in two ways: using Dynatrace OneAgent technology or using OpenTelemetry Protocol (OTLP), which relies exclusively on open source technology.

Open Source 167

Open Source Metrics Tuning Technology 167

Percona

OCTOBER 17, 2023

However, when you clone a replica that already has a huge dataset, you may not have enough space for two datasets: one from the source server and data present on the replica. This way, you will have a new instance with a small data directory, so you can use option DATA DIRECTORY without fear of exceeding available disk space.

Open Source 99

Open Source Servers Database Strategy 99

Dynatrace

SEPTEMBER 23, 2021

Application developers commonly leverage open-source software when building containerized applications. In fact, the market research firm Forrester says that the average container image is comprised of 70% open-source software.[1] 1] And unfortunately, open-source software is often fraught with security vulnerabilities.

Open Source 243

Open Source Benchmarking Best Practices Network 243

Percona

SEPTEMBER 6, 2023

Some of these joins are only available natively in some relational databases; for the sake of simplicity, we will only consider the most widely used open-source databases in this blog- MySQL and PostgreSQL. For the rows not present in other tables, NULL will be displayed for the columns of the other table.

Open Source 94

Open Source Database Monitoring Testing 94

Percona

NOVEMBER 6, 2023

localhost The use of the characters % and _ as wildcards in database-level grants is now deprecated. TO dave will grant user dave access to all the tables in database dave_ but not dave1, davex, or davey. The requirement that the primary must be running the lowest MySQL version present in the group is still in place.

Open Source 111

Open Source Database Servers Scalability 111

Percona

FEBRUARY 15, 2023

Bloom filters are an essential component of an LSM-based database engine like MyRocks. If all the bits are “1”, the value may be present. A good understanding of how bloom filters work can only lead to improved database performance. This post will illustrate through a simple example how bloom filters work in MyRocks.

Storage 129

Storage Tuning Cache Engineering 129

Dynatrace

DECEMBER 8, 2020

Open source has also become a fundamental building block of the entire cloud-native stack. While leveraging cloud-native platforms, open-source and third-party libraries accelerate time to value significantly, it also creates new challenges for application security.

Cloud 284

Cloud Open Source Internet Internet 284

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Without it, sending an email over a long distance would require the immediate availability of every node on the routing network to forward each message. For all its virtues, message queuing presents some challenges from an observability perspective.

Monitoring 192

Monitoring Serverless Programming Speed 192

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Without it, sending an email over a long distance would require the immediate availability of every node on the routing network to forward each message. For all its virtues, message queuing presents some challenges from an observability perspective.

Monitoring 191

Monitoring Serverless Programming Speed 191

Percona

DECEMBER 6, 2023

In this post, I will present a new Percona tool: Percona Monitoring and Management (PMM) Dump. First General Availability version of PMM Dump was released on November 22, 2023. Unofficial ARM packages are available at [link]. bin source=vm. In Percona Support , we help our customers to resolve performance issues.

Monitoring 98

Monitoring Metrics Analytics Open Source 98

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

FEBRUARY 24, 2023

Let’s take a look at how to get the benefits you need while spending less, based on the recommendations presented by Dani Guzmán Burgos, our Percona Monitoring and Management (PMM) Tech Lead, on this webinar (now available on demand) hosted in November last year. These color-coded states on panels are available in PMM 2.32.0

Cloud 120

Cloud Serverless AWS Storage 120

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. When this data block is read, it decompresses it in memory and presents it to the incoming request. At the time of insert ops, no other queries or DML ops were running in the database.

Storage 110

Storage Network Open Source Latency 110

Percona

OCTOBER 12, 2023

Replica Sets provide high availability and redundancy to MongoDB clusters. Replica Set configuration problem Successful failover does not mean the replica set is fully available, though! State': '(not reachable/healthy)' } source: localhost:27138 { 'no replication info, yet. However, after some time (not immediately!),

Open Source 91

Open Source Traffic Availability Database 91

Percona

APRIL 3, 2023

The bsondump tool is part of the MongoDB Database Tools package. Run bsondump from the system command line: bsondump --outFile=collection.json collection.bson It will create a JSON file ( collection.json ) from an existing BSON document ( collection.bson ), like the ones created after backing up your database. Set the database (e.g.,

Database 100

Database Programming Open Source Network 100

The Morning Paper

SEPTEMBER 17, 2019

Updating graph databases with Cypher Green et al., Cypher for Apache Spark , and Cypher over Gremlin projects are also both available in open source. Cypher for Apache Spark , and Cypher over Gremlin projects are also both available in open source. VLDB’19. Emphasis mine).

Database 70

Database Logistics Healthcare Retail 70

Percona

OCTOBER 13, 2023

the information is presented within serialized objects within the dictionary. 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

Storage 95

Storage Database Engineering Open Source 95

Percona

SEPTEMBER 28, 2023

This file is present in /proc/$pid/oom_score_adj. The kernel’s memory allocation function allocates the requested page size, and sometimes more, rounded up to fit within the available memory. ’ This means that if the server cannot find a full page available in a row, it will defragment the memory before allocating it.

Servers 114

Servers Best Practices Database Open Source 114

Percona

SEPTEMBER 20, 2023

. $ pt-config-diff h=localhost /etc/my.cnf $ Things to be aware of The tool will only compare the values for parameters present in both sources. if the max_connections parameter is not present in the configuration file (MySQL was running with the default value), pt-config-diff won’t show the value in the output.

Open Source 92

Open Source Servers Scalability Database 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 107

Testing C++ Open Source Database 107

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The database installation must include both the include and lib directories. linux-glibc2.12-x86_64/bin.

C++ 113

C++ Database Open Source Servers 113

Percona

MARCH 6, 2023

So in this one, I want to focus on two things: Present the new way of working with Redo Logs (No longer innodb_log_file_size / innodb_log_files_in_group ). If you want an answer based on detailed information about your database usage and patterns, it’s recommended to use Percona Management and Monitoring. MB per minute ( 3.74

Tuning 91

Tuning Open Source Database Engineering 91

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. The above diagram shows the information present in a checkpoint, while the below output shows how it looks when listed using the “wt” utility. $ Journal, on the one hand, is an append-only operation in a journal file, AKA transaction log file present on disk.

Hardware 89

Hardware C++ Storage Cache 89

Percona

AUGUST 18, 2023

and this transition presented several challenges. It also shows the importance of thorough testing in complex database upgrades. I hope it encourages others facing similar obstacles during database migrations to consider alternative strategies and embrace the power of testing for successful outcomes. to MySQL 8.0,

Open Source 67

Open Source Database Storage Engineering 67