What if you need absolute control over maintenance and package deployment or if you need to keep them up to date or if you need to automate the software management and the system provisioning with a high level of security, SUSE Manager is the right tool you need. In this blog post I will describe how to install the latest version of SUSE Manager 4.1.
What if you could clone a PostgreSQL database instantly without affecting the original source database, without impacting performance, without any external tool but using your linux Btrfs storage layer. This is what I will demonstrate in the following blogpost.
In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of MariaDB but rather a pluggable storage engine. This allows to move easily data from InnoDB to ColumnStore and it is also the first version to be released as a plugin for the community Server.
One really good feature from SUSE Linux Enterprise (SLE) is that it allows you to upgrade from your running system to a new service pack online. Let’s say from SLE 12 SP3 to SLE 12 SP4. No new installation is needed. All existing data are kept intact. In the following blog post, I will show you how easy it is.
Mistakes or accidental data deletions can sometimes happen on a productive MariaDB Galera Cluster and this can be disastrous. There are so many cases I have heard by customers and hereafter are some of the most common: – dropping one column of a table – dropping one table – updating a big table without a where clause What if it was possible to restore online a subset of data without downtime?
Registration Last Friday (17/01/20) I had the opportunity to go to Geneva at CERN to attend a PostgreSQL meetup. I’m really happy to write a blog about for a lot of reasons. First of all, it was about PostgreSQL (essential these days), also for the contributors as Oleg Bartunov and finally because of the organizers: Franck Pachot (old & soon new colleague by dbi-services) & Laeticia Avrot I met at the SOUG Day in Lausane.
What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines announced the version 1.7.4 with several new features. One of these was the support of…
My previous blog was about the MariaDB Galera cluster new features (version 10.4). Now I will only focus on the streaming replication and give you an overview of all the tests I performed. How to enable streaming replication? Quite easy, there are only 2 parameters: wsrep_trx_fragment_unit and wsrep_trx_fragment_size Then you have to choose a replication unit between the followings: . bytes and the fragment size is in bytes . rows and the fragment size is…