Infrastructure at your Service

 
Daniel Westermann

PostgreSQL 13 will allow to drop databases even when there are connections

By | Database Administration & Monitoring | No Comments

One of the most popular blogs I’ve written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). One of the points mentioned in that post was, that you can not drop a database as long as there are sessions against the database you want to drop. This will change with PostgreSQL 13, which is currently in development.

Read More
Saïd Mendi

Galera Cluster 4 with MariaDB 10.4.8: part 2

By | Database Administration & Monitoring | No Comments

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…

Read More
Daniel Westermann

A simple Terraform script to create an AWS EC2 playground

By | Cloud, Database Administration & Monitoring | No Comments

When I started to write the blog about AWS SSM I quickly realized that I need a way to bring up and destroy my AWS EC2 playground in an easy and reproducible way. There are several options for this: I could have used the AWS command line interface or AWS CloudFormation. Both work pretty well and would have been more than enough for my simple requirements. In the end I decided to use Terraform for…

Read More
Jérôme Dubar

odacli create-database error DCS-10802: Insufficient disk space on file system: database

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

Introduction I was reimaging an X6-2M ODA after various patching troubles, and everything was fine. After several databases created, the next ones could no more be created. DCS-10802: Insufficient disk space on file system: database. Expected free space (MB): {1}, available space (MB): {2} I’ve spent some time on it, and finally found the cause of the problem. And the solution. Context After successfully reimaged an X6-2M ODA with 18.5, and applied the patch for…

Read More
Daniel Westermann

Avoiding patching madness by using AWS SSM

By | Cloud, Database Administration & Monitoring | No Comments

As we have more and more customers either currently moving to AWS or already moved much, if not even all, of their workloads to AWS, one question pops up quite frequently: Now that we have so many EC2 instances up and running how do we regularly patch them? There are many tools around for patching operating systems, such as Microsoft SSCM, Red Hat Satellite or SUSE Manager just to name a few. There are many…

Read More
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
Saïd Mendi

Galera Cluster 4 with MariaDB 10.4.8

By | Database Administration & Monitoring | No Comments

Last month, by a new customer I had to install the latest version of the MariaDB server: 10.4.8 to setup a Galera Cluster with 3 master nodes. The good news was that this version was shipped with the latest version of the Galera Plugin from Codership: Galera Cluster 4.0. As usual, installation & configuration was quitte easy. $ sudo yum -y install MariaDB-server $ sudo yum list installed|grep -i mariadb MariaDB-client.x86_64 10.4.8-1.el7.centos @mariadb-main MariaDB-common.x86_64 10.4.8-1.el7.centos…

Read More
Mehdi Bada

Create a Kubernetes cluster with Google Kubernetes Engine

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

Nowadays the market for cloud providers is very competitive. Large companies are fighting a very hard battle over the services they provide. Each offers a wide range of more or less identical products with specific features for each. In my point of view, having deployed Kubernetes clusters in several environments (Cloud and On-Premise), I pay particular attention to Google Cloud for its Google Kubernetes Engine offer. The deployment of a Kubernetes cluster is very fast…

Read More
Daniel Westermann

pg_auto_failover: Setup and installation

By | Database Administration & Monitoring | No Comments

When I attended PGIBZ 2019 earlier this year, I talked with Dimitri about pg_auto_failover and I promised to have a look at it. Well, almost half a year later and after we’ve met again at pgconf.eu it is time to actually do that. You probably already know that citudata was acquired by Microsoft earlier this year and that Microsoft seems to be committed to open source since a few years. pg_auto_failover is one of the…

Read More