Infrastructure at your Service

All posts by Grégory Steulet

Grégory Steulet
Chief Financial Officer (CFO)
Delivery Manager
Grégory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix/Linux, etc.). Grégory Steulet is "Oracle Certified Professional 10g", "MySQL Cluster 5.1 Certified", and "Avaloq Certified Professional 2.6". Prior to joining dbi services, Grégory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Grégory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services / Banking, Logistics, Pharma etc.
Grégory Steulet

Password Validation in MySQL

By | Database Administration & Monitoring | No Comments

Introduction on validate_password plugin Since version 5.6.6 MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security. The goal of this blog is to provide you a short overview of the functionalities provided through this plugin and illustrate these functionalities with concrete examples. As explained into the documentation The validate_password plugin implements two capabilities: 1. The plugin checks the password against the current password…

Read More
Grégory Steulet

Can you trust option_packs_usage_statistics.sql ?

By | Database Administration & Monitoring | One Comment

Introduction As a former Oracle LMS qualified auditor my opinion is sometimes requested before/during/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if “The Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide opinions on compliance status and will provide guidance, education and impartial opinions on a customer or partner’s compliance state. For…

Read More
Grégory Steulet

La Suisse concernée par le RGPD ?

By | Database Administration & Monitoring | No Comments

Le 25 mai 2018 entretra en application le Règlement Général sur la Protection des Données (RGPD). Il impactera toutes les entreprises opérant du traitement de données à caractère personnel sur des résidents européens. A l’aube de cette échéance, beaucoup de fausses informations circulent au sein des entreprises suisse. L’objectif de ce blog est d’apporter quelque lumière sur les questions qui se posent. Pour ce faire, nous avons demandé à Me Metille, avocat spécialisé en protection…

Read More
Grégory Steulet

GDPR compliant by installing software editors tools?

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

GDPR goals and scope In few months (25 May 2018) the EU General Data Protection Regulation (GDPR) will be in force and will replace the Data Protection Directive 95/46/EC. His goals are to harmonize data privacy laws across Europe, to protect and empower all EU citizens’ data privacy and to reshape the way organizations across the region approach data privacy. You can find all information related to GDPR on https://www.eugdpr.org and the official PDF of…

Read More
Grégory Steulet

Oracle Licensing (R)evolution with VMware

By | Database Administration & Monitoring | No Comments

In 2015 I wrote a blog named “All you need to know about Oracle Database licensing with VMware”. This blog generated lots of comments and hopefully helped some DBAs and IT Managers understanding the potential issues that they can face in case of Oracle LMS Audit. In 2 years I made some new experiences related to Oracle LMS audit and I’d like to share those experiences with you to provide you up to date information….

Read More
Grégory Steulet

MySQL FATAL: error 1040: Too many connections & 1135 Can’t create a new thread

By | Database Administration & Monitoring | No Comments

Hi folks, Some of you probably already got error 1040 by playing with sysbench for instance and multiplying the number of MySQL threads. Documentation and blogs usually simply state that you have to increase the number of max_connections and the open files limit. If you tried and you didn’t succeed this blog is for you. Despite the following entries in /etc/my.cnf the max_connections and open_files_limit are not set correctly: max_connections = 8000 open_files_limit = 8192…

Read More
Grégory Steulet

All you need to know about Oracle Database licensing with VMware

By | Hardware & Storage | 79 Comments

You are running Oracle on VMware and are not 100% sure that you are compliant with the Oracle licensing rules? This article is for you! As I have been confronted several times with Oracle License reviews with VMware installations, I decided to write this article in order to provide answers to the most frequent questions I have received from customers. Introduction Licensing is not an easy topic to address and this difficulty is not specific…

Read More
Grégory Steulet

MySQL versions performance comparison

By | Application integration & Middleware | 6 Comments

This blog aims to make a performance comparison between the different MySQL versions/editions and also comparing the differents MySQL forks such as Percona Server and MariaDB.  Indeed number of improvements as been done to innodb storage engine in the last MySQL versions. You can find below some of the performance improvements applied to InnoDB these last years (non exhaustive list): MySQL 5.0 1. New compact storage format which can save up to 20% of the…

Read More
Grégory Steulet

Taskset: a useful tool to set CPU affinity

By | Application integration & Middleware | No Comments

Today at the #ukoug_tech14 I had the chance to attend to the Christo Kutrovky’s session @kutrovsky (Pythian) about “Measuring Performance in Oracle Solaris & Oracle Linux”. This session aimed to present how to measure system utilization in the Linux and Oracle Solaris operating systems and how to use these information for tuning and capacity planning. During this session we had a very good introduction to a bunch of performance monitoring tools that can be categorized…

Read More
Grégory Steulet

FIO (Flexible I/O) – a benchmark tool for any operating system

By | Operation systems | No Comments

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I had the opportunity to discover some interesting commands and tools such as FIO (Flexible I/O). FIO is a workload generator that can be used both for benchmark and stress/hardware verification. FIO has support for 19 different types of I/O engines (sync, mmap, libaio, posixaio,…

Read More