Yannick Pereira-Reis

DevOps (docker swarm, haproxy, CI/CD, ELK, prometheus, grafana, ansible, automation, RabbitMQ, LVM, MySQL replication...) and fullstack web developer Symfony 2/3/4/5 + VueJs in Valence (France).

All Posts about DevOps, Symfony and VueJs development

2020

Definitive guide on how to setup up and running cron jobs in docker containers

Running cron jobs in docker containers will lead you to some very common problems, and sometimes without any errors or logs. Let's see all the steps to prope...

How to join Prometheus metrics by label with PromQL

When aggregating metrics from many sources or exporters in a Prometheus database, we often need to JOIN metrics on labels.

How to reduce Nginx 502 bad gateway errors and risks with dynamic domain name resolution for proxy_pass and fastcgi_pass

When deploying a projet it's a very common case to have 502 Bad gateway error as PHP-FPM is restarting while Nginx is still up and running. But we can avoid ...

2019

Why you should split your env file with docker-compose and docker swarm stack and services

Factor number 3 of twelve-factor app methodology recommands to store configuration that varies between deployments into environment. With some frameworks, do...

Docker and php-fpm truncated logs workaround and configuration for php 7.0, 7.1, 7.2 and 7.3

This is a problem when you want to run PHP-FPM in a docker container with php 7.0,7.1 and 7.2. It's common pratice for docker containers to write any log out...

Get real client IP address in NGINX behind HAPROXY reverse proxy

It's often really useful to get and store real user ip address of users browsing your website. Let's see how to do it with Nginx behind haproxy reverse proxy.

Doing a (301) redirect with HAPROXY without cache

You are on the good page if you want to know how to do a redirect without cache with haproxy

2018

How to delete data in MYSQL with DELETE, GROUP BY and HAVING clauses

With MySQL, DELETE operations are not always easy (join, sub queries,...), let's see how to DELETE with GROUP BY and HAVING constraints with a single command.

2017

VueJS - Two way data binding and state management with Vuex and strict mode

Two way data binding is really easy with VueJS and has very good performance with virtual dom. But it's not always a best practice to use to improve performa...

RabbitMQ high available cluster with docker and HAProxy

A docker stack to simulate a RabbitMQ cluster with high availability. HAProxy for load balancing, multi nodes, nodes failure, network partition,...

PHP fpm and cli error log configuration

Logging errors is something essential. Let's see how to do it with php-fpm (and cli)

Get user real ip in nginx behind nginx reverse proxy

Behind a reverse proxy, the user IP we get is often the reverse proxy IP itself. But for obvious reasons it's important to have access to the user real ip ad...

Nginx redirect http to https and non www to www

For SEO and security reasons it's important to set SSL/HTTPS on web servers and websites. It's important to avoid duplicate content for www and non www urls....

2016

How to write a good docker entry point for docker images and containers

A docker image entry point not following this simple rule will not be correct...

Local, remote and dynamic port forwarding with SSH tunnels

It can be really useful to use ssh tunnels and local port forwarding to access servers, databases or more generally services running on remote LAN. With Remo...

Use docker-machine with generic driver and devicemapper storage driver

A list of things to do or check to configure docker-machine (generic driver, devicemapper storage-driver) to control remote docker daemons.

Doctrine performance tip with MySQL and indexes, parameters type hinting

If we do not write DQL queries correctly, we could have big performance problems.

MySQL INSERT IGNORE alternatives

INSERT IGNORE INTO or REPLACE INTO MySQL operations are not really good practices. I advise you to replace with something else to INSERT if not exists.

Symfony client for an API secured with LexikJWTAuthenticationBundle, user authenticator and user provider

A simple example of a Symfony client (firewall, user authenticator, user provider, user model) configured to consumed an API protected with JWT token and Lex...

How to encapsulate your doctrine operations into transaction really easily

When doing multiple database operations in a single http request, command line, method,...we often need to use a database transaction to keep data safe.

Access environment variables from crontab into a docker container

How to use docker environment variables from a crontab running inside a docker container.

Doctrine automatic table prefix

Always prefix your tables with a prefix to avoid naming conflicts. You can do this automatically with doctrine.

Docker image size optimization

How to optimize docker image size with simple tricks. Caching layers, minimal base image like alpine or busybox, low number of layers, removing useless files...

Symfony 3 upgrade fixer and deprecation detector

To upgrade a Symfony project to Symfony 3, some people built different tools to help us

Composer, Satis and docker

Thanks to Composer, Satis, satisfy and docker it's really easy to host and use private git repositories

Symfony dynamic services with environments or expression language

How to create and inject services dynamically with Symfony and expression language based on environment or env variables