Databases

How To Manage Lists in Redis — step-by-step Linux tutorial on Progressive Robot

How To Manage Lists in Redis

In Redis, a list is a collection of strings sorted by the order in which they were inserted unless otherwise specified, similar to linked lists. This tutorial details how to create lists and retrieve and delete elements from lists.

Read more
How To Migrate a MySQL Database to PostgreSQL Using pgLoader — step-by-step Linux tutorial on Progressive Robot

How To Migrate a MySQL Database to PostgreSQL Using pgLoader

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.

Read more
How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04

ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database to create a caching layer to optimize MySQL queries. In this tutorial, you will use ProxySQL to set up transparent caching for a MySQL server on Ubuntu 16.04. You will then test its performance using mysqlslap with and without caching to demonstrate the effect of caching and how much time it can save when executing many similar queries.

Read more
Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04

Django — это мощная веб-система, помогающая создать приложение или сайт Python с нуля. Django включает упрощенный сервер разработки для локального тестирования кода, однако для серьезных производственных задач требуется более защищенный и мощный веб-сервер. В этом руководстве…

Read more
How To Use Aggregations in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Use Aggregations in MongoDB

MongoDB provides aggregation operations through aggregation pipelines — a sequential series of data processing operations through which the documents go to obtain the final result. In this tutorial, you’ll learn by example how to use the most common features of the aggregation pipelines.

Read more
How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04

ProxySQL is an open-source MySQL proxy server which can improve performance by distributing traffic among a pool of multiple database servers and also improve availability by automatically failing over to a standby if a database server fails. In this guide, you will set up ProxySQL as a load balancer for multiple MySQL servers with automatic failover.

Read more
CHAT