by Ege Gunes | Jan 27, 2022 | Cloud, MongoDB, Percona Software, Security
Managing database users and their passwords can be a hassle. Sometimes, they could even wait in various configuration files, hardcoded. Using certificates can help you avoid the toil of managing, rotating, and securing user passwords, so let’s see how to have...
by Dmitriy Kostiuk | Dec 21, 2021 | Cloud, MongoDB, Percona Software
If you have ever used backups with Percona Distribution for MongoDB Operator, you should already know that backed-up data is stored outside the Kubernetes cluster – on Amazon S3 or any S3-compatible storage. Storage types not compatible with the S3 protocol were...
by Tomislav Plavcic | Dec 21, 2021 | Cloud, MongoDB, Percona Software
As we all know, security is very important these days and we read about many data leaks. Security has many aspects, but one of the most important is securing data since it is a vital asset to companies. When we speak about data, it can be encrypted at rest...
by Peter Boros | Dec 9, 2021 | Cloud, MySQL, Percona Software
We have a quickstart guide for how to install Percona Distribution for MySQL Operator on minikube. Installing the minimal version works well as it is described in the guide. After that, we will have one HAproxy and one Percona XtraDB Cluster (PXC) node to work with....
by Ivan Groenewold | Nov 24, 2021 | Cloud, Insight for DBAs, MySQL
A recommendation we often give to our customers is along the lines of “archive old data” to reduce your database size. There is a tradeoff between keeping all our data online and archiving part of it to cold storage. There could also be legal requirements...
by Nik Krichko | Oct 25, 2021 | Benchmarks, Insight for DBAs, MySQL
Recently we published the first part of research comparing Graviton (ARM) with AMD and Intel CPU on AWS. In the first part, we selected general-purpose EC2 instances with the same configurations (amount of vCPU). The main goal was to see the trend and make a general...
by Sergey Pronin | Oct 18, 2021 | Cloud, Database Trends, Insight for DBAs, Percona Software
The cloud-native landscape matures every day, and new great tools and products continue to appear. We are starting a series of blog posts that are going to focus on new tools in the container and cloud-native world, and provide a holistic view through the prism of...
by Nik Krichko | Oct 15, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Recently, AWS presented its own CPU on ARM architecture for server solutions. It was Graviton. As a result, they update some lines of their EC2 instances with new postfix “g” (e.g. m6g.small, r5g.nano, etc.). In their review and presentation, AWS showed impressive...
by Sergey Pronin | Oct 13, 2021 | Cloud, Insight for DBAs, MongoDB, Percona Software
This blog post is the last in the series of articles on migrating databases to Kubernetes with Percona Operators. Two previous posts can be found here: Migrating PostgreSQL to Kubernetes Migration of a MySQL Database to a Kubernetes Cluster Using Asynchronous...
by Sergey Pronin | Oct 8, 2021 | Cloud, MongoDB, Percona Software
As per the glossary, Disaster Recovery (DR) protocols are an organization’s method of regaining access and functionality to its IT infrastructure in events like a natural disaster, cyber attack, or even business disruptions related to the COVID-19 pandemic. When we...
by Slava Sarzhan | Sep 17, 2021 | Cloud, MySQL, Percona Software
Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day...
by Yves Trudeau | Sep 13, 2021 | Cloud, Insight for DBAs, MySQL
Here’s a second post focusing on the performance of MySQL on ZFS in cloud environments. In the first post, MySQL/ZFS Performance Update, we compared the performances of ZFS and ext4. This time we’ll look at the benefits of using ephemeral storage devices. These...
by Marcelo Altmann | Sep 2, 2021 | Cloud, Insight for DBAs, MySQL, Percona Software
Storing your data locally can impose security and availability risks. Major cloud providers have object storage services available to allow you to upload and distribute data across different regions using various retention and restore policies. Percona XtraBackup...
by Peter Boros | Aug 20, 2021 | Cloud, Hardware and Storage, Insight for DBAs
EBS storage type choices in AWS can be impacted by a lot of factors. As a consultant, I get a lot of questions about choosing the best storage type for a workload. Let me share a few examples. Is io2 better than gp2/3 if the configured iops are the same? What can I...
by Sergey Pronin | Aug 19, 2021 | Cloud, MySQL, Percona Software
You may have already seen this document which describes the integration between HashiCorp Vault and Percona Distribution for MySQL Operator to enable data-at-rest encryption for self-managed Vault deployments. In April 2021, HashiCorp announced a fully managed...
by Sergey Pronin | Jul 28, 2021 | Cloud, MongoDB, Open Source, Percona Software
Recently I wanted to play with the latest and greatest Percona Distribution for MongoDB Operator which had a bug fix I was interested in. The bug fix was merged in the main branch of the git repository, but no version of the Operator that includes this fix was...
by David Gonzalez | Jul 26, 2021 | Cloud, Insight for DBAs, PostgreSQL
We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific...
by Ege Gunes | Jul 13, 2021 | Cloud, MongoDB, MySQL, Percona Software
by Peter Boros | Jul 9, 2021 | Cloud, Insight for DBAs, MySQL
Problem Statement Having backups of binary logs is fairly normal these days. The more recent binary logs are copied offsite, the better RPO (Recovery Point Objective) can be achieved. I was asked multiple times recently if something could be done to “stream” the...
by Oleksandr Miroshnychenko | Jun 24, 2021 | Cloud, MySQL, Percona Software
This quickstart shows you how to use the Azure portal to deploy a dedicated Percona Server for MySQL 8.0 drop-in replacement for MySQL that provides superior performance, scalability, and instrumentation. It also shows you how to connect to the server. Prerequisites...
