Databases

How To Manage Replicas and Clients in Redis — step-by-step Linux tutorial on Progressive Robot

How To Manage Replicas and Clients in Redis

One Redis’s most sought-after features is its support for replication: any Redis server can replicate its data to any number of replicas, allowing for high read scalability and strong data redundancy. Additionally, Redis was designed to allow many clients (up to 10000, by default) to connect and interact with data, making it a good choice for cases where many users need access to the same dataset. This tutorial goes over the commands used to manage Redis clients and replicas.

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
How To Install and Use PostgreSQL on Rocky Linux 9 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on Rocky Linux 9

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
How To Install MariaDB on Rocky Linux 9 — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB on Rocky Linux 9

MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement for MySQL. This tutorial will explain how to install MariaDB on a Rocky Linux 9 server, and verify that it is running and has a safe initial configuration.

Read more
How To Install MySQL on Rocky Linux 9 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on Rocky Linux 9

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL on a Rocky Linux 9 server.

Read more
Cara Menginstal MongoDB pada Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

Cara Menginstal MongoDB pada Ubuntu 20.04

MongoDB adalah basis data dokumen sumber terbuka yang banyak digunakan dalam aplikasi web modern. MongoDB digolongkan sebagai basis data NoSQL karena tidak bergantung pada struktur basis data relasional berbasis tabel tradisional. Alih-alih, MongoDB menggunakan dokumen seperti JSON dengan skema dinamis. Dalam tutorial ini, Anda akan menginstal MongoDB pada server Ubuntu 20.04, mengujinya, dan mempelajari cara mengelolanya sebagai layanan systemd.

Read more
CHAT