Infrastructure at your Service

Category

Database Administration & Monitoring

Microsoft Team

SQL Server AlwaysOn and availability groups : session timeout parameter

By | Database Administration & Monitoring | 15 Comments

Have you ever faced to timeout issues with SQL Server availability groups? If you take a look at the timeout parameters for an availability group, you will find a plenty of configuration settings. Indeed, you have timeout parameters for the availability group itself, for the replicas and for cluster itself as well. Well …a lot of parameters in order to deal with timeout issues. In fact, some of them can be very helpful regarding the…

Read More
David Hueber

About SSH keys in Oracle Public Cloud

By | Database Administration & Monitoring, Technology Survey | No Comments

When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way accessing it. Of course afterward additional ports/services can be opened. However the question is how to manage these keys and how important are they?

Read More
Daniel Westermann

Launching a VM with the Amazon AWS command line tools

By | Database Administration & Monitoring | No Comments

The cool thing with Amazon AWS is that you can use command line tools on your workstation to bring up and manage your services. In this post I’ll look into how you can launch a Linux VM from the command line and how you can attach a storage volume to it. Before you can use the command line tools you’ll need to create a user that has the proper permissions to connect. This must be…

Read More
Daniel Westermann

External tables in PostgreSQL?

By | Database Administration & Monitoring | No Comments

In Oracle you can use the external table feature to load data from files into the database. The traditional way to do this in PostgreSQL is to use the copy command. But there is another option which makes use of foreign data wrappers. The foreign data wrapper for doing this is file_fdw. For creating some data here is a little script which generates 1’000 lines of the form: ID, TEXT: #!/bin/bash OUTPUT=”/var/tmp/data.csv” `rm -rf ${OUTPUT}`…

Read More
Mouhamadou Diaw

Protect your oracle password function

By | Database Administration & Monitoring | 13 Comments

Every DBA knows the famous oracle password verification script $ORALE_HOME/rdbms/admin/utlpwdmg.sql This function can be used to control password complexity. This script should be protected from unauthorized users. The reason is that by adding an insert in this function, someone can get passwords of users in the database. Let’s go through an example Here is my script (I have modified initial oracle script by just adding the 2 lines after the BEGIN)   CREATE OR REPLACE…

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Loading the beast

By | Database Administration & Monitoring | No Comments

The last posts outlined how you can bring up a PostgreSQL instance in the Amazon cloud, how you can restrict access to the instance, how you can configure it and how you can add a read replica. In this post we’ll look at how you can load data to the instance. A database without data does not make much sense, does it? For having some data available to load I’ll populate my local PostgreSQL 9.4…

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Adding a replica to the beast

By | Database Administration & Monitoring | No Comments

In the last post I looked on how you can change the PostgreSQL parameters when the instance is running in the Amazon cloud. In this post we’ll look at how to add a replica to the PostgreSQL instance that is already running. Even if you push things to the cloud you want to make sure that you have a standby database in case the master crashes. At best the replica is running in another data…

Read More
Franck Pachot

log file sync / user commits

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . When presenting ‘Interpreting AWR Reports – Straight to the Goal’ at UKOUG TECH15 I had a very good question about the Statspack report I read which had log file sync much smaller than user commits. I realized that this needs a longer explanation, and that my slide is very misleading because I divided log file sync wait time per user commits, which probably make no sense here.

Read More