Tue, 13 Feb 2024 01:09:51 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/introducing-percona-builds-for-serverless-postgresql/ https://www.percona.com/blog/introducing-percona-builds-for-serverless-postgresql/#respond Wed, 01 Nov 2023 09:00:02 +0000 https://www.percona.com/blog/?p=85966 This 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 our collaboration […]]]> https://www.percona.com/blog/introducing-percona-builds-for-serverless-postgresql/feed/ 0 85966 https://www.percona.com/blog/charset-and-collation-settings-impact-on-mysql-performance/ https://www.percona.com/blog/charset-and-collation-settings-impact-on-mysql-performance/#comments Fri, 01 Sep 2023 10:11:30 +0000 https://www.percona.com/blog/?p=55666 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 web […]]]> https://www.percona.com/blog/charset-and-collation-settings-impact-on-mysql-performance/feed/ 6 55666 https://www.percona.com/blog/multi-tenants-and-branches-in-neon-serverless-postgresql/ https://www.percona.com/blog/multi-tenants-and-branches-in-neon-serverless-postgresql/#respond Tue, 21 Mar 2023 12:04:32 +0000 https://www.percona.com/blog/?p=86270 AnnouncementI will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested!IntroductionRecently, 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 easy experimentations with […]]]> https://www.percona.com/blog/multi-tenants-and-branches-in-neon-serverless-postgresql/feed/ 0 86270 https://www.percona.com/blog/using-docker-to-deploy-neon-serverless-postgresql/ https://www.percona.com/blog/using-docker-to-deploy-neon-serverless-postgresql/#respond Mon, 13 Mar 2023 13:53:38 +0000 https://www.percona.com/blog/?p=86063 AnnouncementI will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested!IntroductionRecently, 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 explore the capabilities […]]]> https://www.percona.com/blog/using-docker-to-deploy-neon-serverless-postgresql/feed/ 0 86063 https://www.percona.com/blog/deploying-mysql-group-replication-with-terraform/ https://www.percona.com/blog/deploying-mysql-group-replication-with-terraform/#respond Wed, 15 Feb 2023 14:16:53 +0000 https://www.percona.com/blog/?p=85403 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 […]]]> https://www.percona.com/blog/deploying-mysql-group-replication-with-terraform/feed/ 0 85403 https://www.percona.com/blog/deploying-percona-monitoring-and-management-with-terraform/ https://www.percona.com/blog/deploying-percona-monitoring-and-management-with-terraform/#respond Tue, 14 Feb 2023 13:03:17 +0000 https://www.percona.com/blog/?p=85369 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 we […]]]> https://www.percona.com/blog/deploying-percona-monitoring-and-management-with-terraform/feed/ 0 85369 https://www.percona.com/blog/coroot-the-next-level-in-kubernetes-observability/ https://www.percona.com/blog/coroot-the-next-level-in-kubernetes-observability/#respond Mon, 31 Oct 2022 12:39:55 +0000 https://www.percona.com/blog/?p=83333 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 […]]]> https://www.percona.com/blog/coroot-the-next-level-in-kubernetes-observability/feed/ 0 83333 https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-3-monitoring-and-pmm/ https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-3-monitoring-and-pmm/#respond Fri, 14 Oct 2022 11:14:24 +0000 https://www.percona.com/blog/?p=83185 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 installationWe recently […]]]> https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-3-monitoring-and-pmm/feed/ 0 83185 https://www.percona.com/blog/using-clickhouse-as-an-analytic-extension-for-mysql/ https://www.percona.com/blog/using-clickhouse-as-an-analytic-extension-for-mysql/#comments Thu, 13 Oct 2022 14:31:30 +0000 https://www.percona.com/blog/?p=83157 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 […]]]> https://www.percona.com/blog/using-clickhouse-as-an-analytic-extension-for-mysql/feed/ 1 83157 https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-2-percona-server-for-mysql-operator/ https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-2-percona-server-for-mysql-operator/#respond Tue, 11 Oct 2022 12:00:04 +0000 https://www.percona.com/blog/?p=83119 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 XtraDB Cluster […]]]> https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-2-percona-server-for-mysql-operator/feed/ 0 83119 https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-1-installation/ https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-1-installation/#respond Wed, 05 Oct 2022 11:55:05 +0000 https://www.percona.com/blog/?p=83054 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 Kubernetes […]]]> https://www.percona.com/blog/using-percona-kubernetes-operators-with-k3s-part-1-installation/feed/ 0 83054 https://www.percona.com/blog/scaling-mysql-a-good-problem-to-have/ https://www.percona.com/blog/scaling-mysql-a-good-problem-to-have/#respond Fri, 23 Sep 2022 11:54:14 +0000 https://www.percona.com/blog/?p=82831 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 step […]]]> https://www.percona.com/blog/scaling-mysql-a-good-problem-to-have/feed/ 0 82831 https://www.percona.com/blog/percona-server-for-mysql-automatic-cloud-deployment-with-terraform/ https://www.percona.com/blog/percona-server-for-mysql-automatic-cloud-deployment-with-terraform/#respond Tue, 20 Sep 2022 13:03:00 +0000 https://www.percona.com/blog/?p=82765 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 instances […]]]> https://www.percona.com/blog/percona-server-for-mysql-automatic-cloud-deployment-with-terraform/feed/ 0 82765 https://www.percona.com/blog/installing-pmm-server-from-rhel-repositories/ https://www.percona.com/blog/installing-pmm-server-from-rhel-repositories/#comments Tue, 23 Aug 2022 11:15:12 +0000 https://www.percona.com/blog/?p=82281 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 Managementor Podman:Podman – Percona Monitoring and ManagementWe implemented it this way to simplify deployments, as the PMM server uses multiple components like Nginx, Grafana, PostgreSQL, ClickHouse, VictoriaMetrics, etc. So we want […]]]> https://www.percona.com/blog/installing-pmm-server-from-rhel-repositories/feed/ 2 82281 https://www.percona.com/blog/myrocks-use-case-big-dataset/ https://www.percona.com/blog/myrocks-use-case-big-dataset/#respond Wed, 17 Aug 2022 12:05:57 +0000 https://www.percona.com/blog/?p=82213 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 BlogSaving With MyRocks in The Cloud – Percona Database Performance BlogBut it would be good to refresh some materials.This time I want to take […]]]> https://www.percona.com/blog/myrocks-use-case-big-dataset/feed/ 0 82213 https://www.percona.com/blog/chaos-testing-leads-to-more-stable-percona-xtradb-cluster/ https://www.percona.com/blog/chaos-testing-leads-to-more-stable-percona-xtradb-cluster/#comments Thu, 17 Jun 2021 12:56:47 +0000 https://www.percona.com/blog/?p=76745 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 a […]]]> https://www.percona.com/blog/chaos-testing-leads-to-more-stable-percona-xtradb-cluster/feed/ 1 76745 https://www.percona.com/blog/self-healing-feature-in-percona-distribution-for-mysql-operator/ https://www.percona.com/blog/self-healing-feature-in-percona-distribution-for-mysql-operator/#respond Thu, 10 Jun 2021 12:40:02 +0000 https://www.percona.com/blog/?p=76554 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 pod, in […]]]> https://www.percona.com/blog/self-healing-feature-in-percona-distribution-for-mysql-operator/feed/ 0 76554 https://www.percona.com/blog/using-sidecars-with-percona-kubernetes-operators/ Wed, 19 May 2021 13:00:43 +0000 https://www.percona.com/blog/?p=76146 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 monitoring […]]]> 76146 https://www.percona.com/blog/measuring-openebs-local-volume-performance-overhead-in-kubernetes/ Thu, 12 Nov 2020 15:37:51 +0000 https://www.percona.com/blog/?p=72661 I wrote about the usage of OpenEBS to manage local storage in Kubernetes in my previous posts:Deploying Percona Kubernetes Operators with OpenEBS Local StorageOpenEBS for the Management of Kubernetes Storage VolumesThe primary reason to use the local storage is performance and the logical question is then: How big is the performance overhead if we use […]]]> 72661 https://www.percona.com/blog/openebs-for-the-management-of-kubernetes-storage-volumes/ Mon, 09 Nov 2020 20:13:59 +0000 https://www.percona.com/blog/?p=72625 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 […]]]> 72625