Infrastructure at your Service

Linux Archives - Page 3 of 4 - Blog dbi services

Daniel Westermann

2016 is over and it was great, 2017 will be even more exciting in the open source area

By | Database Administration & Monitoring | No Comments

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our Open Infrastructure division. We’ll start with a few figures then look at the events we did and some of the projects we completed in 2016. Here we go …  

 
Read More
David Barbarin

First installation of SQL Server on Linux REHL 7.2

By | Database Administration & Monitoring | No Comments

As you certainly know Microsoft announced yesterday the first preview of SQL Server vNext on Linux. Obviously we are far from a final version suitable for production and the list of unsupported features will probably be good indicator of the production maturity over the time. So as many people, I could not wait to do a try of installing SQL Server on Linux version. The installation process is well documented and I would like to…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

By | Operation systems | No Comments

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is a Java utility and exists since OSWatcher version 4.0.0. It permits to create graphs and complete HTML reports containing collected OS statistics.   OSWBBA require no installation. It is embedded in the OSWatcher home directory. To start the…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box (OSWBB)

By | Operation systems | No Comments

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it gives a system health state at a given moment. OSWBB is multi-platforms supported (AIX, Solaris, HP-UX, Linux and Windows) and…

 
Read More
Daniel Westermann

Running PostgreSQL on ZFS on Linux

By | Database Administration & Monitoring | No Comments

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement for ZFS being production ready was back in 2013. So why not run PostgreSQL on it? ZFS provides many cool features including compression, snapshots and build in volume management. Lets give it a try and do an initial setup. More details will follow in…

 
Read More
William Sescu

List usernames instead of uids with the ps command for long usernames

By | Database management, Operation systems | No Comments

Have your ever faced such a situation. You have usernames in your /etc/passwd file with more than 8 characters. This is no problem for Linux at all, usernames may be up to 32 characters long, only your ps output might look a little scrambled. It shows you the uid instead of the username like in the following example: $ id uid=20001(longuser01) gid=10002(oinstall) groups=10002(oinstall) $ sleep 1000000 & $ ps -ef | grep sleep | grep…

 
Read More
William Sescu

How to do a Filesystem Resize (ext3/ext4) on Redhat running on VMware

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

A filesystem resize can be done in several ways, online, offline, with LVM2 or without LVM2.  However, this blog will describe how to do an online resize of ext3/ext4 filesystems where a virtual disk (vmdk) is online added to a VMware Redhat guest OS. So let’s start with the online filesystem resize of ext3/4 filesystems on the Redhat guest OS.  A new virutal disk (preferably an eagerd zero thick on VM running Oracle) was added…

 
Read More