Blog et Aide mémoire informatique

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

sample:

=SUBTOTAL(109;G2:G2054)

https://www.excelcse.com/excel-subtotal-function/

du -sh /* 

control-r

Run task in Background

nohup command

Inotify

https://manpages.ubuntu.com/manpages/bionic/man1/inotifywait.1.html

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

Lire la suite

Some configuration to tune

Lire la suite

Quick Tips AWS athena

Lire la suite

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

https://www.netadmintools.com/art295.html
https://medium.com/@muhammadtriwibowo/set-permanently-ulimit-n-open-files-in-ubuntu-4d61064429a
https://app.getpocket.com/read/2383097919

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

https://www.daveeddy.com/2017/10/18/persistent-sshagent-on-bash-on-ubuntu-on-windows/ https://medium.com/@crishantha/handing-bastion-hosts-on-aws-via-ssh-agent-forwarding-f1d2d4e8622a

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. https://qbox.io/blog/split-brain-problem-elasticsearch

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 : https://www.cyberciti.biz/faq/linux-unix-dd-command-show-progress-while-coping/

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.

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

Lire la suite

Start the Docker

docker run --rm   --name pg-docker 
-e POSTGRES_PASSWORD=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
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '';

Initial Source : Git Link source

- 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

https://wiki.archlinux.org/index.php/time