Blog et Aide mémoire informatique

mercredi 27 janvier 2021

Is Serverless with Lambda, the “silver bullet”?

My first Medium Article on Serverless Lambda. Is Serverless with Lambda, the “silver bullet”?

lundi 11 janvier 2021

Excel SUM With Filtered Fields


jeudi 2 juillet 2020

Latest Command Line

du -sh /* 
Run task in Background
nohup command


jeudi 11 juillet 2019

Elastic Beanstalk : Some fail

List of tips and tricks hardly discovered setting up a Elastic Beanstalk

Lire la suite

mardi 2 juillet 2019

Tuning Linux server

Some configuration to tune

Lire la suite

vendredi 28 juin 2019

AWS Athena : Partition

Quick Tips AWS athena

Lire la suite

jeudi 20 juin 2019

Increase Ulimit to solve heavy http traffic

Check some values

See ulimit , also per user
sudo su {user} 
#all limit
ulimit -a

#Ulimite -hard: 
ulimit -Hn

#Ulimite -Soft: 
ulimit -Sn
List open file per process or per user
lsof -p {pid}| wc -l
lsof -u {youruser} |wc -l
List Network connection per state
netstat -an|awk '/tcp/ {print $6}'|sort|uniq -c
List php-fpm process running
ps aux | grep php-fpm | wc -l

Apply Ulimit change

sudo vi /etc/security/limits.conf

*       soft    nofile  65000  //for all user
user  soft     nofile  5000 // for a specific user

Too many connection in time-wait

This should not be too problematic according source below. One solution will be to open the service on several port and balance connexion to several port.

Some source

mercredi 10 avril 2019


In order to use the ssh-key in Bastion and leap-frog to protected server

Make sure the ssh agent is running
eval `ssh-agent -s`
then add your key
ssh-add -k your-key.pem
ssh-add -L
Then use the ssh agent
ssh -A ec2-user@your-ip

mercredi 20 février 2019

Elasticsearch quorum : Split Brain

A quorum is Number of Dedicated Master Nodes / 2 + 1 (rounded down to the nearest whole number), which Amazon ES sets to discovery.zen.minimum_master_nodes when you create your domain. In this case, 2 / 2 + 1 = 2. Because one dedicated master node has failed and only one backup exists, the cluster does not have a quorum and cannot elect a new master. nearest whole number), which Amazon ES sets to discovery.zen.minimum_master_nodes when you create your domain.

vendredi 1 février 2019

Monitor progress on copy DD command

When you use dd copy,
dd if=/dev/xvdf of=/dev/xvdg bs=4096 
just monitor progress this way.
watch -n5 'sudo kill -USR1 $(pgrep ^dd)'
Some more fancy progress tools :

vendredi 18 janvier 2019

Root User Name AMI on AWS

et the default user name for the AMI that you used to launch your instance
For Amazon Linux 2 or the Amazon Linux AMI, the user name is ec2-user.

For a Centos AMI, the user name is centos.

For a Debian AMI, the user name is admin or root.

For a Fedora AMI, the user name is ec2-user or fedora.
For a RHEL AMI, the user name is ec2-user or root. For a SUSE AMI, the user name is ec2-user or root. For an Ubuntu AMI, the user name is ubuntu. Otherwise, if ec2-user and root don't work, check with the AMI provider.

vendredi 11 janvier 2019

Using Mapping into Cloudformation, and openapi Yaml

How to declare a mapping in your cloudformation and use it in your Linked openapi.yml file

Lire la suite

mercredi 26 décembre 2018

Docker PostgreSQL

Start the Docker
docker run --rm   --name pg-docker 
-d -p 5432:5432 
-v $HOME/docker/volumes/postgres:/var/lib/postgresql/data  postgres
List Database
SELECT datname FROM pg_database
WHERE datistemplate = false;
List Schema
SELECT schema_name FROM information_schema.schemata;
List Tables
SELECT * FROM pg_catalog.pg_tables
List tables schema
SELECT column_name, data_type, character_maximum_length
WHERE table_name = '';
Initial Source : Git Link source

jeudi 17 mai 2018

Convert SVN to Git

- Get repositotry Commiters
svn log -q https://yourRepoUrl | awk -F '|' '/^r/ {sub("^ ", "", $2); sub(" $", "", $2); print $2" = "$2" <"$2">"}' | sort -u > authors-transform.txt
- Checkout / Convert To Git
git svn --authors-file=authors-transform.txt clone https://yourRepoUrl   --trunk=trunk --branches=branches --tags=tags
- List all branch
git branch -a
- Checkout the Branch Localy
git checkout remotes/origin/v2
git checkout master
-Create Local Branch From Remote Branch
git branch v2 remotes/origin/v2
-Push Publish on Github
git remote add origin https://user@gitRepos/theGitProject.git
git push -u origin master
git push --all
git push --tags

mardi 19 décembre 2017

Nice link with time function