Tag Archives: AWS RDS

Kubernetes: load-testing and high-load tuning – problems and solutions

4 September 2020
 

 Actually, this post was planned as a short note about using NodeAffinity for Kubernetes Pod: But then, as often happens, after starting writing about one thing, I faced another, and then another one, and as a result – I made this long-read post about Kubernetes load-testing. So, I’ve started about NodeAffinity, but then wondered how… Read More »

AWS: RDS Certificate Authority SSL certificate upgrade

22 November 2019
 

 We started receiving emails from AWS with notifications to update RDS Certificate Authority certificates. It’s time to do it, so let’s start from our Dev, then will repeat on Staging and Production environments. W eare using common AWS RDS MariaDB instances, and the upgrade documentation is available here>>>. The process itself is really simple and… Read More »

AWS RDS: “SQLSTATE[22001] – Data too long for column” using MariaDB 10.2

8 August 2019
 

 We have a PHP-application with the AWS RDS MariaDB as a backend. On the previously used 10.0 version all was good, but right after we upgraded to the MariaDB 10.2 – got errors during tests: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘name’ at row 1 in /data/projects/projectname/vendor/yiisoft/yii2/db/Command.php:1290 The first… Read More »

AWS: MariaDB RDS – kill: You are not owner of thread

14 May 2019
 

 We have AWS RDS with MariaDB. The error below and its solution aren’t specific to AWS RDS and MariaDB. The next error appears during attempt to kill() a thread in MySQL: The solution is to use the mysql.rds_kill() procedure instead: Execute it: For Azure MySQL, there is a similar procedure mysql.az_kill(). Done.

AWS: RDS logs, export to the CloudWatch Logs and CloudFormation template

7 March 2019
 

 We have a bunch of the AWS RDS with MariaDB. Backend-developers asked me to enable slow requests logs so they can debug their application. So the task is: enable AWS RDS logging and configure export to the CloudWatch Logs for further analysis. As everything else – our RDS instances are configured via CloudFormation templates, so… Read More »