Amazon RDS is a very popular choice for creating MySQL databases in the cloud. Many modern companies use it to store their business data. However, as with any other database, securing these databases requires special attention to protect against potential threats and vulnerabilities. In this article, we will explore 10 best practices for securing your…
Category: Database
Aurora vs MySQL vertical scaling benchmark on AWS RDS
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….
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…
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…