Planet MariaDB

Ensuring that databases are highly available is not just a thing these days, it’s the thing.  Downtime, whether scheduled or unplanned, is barely, if at all, tolerated by end users. The consequences of downtime can be severe and may include things like loss of customers, damage to your reputation, or penalties for not meeting Service […]… Read more

Many MySQL DBAs have expressed interest in learning about PostgreSQL and this series is a guided tour through the basics. One of the ‘Wow! That is Different!’ things for MySQL DBAs looking at PostgreSQL are sequences.  Sequences can be used as a rough equivalent to MySQL’s AUTO_INCREMENT but that is only part of the story. […]… Read more

Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners. In Percona Server for MySQL 8.0.28-20, we added a new component called Encryption UDFs – an open-source alternative to […]… Read more

Though I am writing this post being a PostgreSQL DBA, this page can be read by anyone because the concept of corruption is the same in every database. After reading this blog post, one should understand what database corruption is and how it may occur. Being DBAs, corruption is something we do not want to […]… Read more

Introduction Tungsten Clustering is a powerful tool with many moving parts, including the Tungsten Connectors which may be installed on any application server. During a troubleshooting event, it is helpful to understand what to look for and where, in addition to understanding how the logs work together to provide a clear picture of the situation. In Tungsten version 7, we introduced a number of features designed to make troubleshooting easier. In this blog post, we will cover the basic three log files (trepsvc.log, tmsvc.log and connector.log) and the relationships between them. We will also explore the new commands and log… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.0.6 and 2.7.6 GA releases. Download Now Release … Continued… Read more

As a member of the Percona cloud team, I run a lot of databases in Kubernetes and our Percona Operator for MongoDB in particular. Most of us feel comfortable with rather small and tidy infrastructure, which is easy to control and operate. However, the natural growth of the organization brings a lot of challenges to […]… Read more

I have already presented in previous posts some of the new features available on MongoDB 5.0: resharding and time series collections. Please have a look if you missed them: MongoDB 5.0 Time Series Collections Resharding in MongoDB 5.0 In this article, I would like to present another new feature: window functions. Window functions are quite […]… Read more

PostgreSQL’s built-in autovacuum – the housekeeper – is improving, version after version. It is becoming more capable while reducing its overhead and addressing edge cases. I think there is no PostgreSQL version that comes out without any autovacuum improvement, and no doubt that it is good enough for the majority of use cases. But still, […]… Read more

We descended to Austin, Texas, to have a booth, and several talks and tutorials by Seppo Jaakola and Colin Charles, at Percona Live Austin 2022 (what a gap since the last in-person event we had was in 2019!). Present was also GUI developer of Galera Manager, Mihael Lenic and sales extraordinaire, Larissa Urse. Rather than […]… Read more

 This is mostly a note to myself to explain what I do to setup a server on GCP for database benchmarks.Create the instance:Confirm that quota limits have not been reached on the Quotas page.Go to the VM instances page and click on Create InstanceEdit the instance nameEdit the region (us-west1 for me)Choose the instance type. Click on Compute Optimized, select the c2 series, select the Machine Type and then c2-standard-60.Disable hyperthreading to reduce benchmark variance. Click on CPU Platform and GPU, click on vCPUs to core ratio and choose 1 vCPU per core.Scroll down to Boot disk and click on Change…. Read more

Percona Server for MongoDB (PSMDB) upgrade, major and minor versions In this blog, we will see the best practices for upgrading major and minor versions of the clusters (Replica Set and Shard Cluster) with no downtime, in a rolling manner. Percona Server for MongoDB (PSMDB) has versions like A.B.C where A.B refers to the major […]… Read more

It’s time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers […]… Read more

Introduction Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime. Zero-Downtime Upgrade Steps This is a zero-downtime upgrade: Pick a replica node and shun it, and take all replication offline Upgrade the MySQL Server on that node Bring up replication and verify health Welcome the replica node back into the cluster Repeat for the other Replica node Perform a switch of the Primary to one of the upgraded Replicas Upgrade the old Primary with the… Read more

We are pleased to announce MariaDB Connector/R2DBC 1.1 as GA (Generally Available). MariaDB Connector/R2DBC 1.1 now implements the R2DBC 0.9.1 … Continued… Read more