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 83

Availability Open Source Architecture Database 83

Official Blog - World Web Technology

OCTOBER 12, 2023

There is a huge plugin repository available for mortgage and loan calculators. FC’s Loan Calculator This is another fantastic WordPress loan calculator plugin developed by www.accuratecalculators.com This open-source loan calculator plugin can help users see a loan amortization schedule with date-based payments.

Website 59

Website Open Source Mobile Ecommerce 59

Dynatrace

NOVEMBER 9, 2023

Kubernetes is a widely used open source system for container orchestration. By continuously evaluating CPU, memory usage, and capacity, and comparing these available resources to the requested and utilized memory by Kubernetes workloads, potential waste of resources becomes visible, revealing opportunities for countermeasures.

Efficiency 267

Efficiency Monitoring Best Practices Open Source 267

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. pt - galera - log - explainer takes raw log files, usually very verbose as the one available in the regression test suite , and makes short summary out of them: $./bin/pt-galera-log-explainer 2023-12-21T15:29:22 Creating triggers.

Operating System 96

Operating System Programming Open Source Testing 96

Percona

JULY 17, 2023

In this blog, we’ll examine the reasons why people would seek an alternative to MongoDB Enterprise, and we’ll identify some of the most popular NoSQL alternatives. First, some stage-setting for this blog article. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). It ranks No.

Open Source 75

Open Source Database Scalability Software 75

Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. 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/

Database 86

Database Open Source Testing Servers 86

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 87

Monitoring Code Open Source Cache 87

Tech News Gather

APRIL 18, 2023

In this type of mobile application, the web code is integrated with the native language to create exclusive features and access native APIs that are not available in JavaScript yet. Choose open-source frameworks: Creating an app from the beginning is extremely expensive and time-consuming.

Mobile 52

Mobile Small Business Open Source Entertainment 52

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. Earlier, it was used to simply create online blogs, but WordPress has evolved since then.

Development 52

Development Website Ecommerce Programming 52

Percona

JUNE 26, 2023

So we need to check whether this base / 16384 / 16391 file is available in / base location. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together.

Hardware 75

Hardware C++ Database Open Source 75

Percona

JANUARY 2, 2024

The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. Installing the plugin is a straightforward operation that is explained in the blog post mentioned above. It has many additional features that we will review in future blogs.

Servers 83

Servers Database Open Source Scalability 83

Percona

NOVEMBER 30, 2023

This blog describes how to encrypt the pgBackRest repository. HINT: backup.info cannot be opened and is required to perform a backup. Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. HINT: has a stanza-create been performed?

Open Source 78

Open Source Database Processing Performance 78

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 120

AWS Storage Database Open Source 120

Dynatrace

OCTOBER 25, 2022

To ensure continuous availability, it‘s essential to proactively analyze potential problems and optimize the environment in advance to minimize the negative impact on users and improve user experience. The proper focus and best optimization level must be chosen wisely to get the most out of the available time.

Efficiency 228

Efficiency Best Practices DevOps Open Source 228

Percona

DECEMBER 12, 2023

This blog gives you some ideas on using pt-table-sync for replica tables with triggers. sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 The print result is good.

Servers 90

Servers Database Testing Open Source 90

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Let’s discuss a few scenarios one by one.

Servers 82

Servers Azure AWS Cloud 82

Percona

MARCH 27, 2023

In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). ‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. One of the common issues that can be encountered in PostgreSQL is replication lag.

Latency 81

Latency Tuning Open Source Network 81

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Database 95

Database Performance C++ Engineering 95

Percona

APRIL 17, 2023

reaches end of life in October 2023. Reserved keyword – Groups Most notably, and the issue my customers are facing (and the primary reason for this blog post), is the addition of GROUPS as a reserved keyword. You can read more about reserved keywords in a previous blog, MySQL 5.7 Upgrading to MySQL 8 from 5.7

Open Source 73

Open Source Servers Scalability Database 73

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. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. The blog post contains the following topics.

Engineering 87

Engineering Database Servers Analytics 87

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place? wt list -c WiredTigerCheckpoint.33:

Hardware 87

Hardware C++ Storage Cache 87

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

Open Source 66

Open Source Database Storage Engineering 66

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Now let’s stretch our imagination and consider a second method of high availability, ala Citus. Much of what I will show you makes heavy use of them.

C++ 79

C++ Database Storage Testing 79

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. Fix for PT-2168 adds checks for these situations and, depending on the option -- fail - on - stopped - replication , either dies or continues waiting when the replica is available again. Percona Toolkit 3.5.5

Open Source 99

Open Source Code Testing Systems 99

Percona

MARCH 3, 2023

And this is how this blog originates so that if you find yourself in the same situation, proceed similarly or at least consider some of the practices used to meet the objective. “Don’t worry, we’ll take a look at the issue, and accordingly, we’ll proceed to suggest an execution plan,” we replied.

Database 99

Database Testing Servers Open Source 99

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. I will provide a more detailed usage of pg_partman in upcoming blog posts.

Storage 100

Storage Open Source Database Efficiency 100

Percona

JUNE 29, 2023

There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). Below is the command used to create an index using commitQuorum as the majority : db.getSiblingDB("acme").products.createIndex({

Servers 80

Servers C++ Storage Best Practices 80

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Mar 15 19:02:59 ps promtail[2318]: level=info ts=2023-03-15T19:02:59.437567482Z caller=filetargetmanager.go:352

Monitoring 86

Monitoring Servers Metrics Database 86

Percona

JUNE 23, 2023

Then, we can ignore the lines of “log scanned” to remove “clutter” from the log: grep -v "log scanned" /var/log/xtrabackup.log|less We can see something like this: 2023-04-21T00:27:14.857218-00:00 03 [Note] [MY-011825] [Xtrabackup] Compressing and encrypting./dbxxxx/tb1.ibd dbxxxx/tb1.ibd dbxxxx/tb1.ibd dbxxxx/tb2.ibd

Servers 80

Servers Processing Speed Open Source 80

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. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 For example, the high availability solution Patroni passes some of the most critical parameters as a command line argument.

Database 102

Database Servers Open Source Tuning 102

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. To make it real, we also discuss a concrete use case with Kepler on Kubernetes. What is Prometheus? Please stay tuned!

Metrics 171

Metrics Engineering Energy Tuning 171

Percona

JUNE 28, 2023

This blog post is a warning tale, an invitation to try yourself and break stuff (not in production, right?). First error to notice: 2023-06-22T08:00:48.322148Z 0 [ERROR] [MY-000000] [Galera] It may not be safe to bootstrap the cluster from this node. TLDR: Do you know right away what happened when seeing this log? Why did it fail?

C++ 77

C++ Open Source Servers Monitoring 77

Percona

APRIL 17, 2023

In this blog post, I’ll show you a simple example of collecting all rich data about databases using PMM and a way to send some of it to Datadog for general dashboards with main metrics to monitor. Preparing Datadog side: You can find a complete list of Available Datadog agents for different OS inside the user account.

Monitoring 70

Monitoring Metrics Database Open Source 70

Percona

NOVEMBER 2, 2023

This blog was originally published in Sept 2021 and was updated in November 2023. Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.

Database 70

Database Open Source Scalability Virtualization 70

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Here are some potential drawbacks of using it: Compared to MySQL, MariaDB has a smaller open source user and developer community.

Open Source 52

Open Source Servers Storage Scalability 52

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). Developers and business owners trust variant platforms globally available in the market; however, JavaScript is an exception. is an open-source, cross-platform with runtime environment of JavaScript. What is ReactJS?

Development 52

Development Virtualization Open Source Architecture 52