Sometimes you need to add or remove ressources like CPUs or RAM to your databases to handle more or less concurrent operations. This is called scaling. Due to a migration from MySQL to Aurora in my company, I benchmarked vertical scaling delay on MySQL and Aurora and I will detail these results in this article….
Docker multi-stage build – Reduce the gap between developers environments & production
In many of the projects I have seen I have noticed a worrying difference between the production and development environments. It is crucial to minimise the difference between these environments to avoid unexpected bugs. For the past few years most companies have been using Docker containers in production. Most of the time I noticed that…
MySQL Load Testing with Sysbench
Sometimes you need to do a load test on MySQL Database to test Auto-Scaling for example. I found a very useful tool called Sysbench that I will present in this article. Install Sysbench Open your terminal and run : Prepare for Load Testing Create a “test” database and run sysbench prepare command : Run MySQL…
How to protect a website against DoS Attack using AWS WAF v2
Denial of Service attacks are commons in these times. In my company we receive from time to time such an attack. For example on September 26th someone did almost one million requests in 1 hour on our servers and it was blocked by our AWS Web Application Firewall (WAF v2) : I will detail in this…
Replicate AWS RDS Aurora to AWS RDS MySQL
AWS encourages you to migrate from RDS MySQL to RDS Aurora by offering convenient features such as the ability to create an Aurora Read Replica from an RDS MySQL cluster and then promote it to Master. An almost downtime-free migration ! But how to do the same thing in the other way ? How to replicate…