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. Percona Monitoring and Management 2.40.0 Take a look. was released.

Servers 77

Servers Monitoring Open Source Scalability 77

Percona

FEBRUARY 15, 2023

Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL ( Percona Server for MySQL: Automatic Cloud Deployment With Terraform ) and Percona Monitoring and Management ( Deploying Percona Monitoring and Management (PMM) With Terraform ).

Open Source 124

Open Source AWS Scalability Servers 124

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. Updates to the releases of Percona Distribution for PostgreSQL 15.2, Take a look!

Open Source 78

Open Source Servers Scalability Database 78

Percona

OCTOBER 2, 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. Percona Distribution for MySQL (PS-based variation) 8.0.34 Take a look.

Open Source 82

Open Source Scalability Database Servers 82

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. Percona XtraDB Cluster 8.0.32-24 24 Percona XtraDB Cluster 8.0.32-24

Open Source 79

Open Source Storage Servers Database 79

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. Continuing this trajectory into the future improvements in the development of our software products will require many decisions. We are proud of how far we have come over the last 16+ years.

Open Source 91

Open Source Database Operating System Programming 91

Percona

MARCH 27, 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. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 79

Open Source Servers Scalability Cache 79

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. You can just connect to the MySQL service POD and perform the ALTER. Your MySQL connection id is 256 Server version: 8.0.32-24.2

Database 97

Database Performance C++ Engineering 97

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. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 85

Open Source Database Servers Scalability 85

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. Percona Monitoring and Management 2.38 Percona Monitoring and Management 2.38

Monitoring 78

Monitoring Open Source Scalability Database 78

Percona

FEBRUARY 14, 2023

Recently, we released Percona Monitoring and Management 2.34 (PMM) which includes upgrades for backup and Database as a Service (DBaaS) features, and we are seeking ways to simplify PMM deployment. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 122

Monitoring Infrastructure Open Source AWS 122

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. They’re proven and ready-to-go.

Architecture 98

Architecture Availability Open Source Healthcare 98

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. Percona Distribution for MySQL (PS-based variation) 8.0.33 Take a look!

Servers 72

Servers Open Source Scalability Database 72

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. 3) Simulate a running write application.

Servers 89

Servers Virtualization Open Source Scalability 89

Percona

JANUARY 30, 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. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 86

Open Source Storage AWS Cloud 86

Percona

MARCH 22, 2023

One of the installation methods we support for our database software is through Helm. PV (Persistent Volume) provisioner support in the underlying infrastructure If you want to install PMM in a Kubernetes cluster on Amazon EKS, you can use eksctl to create the required cluster. MyDBaaS will help you with cluster creation.

Monitoring 102

Monitoring AWS Database Infrastructure 102

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. This blog post discusses the cause and possible solution for queries with ​ Waiting for table flush state in processlist when taking backups using Percona XtraBackup. Only MySQL 5.7 This feature is available in Percona Server for MySQL 5.6+.

Storage 103

Storage Engineering Open Source Servers 103

Percona

MARCH 1, 2023

In this blog post, we will see how running databases on Kubernetes with Percona Operators can reduce your cloud bill when compared to using AWS RDS. hour per cluster or $876 per year. Managed Database Services like RDS remove a lot of toil from operation teams and provide self-service for developers.

Cloud 132

Cloud Storage AWS Database 132

Percona

MAY 15, 2023

Historically MySQL is great in horizontal READ scale. The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. However, those solutions do not offer the same level of scaling for writes operation.

Traffic 125

Traffic Scalability Database Servers 125

Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 This improvement in Percona XtraBackup significantly reduces the time required for a new node to join the Percona XtraDB Cluster (PXC). Percona XtraBackup copies the InnoDB data files.

Cache 87

Cache Benchmarking Servers Design 87

Percona

DECEMBER 12, 2022

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. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 63

Open Source Azure Database Servers 63

Percona

MARCH 16, 2023

Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS). Now, if you like it and wanna give it a try!

Infrastructure 94

Infrastructure Database AWS Monitoring 94

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

NOVEMBER 6, 2023

Percona Operators allow users to easily manage complex database systems in a Kubernetes environment. With Percona Operators , users can easily deploy, monitor, and manage databases orchestrated by Kubernetes, making it easier and more efficient to run databases at scale. kubectl get pxc pxc-1 -oyaml | yq 'del(.status.conditions)

Metrics 71

Metrics Monitoring Database Cache 71

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And you can get it from us at Percona.

Cache 101

Cache Database Virtualization Servers 101

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster.

Availability 109

Availability Database Open Source Hardware 109

Percona

DECEMBER 15, 2022

In this blog post, we will explain how to limit access scope for the user to avoid manual changes for database clusters deployed with Percona Operators. Developers will be able to: Create, modify, and delete Custom Resources that Percona Operators use. I can create Percona XtraDB Clusters, but I can’t delete Services.

Database 72

Database Servers Development Availability 72

Percona

JANUARY 20, 2023

How can we fix a nasty out-of-space issue leveraging the flexibility of Percona Operator for MySQL? When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk. Well, it depends on where you run it. The story The case was on AWS using EKS.

AWS 94

AWS Storage Monitoring Cloud 94

Percona

MARCH 3, 2023

Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer. One replica with the same software version (in Read-Only and Super-Read-Only mode). mysqlserver01=127.0.0.2 [RW]

Database 101

Database Testing Servers Open Source 101

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 90

Database Hardware Open Source Strategy 90

Percona

DECEMBER 6, 2022

MySQL Replication is useful, easy to set up, and used for very different purposes. To learn more, check out How Does MySQL Replication Work? A mistake on the source, for example, a DROP DATABASE or an UPDATE without a WHERE clause will be replicated nearly instantly to all replica servers. For example: split reads and writes.

Servers 63

Servers Database Architecture Infrastructure 63

Percona

DECEMBER 2, 2022

Many community members joined Hacktoberfest this year and contributed to various open source projects, and we would like to highlight the most active contributors to Percona software during this fantastic event. daniel-shuy fixed the database migration test. fmbiete fixed the broken link in the Percona XtraBackup documentation.

Open Source 56

Open Source Azure Database Speed 56

Percona

DECEMBER 12, 2022

Table modifications are a common task for database administrators. One of the tools in Percona Toolkit is pt-online-schema-change , a utility that alters the structure of a table without interfering with the reads or writes. pt_osc_mytestdb_authors2_ins`; DROP TABLE IF EXISTS mytestdb._authors2_old; _authors2_old; Wrap up.

Database 60

Database Engineering Testing Processing 60

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40