Category Archives: Databases

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
A relational database management system is a database management system based on the relational model of data.

MySQL/MariaDB: like Petya ransomware for MySQL and ‘root’@’%’ access

3 April 2019

This story happened on 10/06/2017, adding this post in English now. The original post (Rus) was written almost right after the well-known Not a Petya attack in Ukraine – that’s why it’s used in the title. I had a new project assigned to me. When I started its existing setup investigation – was just shocked.… Read More »

Redis: replication, part 3 – redis-py and work with Redis Sentinel from Python

1 April 2019

Still on the subject about Redis replication and Redis Sentinel – a couple of examples using the redis-py library for Python. Previous series posts: Redis: replication, part 1 – an overview. Replication vs Sharding. Sentinel vs Cluster. Redis topology Redis: replication, part 2 – Master-Slave replication, and Redis Sentinel All Redis clients for Python can be… Read More »

Redis: replication, part 2 – Master-Slave replication, and Redis Sentinel

29 March 2019

The first part – Redis: replication, part 1 – overview. Replication vs Sharding. Sentinel vs Cluster. Redis topology. The next part – Redis: replication, part 3 redis-py and work with Redis Sentinel from Python. The whole story was started when we decided to get rid of memcached. Currently, we have memcahced and Redis running on… Read More »

Redis: replication, part 1 – an overview. Replication vs Sharding. Sentinel vs Cluster. Redis topology.

29 March 2019

CodeProject Initially, it was planned to write one small post with an example how to create a Redis replication but as I read more and more details – I wanted to describe more and more about it, so eventually I split this post into two parts. In this one – some quick overview, a brief… Read More »

TestRail: QA Test Case Management installation on Linux

22 March 2019

TestRail – Test Case Management Software for QA and Development Teams. Well – that’s all needed as a description) Below – its installation on Debian Linux with NGINX, Let’s Encrypt, PHP-FPM, MariaDB, and Exim. Project’s homepage – www.gurock.com/testrail Installation official documentation – here>>>. Setup will be on an AWS EC2. LEMP and SSL Login to… Read More »

NextCloud: installing server on Debian behind NGINX with PHP-FPM and client on Arch Linux

17 March 2019

After the news that Dropbox adds a new limitation for users by the three devices only – I’m finally ready to install my own NextCloud to store and synchronize data. The sad thing is not exactly the three devices limit (and it will be applied for a new users only – old user who already… Read More »

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 »