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

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

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
Grégory Steulet

Security improvements in MySQL 5.7

By | Database management | One Comment

If you have a look on the last mysql 5.7.4 version or later you will probably see that there are several security improvements. The list of added security features and improvements can be seen on the following page: http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html There are three main improvements that are shortly described in this blog: 1. Nonempty plugin column 2. Password lifetime policy 3. mysql_install_db secured Nonempty plugin column As of MySQL 5.7.2, the server requires account rows in…

 
Read More
Grégory Steulet

Oracle AVDF – Database Firewall Policies

By | Database management | 2 Comments

The successful deployment of a Database Firewall depends on an effective policy. Oracle AVDF includes preconfigured firewall policies as described in the Firewall Policy page in the Policy tab of the Audit Vault Server console. These include policies that log all SQL statements, or log only unique SQL statements. In addition, the Database Firewall policy editor enables you to design your own policies quickly and efficiently. Policy rules can depend on any combination of the…

 
Read More
Grégory Steulet

Oracle AVDF post-installation configuration

By | Database management | 2 Comments

In one of my last blog, named: “Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox” I explained how to install AVDF on VirtualBox. Since some of you asked for a blog on “How to configure AVDF”, I decided to write this posting on AVDF post-installation configuration. This one only concerns the post-installation phase, a third blog will be dedicated to practical cases concerning the configuration of Database Firewall Policies. Specifying the…

 
Read More