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. 24 was released on March 9, 2023.

Servers 78

Servers Open Source Database Software 78

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 72

Open Source Scalability Database Monitoring 72

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 92

Database Performance C++ Engineering 92

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 81

Servers Database Open Source Scalability 81

Dynatrace

DECEMBER 21, 2023

Reduce the volume of data volumes requested from databases (for example, request all, filter in memory). For a deeper look into these and many other recommendations, my colleagues and I wrote an eBook about performance and scalability on the topic. Many of the same principles can be applied to green coding. Want to learn more?

Cloud 202

Cloud Energy Best Practices Cache 202

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

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 84

Monitoring Code Open Source Cache 84

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 88

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

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

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 77

Cloud Open Source Strategy Best Practices 77

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 82

Servers C++ Database Systems 82

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.

Database 95

Database Testing Servers Open Source 95

Official Blog - World Web Technology

JUNE 13, 2023

It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. Mostly, clients choose themes and plugins from available resources. In that case, the developer should be able to build scalable WordPress themes and plugins. It will help you become a master of WordPress.

Development 52

Development Website Ecommerce Code 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 77

Open Source Healthcare Social Media Database 77

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 65

Open Source Database Storage Engineering 65

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 76

Best Practices Open Source Code Engineering 76

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 81

Servers Open Source Tuning Cache 81

Percona

JUNE 2, 2023

WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source. MySQL was the database for phpWebLog, for example, way back in 2000. MySQL was founded in 1995 and went open source in 2000.

Open Source 92

Open Source Traffic Tuning Database 92

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 58

Scalability Best Practices Servers Database 58

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 80

Open Source Programming Database Servers 80

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

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. What is Prometheus?

Metrics 172

Metrics Engineering Energy Tuning 172

Percona

DECEMBER 18, 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 December 4, 2023.

Monitoring 84

Monitoring Open Source Servers Scalability 84

Percona

OCTOBER 19, 2023

Welcome to the first installment of our series: Scalable Solutions with Percona Distribution for PostgreSQL. In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. Ensure that these values align with your desired database configuration.

Scalability 82

Scalability Database Open Source Traffic 82

Percona

NOVEMBER 13, 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 October 31, 2023.

Innovation 83

Innovation Open Source Scalability Database 83

Percona

OCTOBER 31, 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 October 16, 2023.

Monitoring 76

Monitoring Open Source Scalability Database 76

Percona

AUGUST 21, 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 August 7, 2023.

Open Source 81

Open Source AWS Servers Database 81

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 89

Open Source Database Hardware Strategy 89

Percona

JUNE 12, 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 29, 2023.

Open Source 82

Open Source Servers Database Scalability 82

Percona

SEPTEMBER 18, 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 September 4, 2023.

Open Source 77

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

Open Source Servers Scalability Database 76

Percona

FEBRUARY 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 January 30, 2023. was released on February 9, 2023.

Open Source 82

Open Source Database Servers Scalability 82

Percona

OCTOBER 16, 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 October 2, 2023.

Servers 73

Servers Monitoring Open Source Scalability 73

Percona

MAY 8, 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 April 24, 2023.

Monitoring 75

Monitoring Open Source Database Servers 75

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 73

Open Source Database Storage Scalability 73

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. The goal of WebAssembly is to execute at native speeds by taking advantage of common hardware features available on a variety of platforms. The main benefits of serverless architecture are cost savings and scalability.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111