Percona

SEPTEMBER 19, 2023

PostgreSQL Community released PostgreSQL 16 on September 14, 2023. It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available!

Availability 104

Availability Open Source Database Servers 104

Percona

JULY 10, 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. PMM is publicly available on Oracle Linux 9. was released on June 28, 2023.

Monitoring 75

Monitoring Open Source Scalability Database 75

Percona

JUNE 26, 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. On June 15, 2023, Percona Distribution for MySQL (PS-based variation) 8.0.33

Servers 69

Servers Open Source Scalability Database 69

Percona

MARCH 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since February 27, 2023. Take a look!

Servers 77

Servers Open Source Database Software 77

Percona

APRIL 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. 24 was released on April 18, 2023. 24 (2023-03-20) release notes.

Open Source 76

Open Source Storage Servers Database 76

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. PMM) was released on July 13, 2023. was released on July 19, 2023.

Open Source 71

Open Source Scalability Database Monitoring 71

Percona

JANUARY 9, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. was released on January 6, 2023. Database page content is not written to the buffer. Take a look!

Open Source 83

Open Source Database Servers Software 83

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. The expo hall is open Friday – Sunday.

Open Source 106

Open Source Programming Software Software 106

Percona

OCTOBER 10, 2023

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. 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 Type 'help;' or 'h' for help.

Database 91

Database Performance C++ Engineering 91

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 74

Availability Open Source Strategy Storage 74

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 76

Cloud Open Source Strategy Best Practices 76

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. bin source=vm.

Monitoring 92

Monitoring Metrics Analytics Open Source 92

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. Programs like Open Data on AWS provide free, publicly available datasets, accelerating sustainability innovation.

AWS 52

AWS Energy IoT Best Practices 52

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 76

Open Source Healthcare Social Media Database 76

Dynatrace

JUNE 7, 2023

Kubernetes is an open source container orchestration platform that enables organizations to automatically scale, manage, and deploy containerized applications in distributed environments. According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.” Ease of use.

Open Source 199

Open Source Social Media Infrastructure Operating System 199

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. In this blog post, we dig into the steps to track down the DROP statements in our database server. sec) We will narrow down the events to log only the drop events for the database-related objects. How does it work?

Servers 80

Servers Database Open Source Scalability 80

Percona

DECEMBER 20, 2023

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. new size: 1073741824 bytes) 2023-12-05T16:51:29.610907Z 0 [Note] [MY-013954] [InnoDB] Status code 1: Resizing buffer pool from 134217728 to 1073741824 (unit=134217728).

Monitoring 83

Monitoring Code Open Source Cache 83

Percona

DECEMBER 12, 2023

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 sec) + -+ --+ -+ + | id | test_data | op_user | op_time | + -+ --+ -+ + | 1 | lt1 | root@localhost | 2023-11-26 09:59:19 | + -+ --+ -+ + 1 row in set (0.00

Servers 87

Servers Database Testing Open Source 87

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 88

Open Source Database Hardware Strategy 88

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

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Metadata regarding invisibility is available on the information_schema, and the INVISIBLE/VISIBLE keyword is preserved in the binlog, so all changes are correctly replicated.

Best Practices 75

Best Practices Open Source Code Engineering 75

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. Check the available Percona Server for MySQL 8.0 bullseye amd64 1.7 Version: '8.0.28-20'

Servers 81

Servers C++ Database Systems 81

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Testing 94

Testing Database Servers Open Source 94

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

Percona

AUGUST 18, 2023

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. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 64

Open Source Database Storage Engineering 64

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 78

Servers C++ Storage Best Practices 78

Percona

JULY 27, 2023

on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. is in October of 2023. releases will become available, please have a little patience. This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 Tempus Fugit! release notes.

Servers 80

Servers Open Source Tuning Cache 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 84

Monitoring Servers Metrics Database 84

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. openmetrics.d/conf.yaml

Monitoring 69

Monitoring Metrics Database Open Source 69

Percona

MARCH 13, 2023

Linux (x86_64) (revision id: 14f007fb) 2023-02-28T23:05:23.994404-05:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql/ 2023-02-28T23:05:24.001029-05:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet. for this database. Prepare the backup on MySQL 8 with Percona XtraBackup 8.0,

Servers 99

Servers C++ Storage Systems 99

O'Reilly

JUNE 11, 2024

It’s in every book, on-demand course, and video, and will eventually be available across our entire learning platform. Another AI model that has access to a database of our platform’s content to generate “candidate” documents. Most of the models we use are small, open source models.

Design 58

Design Open Source Database Programming 58

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 set the stage, let’s have a quick recap of what Prometheus is and what it does. What is Prometheus?

Metrics 172

Metrics Engineering Energy Tuning 172

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

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 72

Open Source Database Storage Scalability 72

Percona

DECEMBER 19, 2022

Easily restore your MongoDB databases to a previous state. One of the core principles of our open-source philosophy is transparency, and we are committed to sharing our roadmap openly and transparently with our users. This feature is now available in the latest release of PMM. Stage two (will be rolled out in 2023).

Metrics 52

Metrics Monitoring Servers Open Source 52

Percona

APRIL 28, 2023

We are a company of open source proponents. We’re also dedicated and active participants in the global open source community. Both open source and proprietary options have advantages. With open source database software , anyone in the general public can access the source code, read it, and modify it.

Open Source 108

Open Source Database Software Software 108

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to help software developers and operations teams understand what their software is doing and where it’s running into snags. We also defined the metrics and traces for our demo application using OpenTelemetry.

Transportation 180

Transportation Metrics Best Practices Code 180