by Yves Trudeau | Oct 27, 2020 | Cloud, Insight for DBAs, MySQL
If you often deploy services in the cloud, you certainly, at least once, forgot to stop a test instance. I am like you and I forgot my share of these. Another mistake I do once in a while is to provision a bigger instance than needed, just in case, and forget to...
by Vadim Tkachenko | Oct 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This...
by David Quilty | Oct 22, 2020 | Cloud, MySQL, Percona Services, Webinars
Google Cloud Platform (GCP), with its CloudSQL offering, has become a leading platform for database-as-a-service workload deployments for many organizations. Scale and High Availability have surfaced as primary goals for many of these deployments. Unfortunately, the...
by Marco Tusa | Oct 9, 2020 | Benchmarks, Cloud, MySQL, ProxySQL
For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking...
by Stephen Thorn | Oct 8, 2020 | Cloud, MongoDB, MySQL, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes...
by David Quilty | Sep 24, 2020 | Cloud, Insight for DBAs, Open Source, Webinars
Database-as-a-service (DBaaS) can be thought of as a platform that can be used to manage an organization’s database environment(s). One of the most well known DBaaS platforms is Aurora powered by AWS. In this webinar, Ananias Tsalouchidis, Senior MySQL DBA at...
by Daniel Guzmán Burgos | Sep 11, 2020 | Cloud, Insight for DBAs, MySQL
In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.1,...
by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of...
by Tomislav Plavcic | Aug 11, 2020 | Cloud, MySQL, Percona Software
In Percona Operator for MySQL based on Percona XtraDB Cluster versions prior to 1.5.0, there were two methods for upgrading PXC clusters, and both of these use built-in StatefulSet update strategies. The first one is manual (OnDelete update strategy) and the second...
by Agustín | Aug 4, 2020 | Cloud, Insight for DBAs, Monitoring, Percona Software
In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2. Installing Dependencies First, let’s get some basic packages out of the way,...
by Dmitriy Kostiuk | Jul 23, 2020 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
The content of this article is outdated. See the official Percona Operator for MongoDB and Percona XtraDB Cluster Operator documentation for more up to date information. Percona Monitoring and Management (PMM) provides an excellent solution to monitor both Percona...
by Sami Ahlroos | Jul 20, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
The Percona Kubernetes Operator for Percona XtraDB Cluster can send backups to Amazon S3 or S3-compatible storage. And every now and then at Support, we are asked how to send backups to Google Cloud Storage. Google Cloud Storage offers an “interoperability mode” which...
by Vadim Tkachenko | Jun 8, 2020 | Cloud, MongoDB, Percona Software
Unless you are using Amazon Aurora or RDS, setting up clustering software still can be complicated and that’s why we want to offer options to simplify database cluster management in Amazon AWS. This time I will be looking at Percona Kubernetes Operators, for both...
by Ivan Groenewold | May 27, 2020 | Cloud, Insight for DBAs, MongoDB
Say you need to move from DynamoDB to MongoDB; what options do you have? Unfortunately, at the time of this writing, there are no available tools to do this easily. In this post, we will explore the available options and discuss some of the potential issues and...
by Corrado Pandiani | May 20, 2020 | Cloud, Insight for DBAs, MongoDB
Recently I’ve been faced with an interesting challenge. How can I replicate data, in real-time, from DynamoDB to MongoDB? Why would I need real-time replication like that? For example: Running on MongoDB different queries relying on different indexes Having on...
by Mike Benshoof | Apr 15, 2020 | Cloud, MySQL, Percona Services, Security
The other day on a call, a client asked me an interesting question. We were discussing some testing they were doing in Amazon Relational Database Service (RDS). The question came up “since RDS is managed, how can I prove to my security team that the data is actually...
by Michael Patrick | Apr 2, 2020 | Cloud, Database Trends, Percona Services
As a Technical Account Manager, or TAM for short, I am fortunate to work with some large clients. Most all of them are in some state of increasing their usage of containerization. There are a number of reasons for this, but let’s explore a few of the biggest...
by Mike Benshoof | Apr 2, 2020 | Cloud, Database Trends, Percona Services
As discussed in part one, this series is meant to go over some of the biggest differences you will likely encounter when moving from on-premise to the cloud. In this portion, I’ll look at the architectural and operational differences that are commonly seen....
by Mike Benshoof | Mar 31, 2020 | Cloud, Database Trends, Percona Services
One of the most common questions I get as a Technical Account Manager (TAM) from clients considering a migration from their current on-premise data center to AWS is “what are the biggest differences I will need to address?” In an earlier post MySQL to the Cloud!...
by Ananias Tsalouchidis | Mar 30, 2020 | Benchmarks, Cloud, Insight for DBAs, MySQL, Percona Software
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my MySQL workload?” is really common but cannot always be easily answered. However, there are ways to come up with an answer. This question also...
