by Sergey Pronin | Feb 24, 2021 | Cloud, Monitoring, MySQL, Percona Software
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona...
by Akira Kurogane | Feb 15, 2021 | Cloud, Insight for DBAs, Insight for Developers
For MongoDB data directories only XFS is recommended. The ext4 filesystem isn’t so bad but when there are a very, very high number of random accesses (which WiredTiger can reach) it can hit a bottleneck. To be fair most deployments will never hit this...
by Sergey Pronin | Feb 12, 2021 | Cloud, Monitoring, Open Source, Percona Software
More and more companies are adopting Kubernetes, but after some time they see an unexpected growth around cloud costs. Engineering teams did their part in setting up auto-scalers, but the cloud bill is still growing. Today we are going to see how Percona Monitoring...
by Sergey Pronin | Feb 8, 2021 | Cloud, Insight for DBAs, Open Source, Percona Software
Running Database-as-a-Service (DBaaS) in the cloud is the norm for users today. It provides a ready-to-use database instance for users in a few seconds, which can be easily scaled and usually comes with a pay-as-you-go model. We at Percona see that more and more cloud...
by Ivan Groenewold | Jan 28, 2021 | Cloud, MySQL, ProxySQL
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the...
by Jobin Augustine | Jan 22, 2021 | Benchmarks, Cloud, Insight for DBAs, PostgreSQL
The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, and we were curious to see how it performs with PostgreSQL. The general availability of ARM-based servers for testing and evaluation was a major obstacle....
by Sergey Pronin | Jan 20, 2021 | Cloud, Open Source, Percona Software, Security
What is Node Draining? Anyone who ever worked with containers knows how ephemeral they are. In Kubernetes, not only can containers and pods be replaced, but the nodes as well. Nodes in Kubernetes are VMs, servers, and other entities with computational power where pods...
by Sergey Pronin | Jan 13, 2021 | Cloud, Insight for DBAs, Open Source, Percona Software
What is Edge Edge is a buzzword that, behind the curtain, means moving private or public clouds closer to the end devices. End devices, such as the Internet of Things (from a doorbell to a VoIP station), become more complex and require more computational power. There...
by Stephen Thorn | Jan 6, 2021 | Cloud, Insight for DBAs, MySQL, Webinars
Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options’ pros and cons. This webinar was recorded and can...
by Tomislav Plavcic | Jan 6, 2021 | Cloud, Insight for DBAs, MongoDB, Percona Software
So far, Percona Kubernetes Operator for Percona Server for MongoDB (PSMDB) has supported only managing replica sets, but from version 1.6.0 it is possible to start a sharding cluster, although at the moment only with one shard. This is a step toward supporting full...
by Ivan Groenewold | Dec 21, 2020 | Cloud, Insight for DBAs, MySQL, Percona Services
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined...
by Sergey Pronin | Dec 7, 2020 | Cloud, Insight for DBAs, MongoDB, Open Source, Percona Software
Last year AWS was about to ban the “multi-cloud” term in co-branding guides for Partners, removed the ban after community and partners critique, and now embraces multi-cloud strategy. One of the products that AWS announced during its last re:Invent was Amazon EKS...
by Sergey Pronin | Nov 23, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration....
by Sergey Pronin | Nov 13, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Our recent survey showed that many organizations saw unexpected growth around cloud and data. Unexpected bills can become a big problem, especially in such uncertain times. This blog post talks about how Kubernetes scaling capabilities work with Percona Kubernetes...
by Vadim Tkachenko | Nov 12, 2020 | Cloud, Insight for DBAs, Open Source
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...
by Vadim Tkachenko | Nov 9, 2020 | Cloud, Insight for DBAs, Insight for Developers, Open Source
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...
by Vadim Tkachenko | Nov 5, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to deploy our own Database-as-Service, based on fully OpenSource components and independent from any particular cloud provider. Today I want to mention an...
by Sergey Pronin | Nov 4, 2020 | Cloud, MySQL, Percona Software, Security
Kata containers are containers that use hardware virtualization technologies for workload isolation almost without performance penalties. Top use cases are untrusted workloads and tenant isolation (for example in a shared Kubernetes cluster). This blog post describes...
by Dawn Heiberg | Nov 3, 2020 | Cloud, Database Trends, Insight for DBAs
In this year’s Open Source Data Management Software survey, we asked organizations “What issues have you experienced in the last 12 months?” The main issue, flagged by three-quarters of respondents, was performance. Given the adverse impact that data slowdown has on...
by David Quilty | Nov 3, 2020 | Cloud, Insight for DBAs, MongoDB, Percona Software, Webinars
There are many potential benefits to moving to the cloud such as increasing resources on the fly, multi-region infrastructure, and hardware maintenance, to mention only a few. On the other hand, there are critical points such as security (the latest was MEOW attack),...
