Featured
Percona Products
Percona Services
Use Cases
Vadim TkachenkoThis blog was originally published in March of 2023 and updated in November of 2023. Recently, “serverless” has become a buzzword, and for good reason. The goal is to simplify the provisioning and management of database capacity. One approach is to separate compute and storage to allow for independent scaling. We are thrilled to announce […]
This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of […]
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested! Introduction Recently, Percona introduced Percona Builds for Neon (Introducing Percona Builds for Serverless PostgreSQL), which makes it easy to install and experiment with serverless PostgreSQL. And I followed it with how you can run […]
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested! Introduction Recently, Percona introduced Percona Builds for Neon (Introducing Percona Builds for Serverless PostgreSQL), which makes it easy to install and experiment with serverless PostgreSQL. But now, there’s an even more convenient way to […]
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). Now we also added the capability to deploy Group Replication configuration with Percona Server for MySQL, and assuming we have […]
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. Previously I wrote about our Terraform provider to deploy Percona Server for MySQL — Percona Server for MySQL: Automatic Cloud Deployment with Terraform — and now […]
To follow up on my previous Kubernetes articles: Installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and Have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator) Monitoring with Percona Monitoring and Management (PMM): Using Percona Kubernetes Operators With K3s […]
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator) lets review how we can install monitoring and monitor our running instance. Percona Monitoring and Management installation […]
MySQL is an outstanding database for online transaction processing. With suitable hardware, it is easy to execute more than 1M queries per second and handle tens of thousands of simultaneous connections. Many of the most demanding web applications on the planet are built on MySQL. With capabilities like that, why would MySQL users need anything […]
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation), now we will install Percona Server for MySQL Operator into the running cluster. I will copy some ideas from Peter’s Minukube tutorial (see Exploring MySQL on Kubernetes with Minkube). In this case, I will use not Percona […]
Recently Peter provided an extensive tutorial on how to use Percona Kubernetes Operators on minikube: Exploring MySQL on Kubernetes with Minikube. Minikube is a great option for local deployment and to get familiar with Kubernetes on a single developer’s box. But what if we want to get experience with setups that are closer to production […]
When you develop an application you expect success, and often success comes with growth problems. These problems especially show themselves in the area of data storage, where being stateful is not as easy to scale as the stateless parts of the application. There are several stages of approaching database scalability: Configuration and query optimization. This […]
We are looking to provide simplified ways to deploy Percona software in cloud environments, especially for more advanced scenarios like replication and multi-node cluster (in the case of Percona XtraDB Cluster). For this I propose trying out our new Terraform provider, with the capabilities: Deploy in AWS or GCP Cloud. The provider will automatically create […]
We currently provide multiple ways to install Percona Monitoring and Management (PMM) Server, with the primary way to use a docker: Install Percona Monitoring and Management or Podman: Podman – Percona Monitoring and Management We implemented it this way to simplify deployments, as the PMM server uses multiple components like Nginx, Grafana, PostgreSQL, ClickHouse, VictoriaMetrics, […]
One of the questions I am often asked is in what cases I would prefer MyRocks over InnoDB. We have covered MyRocks in our blog previously: MyRocks Performance – Percona Database Performance Blog Saving With MyRocks in The Cloud – Percona Database Performance Blog But it would be good to refresh some materials. This time […]
In my talk at Percona Live 2021, “Creating Chaos in Databases”, I discussed how creating a controlled interruption in available resources (I used primary pod and network interruptions) allows us to test the stability of a database, and in our case, Percona XtraDB Cluster. I also mentioned in the talk that my testing led to diagnosing […]
In the previous release of our Percona Distribution for MySQL Operator, we implemented one interesting feature, which can be seen as “self-healing”: https://jira.percona.com/browse/K8SPXC-564. I do not think it got enough attention, so I want to write more about this. As it is well known, a 3-node cluster can survive a crash of one node (or […]
Our recent releases of Percona Operator for MySQL based on Percona XtraDB Cluster 1.8 and Percona Operator for MongoDB 1.7 come with a new interesting feature: Support of custom sidecars. What is special about this? There is often a need to customize the default installation, for example, one popular request is to support your favorite […]
I wrote about the usage of OpenEBS to manage local storage in Kubernetes in my previous posts: Deploying Percona Kubernetes Operators with OpenEBS Local Storage OpenEBS for the Management of Kubernetes Storage Volumes The primary reason to use the local storage is performance and the logical question is then: How big is the performance overhead […]
I recently wrote about OpenEBS in regard to local volumes in my post Deploying Percona Kubernetes Operators with OpenEBS Local Storage. And there are also my recent blog posts about Kubernetes, Percona Operators, and storage management problems: Using Volume Snapshot/Clone in Kubernetes ChaosMesh to Create Chaos in Kubernetes For me, working with my own deployment […]