Planet MariaDB

How on earth does Continuent maintain a less than three (3) minute Average Response Time for Urgent Support Requests? When was the last time you had an Urgent Support Request related to your MySQL HA/DR/Geo-scale deployment? And did you pay attention to how fast your provider could reply to you? For most of Continuent customers, the answer to Question#1 is: “It has been for a while.” We get an average total of 36 Urgent Support Requests per year. This is one Urgent Request every ten (10) days or so. As you can imagine, this is a minimal number of Urgent… Read more

Codership, the developers of Galera Cluster and Galera Manager, have new dates for the online DBA for Galera Cluster Training. There are two sets of times for our EMEA and American attendees, with the former happening on February 27th  and 28th, starting 10 AM CET and the latter happening on March 1st and 2nd, starting 9 AM EST.​​​​​ This is a hands on […]… Read more

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption.  Instead, it seems PostgreSQL Developers are of the opinion that encryption is a storage-level problem and is better solved on the filesystem or block device level.  I do not share […]… 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

One of the unpublished benefits of our training courses is that we hold an office hours session, usually one to two weeks after the training is complete, so that you can ask questions and receive answers. As always, we receive interesting questions, and this time we’ve decided to publish a selection of answers. You can […]… Read more

Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic. A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime […]… Read more

We have produced two new step-by-step videos for installing Galera Clusters either on premise and at Amazon EC2 environments. The videos can be replayed from links below. A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager A step-by-step video on how to install Galera Cluster in an […]… Read more

Introduction Did you ever wonder just what the Tungsten Manager is thinking when it does an automatic failover or a manual switch in a cluster? What factors are taken into account by the Manager when it picks a replica to fail over to? This blog post will detail the steps the Manager takes to perform a switch or failover. We will cover both the process and some possible reasons why that process might not complete, along with best practices and ways to monitor the cluster for each situation. Roles for Nodes and Clusters When we say “role” in the context… Read more

Database administrators often need to identify inactive databases and users to save resources.  This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users. This task is part of regular maintenance and helps to manage disk […]… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.1.2 and 2.7.8 GA releases. Download Now These … Continued… Read more

Attempts to compress PostgreSQL WAL at different levels are always around since the beginning. Some of the built-in features (wal_compression) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. But it is time to take another look at the built-in wal_compression because PostgreSQL […]… Read more

In May 2020, I published a Planet for the MySQL Community Pluto Beta.  I was satisfied with the result and was considering it done, but I did not invest the time to promote it to release (a non-beta site was running for a few months without being advertised).  I finally came to it, and today I am happy to deprecate the beta and announce the release of Planet for the MySQL Community.  In this post… Read more

dbaas-operator is Yet Another DBaaS Kubernetes Operator (need to suggest yadbko as a name) that tries to simplify and unify Database Cluster deployments by building a higher abstraction layer on top of Percona Kubernetes Operators. So it becomes much easier to deploy the DB cluster with dbaas-operator and PMM DBaaS on top of it. But another part of the picture is applications and their workloads to connect to the deployed DB Clusters…. Read more

I used the insert benchmark to compare ARM and x86 servers on AWS. For ARM I used c7g and for x86 I used c6i. The goal was to compare ARM vs x86 on similar hardware (OS, vcpu, RAM and EBS setups were the same). While I am not trying to start a benchmarketing battle for c7g vs c6i or Postgres vs MySQL, I suppose that might happen. My goal in doing comparisons like this is to find things that can be improved. Also, in-memory workloads aren't the target use case for MyRocks. It doesn't do great on them. It does do… Read more

We are pleased to announce that Tungsten Dashboard GA Version 1.0.12 is now available for customers to download! Tungsten Dashboard v1.0.12 mainly provides support for the new datasource drain feature in Tungsten Clustering v7.0.2, along with a few improvements and bugfixes. Here are the changes: The new datasource drain feature in Tungsten Clustering v7.0.2 is now supported in the Tungsten Dashboard node menus. There is a new, related setting called drainTimeout which controls the length of time to wait before closing the connection to a database node from a Connector. Corrected location.reload(true) JavaScript bug to now use window.location.href = window.location.href… Read more