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.

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

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 2 – Master-Slave replication, and Redis Sentinel0… »

Loading

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

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: Redis: replication, part 1 – an overview. Replication vs Sharding.… »

Loading

TestRail: QA Test Case Management installation on Linux
0 (0)

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: TestRail: QA Test Case Management installation on Linux0 (0) »

Loading

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

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: NextCloud: installing server on Debian behind NGINX with PHP-FPM and… »

Loading

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

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: AWS: RDS logs, export to the CloudWatch Logs and CloudFormation… »

Loading

MySQL/MariaDB: most used commands with examples
0 (0)

3 March 2019

Please note – this is absolutely not a complete guide about all MySQL commands usage – but just examples of the most commonly used ones. mysql> at the begin of the line means it’s executed from the MySQL console. Symbols # or $ means it’s executed from the Linux shell. UPD 03.03.2019 This post originally… Read More: MySQL/MariaDB: most used commands with examples0 (0) »

Loading