Infrastructure at your Service

All Posts By

Julia Gugel

Julia Gugel

Connection pooling with PgBouncer

By | Database Administration & Monitoring | No Comments

Some of you may know the case: As soon as the number of users grow, the number of resource problems increases. Have you ever thought about using a connection pooler? Too complex, too much administration effort? In this post I like to explain, how the connection pooler can help you with your memory, as well as showing you the simplicity of setup connection pooling with PgBouncer.

Read More
Julia Gugel

How to scale up a Patroni cluster

By | Database Administration & Monitoring | No Comments

During the preparation of my presentation for the pgconf.eu I ran into one big issue. I had to stop my cluster to add a new node. That was not the way I wanted to archive this. I want a high availability solution, that can be scaled up without any outage. Due to a little hint during the pgconf.eu I was able to find a solution. In this post I will show the manually scale up,…

Read More
Julia Gugel

SLES15 SP1 – New features

By | Operation systems | No Comments

With SLES15 SUSE introduced the Multimodal OS and the unified installer. Means, you only get what you really need. Your OS is flexible and you can easily add features you need and remove them as well. But this article shouldn’t be an explanation of the multimodal OS, it will show you some of the new features of SLES15 SP1.

Read More
Julia Gugel

DC/OS: Install Marathon-LB with keepalived

By | Database Administration & Monitoring | No Comments

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, based on HAProxy) 2. Named VIPs (a layer 4 load balancer used for internal TCP traffic) In this article we will use Marathon-LB. In case you want to read more about the VIP solution, just…

Read More