Database Administration & Monitoring, Database management, PostgreSQL Patroni Operations – Changing Parameters 30.10.2019 by Open source Team Sooner or later all of us have to change a parameter on the database. But how is this put into execution when using a Patroni cluster? Of course there are some specifics you have to consider. This post will give(…)
PostgreSQL pgconf.eu – Welcome to the community 18.10.2019 by Open source Team On tuesday I started my journey to Milan to attend my first pgconf.eu, which was also my first big conference. I was really excited what will come up to me. How will it be, to become a visible part of(…)
Database Administration & Monitoring, PostgreSQL Patroni Operations – switchover and failover 11.10.2019 by Open source Team In this post we will have a look at switchover and failover of a Patroni cluster. As well as a look at the maintenance mode Patroni offers, which gives the opportunity to prevent from an automatic failover.
Database Administration & Monitoring Rolling Upgrade of a Galera Cluster with ClusterControl 23.09.2019 by Open source Team Rolling Upgrade is easy In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster “Rolling Upgrade” without any loss of service. Let’s say we want to upgrade from Percona XtraDB Cluster(…)
Database Administration & Monitoring In-person event (June 11,2019) Ansible Automates – Bern 19.06.2019 by Open source Team A couple of weeks ago, I found in my inbox an invitation from Red Hat concerning an event organized in Bern about Ansible. I heard a lot about Automation but did not really know what can or could be(…)
Database Administration & Monitoring Two node patroni does not failover when one node crashes 30.04.2019 by Open source Team A few days ago I had the interesting mission to build a two Node Patroni Postgres 9.6 Cluster using etcd in our openDB Appliance environment. Sounds easy, one leader, one secondary, both running etcd, that's it. But that's only the(…)
Database Administration & Monitoring DC/OS: Install Marathon-LB with keepalived 13.11.2018 by Open source Team After the minimal setup of the DC/OS in my further articles, I wanted to extend my DC/OS and add a loadbalancer. There are two options for loadbalancing in DC/OS 1. Marathon-LB (a layer 7 load balancer, used for external requests,(…)
Database Administration & Monitoring How uid mapping works in Docker containers? 02.05.2018 by Open source Team It can be interesting to see how uids between the docker host and docker containers are mapped. For example, for security concerns. As a reminder, docker containers are based on two linux kernel features:(…)
Database Administration & Monitoring How to reduce the size of an LVM partition formatted with xfs filesystem on CentOS7? 06.12.2017 by Open source Team DISCLAIMER: I know it exists other solutions to do it Pre-requisites: – a virtual machine (or not) with CentOS7 installed – a free disk or partition I use a VBox machine and I added a 5GiB hard disk(…)
Database Administration & Monitoring, Database management Install Apache Kafka on Linux 09.06.2017 by Open source Team What is Apache Kafka ? No, Kafka is not only the famous author (en.wikipedia.org/wiki/Franz_Kafka), it’s an open-source distributed pub-sub messaging system with powerful skills like scalability and fault tolerance. It’s also a stream processing platform (near real-time) for(…)