Database Administration & Monitoring

Rancher on SLES 15 as a demo environment

If you followed the last posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes and Rancher,(…)

Oracle Database Appliance: ODA patch 19.10 is out

Introduction 4 months after the 19.9, here comes the 19.10 version of the Oracle Database Appliance patch. Let’s have a look at what’s new. Will my ODA supports this 19.10 patch? The 19.10 release will be the same for all(…)

Rancher, up and running, on EC2 – 2 – Three nodes

In the last post we've brought up a RKE Kubernetes cluster on a single node. While that is cool for demonstration purposes or testing, this is nothing for a real life setup. Running the control pane, the(…)

SUSE RANCHER 2.5 – Monitoring Setup

In this short blog post, I will discuss about SUSE Rancher 2.5, the latest version. In this release, the rancher-monitoring has been introduced. With this cool feature, you can quickly deploy open-source monitoring as Promotheus and Grafana for your kubernetes(…)

How to configure additional listeners on ODA

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to(…)

Be careful with prepared transactions in PostgreSQL

PostgreSQL gives you the possibility for two-phase commit. You'll might need that if you want an atomic distributed commit. If you check the PostgreSQL documentation there is a clear warning about using these kind(…)

Oracle Database Appliance: what have you missed since X3/X4/X5?

Introduction ODA started to become popular with X3-2 and X4-2 in 2013/2014. These 2 ODAs were very similar. The X5-2 from 2015 was different with 3.5 inches disks instead of 2.5 inches and additional SSDs for small databases (FLASH diskgroup).

SQL Server: Control the size of your Transaction Log file with Resumable Index Rebuild

Introduction In this blog post, I will demonstrate how the Resumable capability of Online index rebuild operation can help you to keep the transaction log file size under control. An index rebuild operation is done in a single transaction(…)

[Data]nymizer – Data anonymizer for PostgreSQL

Often there is the requirement to populate a test or development database with data from production, but this comes with a risk: Do you really want, that developers or testers have access to sensitive data? In a lot of companies(…)

8000 PostgreSQL clusters on one host?

Coming back to the last post: 8000 databases in one PostgreSQL cluster?. As we've seen this is doable but comes with a lot of pain points. Another solution for this kind of requirement would be to host(…)