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 77

Open Source Database Storage Scalability 77

Percona

MAY 29, 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. Today’s post includes those releases and updates that have come out since May 8, 2023.

Open Source 79

Open Source Servers Scalability Database 79

Dynatrace

FEBRUARY 16, 2023

The goal is to turn more data into insights so the whole organization can make data-driven decisions and automate processes. Grail data lakehouse delivers massively parallel processing for answers at scale Modern cloud-native computing is constantly upping the ante on data volume, variety, and velocity.

Analytics 182

Analytics Innovation Metrics Database 182

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

Percona

JULY 24, 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. Today’s post includes those releases and updates that have come out since July 10, 2023.

Open Source 74

Open Source Scalability Database Monitoring 74

Dynatrace

APRIL 10, 2023

And according to recent data from Enterprise Strategy Group, 59% of survey respondents indicated spending on public cloud applications would increase in 2023. discussed the 85-year-old retailer’s cloud migration journey and the importance of multicloud observability at Dynatrace Perform 2023. Further, as Tractor Supply Co.

Cloud 168

Cloud Ecommerce Performance Retail 168

Percona

DECEMBER 6, 2023

First General Availability version of PMM Dump was released on November 22, 2023. Unofficial ARM packages are available at [link]. 2023-01-05T20:01:33+03:00 INF Processing 1/49 chunk. 2023-01-05T20:01:33+03:00 INF Processing 2/49 chunk. 2023-01-05T20:01:33+03:00 INF Processing 3/49 chunk.

Monitoring 99

Monitoring Metrics Analytics Open Source 99

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. It’s a complex process involving various factors and meticulous planning. Flexibility and scalability Open source databases provide much greater flexibility regarding customization and configuration.

Open Source 94

Open Source Database Hardware Strategy 94

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 125

Database Servers Testing Programming 125

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. I am happy to announce that with PBM 2.2.0,

Availability 77

Availability Open Source Strategy Storage 77

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 87

Scalability Database Open Source Traffic 87

Adrian Cockcroft

NOVEMBER 26, 2023

In their annual sustainability report in July 2023 AWS did update their list of sustainable regions to highlight 19 regions that are 100% sustainable — using an annual local market methodology for scope 1 and 2. Google Cloud and Microsoft Azure released Scope 3 data in 2021. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Percona

OCTOBER 11, 2023

Once you have installed MongoShake, you need to configure it for the migration process. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/ cd MongoShake. In the config file, you can edit the URI for both RS or sharded clusters.

Database 89

Database Open Source Testing Servers 89

Dynatrace

JULY 11, 2023

The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database.

Database 156

Database Government Games Servers 156

Percona

NOVEMBER 30, 2023

Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). HINT: has a stanza-create been performed?

Open Source 81

Open Source Database Processing Performance 81

Dynatrace

DECEMBER 21, 2023

And while these examples were resolved by just asking a few questions, in many cases, the answers are more elusive, requiring real-time and historical drill-downs into the processes and dependencies specific to each host. Reduce the volume of data volumes requested from databases (for example, request all, filter in memory).

Cloud 205

Cloud Energy Best Practices Cache 205

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. That’s very welcome after upgrade/downgrade processes when metadata is touched after FCV change.

Metrics 104

Metrics C++ Storage Database 104

Dynatrace

JANUARY 31, 2024

With PowerConnect, collecting data from SAP systems and fueling the Dynatrace platform, Dynatrace automatically uncovers the topology model of the SAP landscape, providing a clear and comprehensive view of the relationships and dependencies among different systems, servers, databases, applications, and interfaces. Architectural overview.

Java 185

Java Analytics Best Practices Monitoring 185

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. These attacks can rapidly consume available connections, leaving legitimate users unable to connect and disrupting system functionality. These leaks can quickly deplete the available connection pool, hindering system performance and potentially leading to crashes.

Servers 82

Servers Database C++ Airlines 82

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. Processing triggers for man-db (2.9.4-2) Check the available Percona Server for MySQL 8.0

Servers 85

Servers C++ Database Systems 85

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. This leads us to the process page of our specific Apache instance. And that’s where Dynatrace OneAgent comes in. What is OneAgent?

Metrics 168

Metrics Monitoring Database Network 168

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 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. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. But when and how does DevOps monitoring fit into the process? The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases.

DevOps 216

DevOps Efficiency Monitoring Infrastructure 216

Percona

DECEMBER 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. This is available only for the log_error_verbosity=3. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool.

Monitoring 90

Monitoring Code Open Source Cache 90

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. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 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.

Tuning 52

Tuning Database Performance Hardware 52

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. You might wonder why this error will come during PITR as the operations in the Oplog are idempotent, meaning they always result in the same change to the database no matter how many times they’re performed.

Games 96

Games Database Open Source C++ 96

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. exceptions`, CONSTRAINT `FK_Exceptions_Orders_OrderId` FOREIGN KEY (`OrderId`) REFERENCES `orders` (`OrderId`)) The procedure Backup: the most crucial step in this process. Check the size of the table.

Database 102

Database Testing Servers Open Source 102

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs).

Cloud 82

Cloud Open Source Strategy Best Practices 82

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 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 ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

MARCH 28, 2023

To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. This attribute helps take the redundant copies of the databases at multiple locations remotely on different servers or locally on the same server.

Servers 84

Servers Azure AWS Cloud 84

Official Blog - World Web Technology

APRIL 12, 2023

Of all websites available across the globe, WordPress powers more than 65.1%. There are more than 59,208 WordPress plugins available as of now. The number of free themes available with WordPress is 8,874+ as of now. The main benefit of using WordPress for your website development project is the availability of themes.

Development 52

Development Website Ecommerce Programming 52

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. ClickHouse is a columnar database that handles analytical workloads quickly. By default, it will create a database on ClickHouse with all the tables and their data. (We No manual work!

Engineering 90

Engineering Database Servers Analytics 90

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. Journal It’s a process where every write operation gets written (appended) from Memory to a Journal file, AKA transaction log that exists on disk at a specific interval configured using “ journalCommitIntervalMs.” Let’s understand both of them.

Hardware 90

Hardware C++ Storage Cache 90

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

JUNE 23, 2023

In Percona Managed Services , one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. In order to speed up the backup process along with the compression and encryption, we can use multiple threads.

Servers 82

Servers Processing Speed Open Source 82

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. How-to documentation is readily available.

Open Source 80

Open Source Healthcare Social Media Database 80