The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue …
Read More »How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04
The author selected the Free Software Foundation to receive a donation as part of the Write for DOnations program. Introduction ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database. It offers many features, such as load-balancing between multiple MySQL servers and serving as …
Read More »How To Install and Use PostgreSQL on CentOS 7
Introduction Relational database management systems are a key component of many web sites and applications. They provide a structured way to store, organize, and access information. PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for …
Read More »How To Manage and Use MySQL Database Triggers on Ubuntu 18.04
The author selected the the Apache Software Foundation to receive a donation as part of the Write for DOnations program. Introduction In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and …
Read More »How To Install and Use ClickHouse on Debian 10
The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Introduction ClickHouse is an open-source, column-oriented analytics database created by Yandex for OLAP and big data use cases. ClickHouse’s support for real-time query processing makes it suitable for applications …
Read More »How To Install and Use TimescaleDB on Ubuntu 18.04
The author selected the Computer History Museum to receive a donation as part of the Write for DOnations program. Introduction Many applications, such as monitoring systems and data collection systems, accumulate data for further analysis. These analyses often look at the way a piece of data or a system changes …
Read More »How To Manage Sorted Sets in Redis
Introduction Redis is an open-source, in-memory key-value data store. In Redis, sorted sets are a data type similar to sets in that both are non repeating groups of strings. The difference is that each member of a sorted set is associated with a score, allowing them to be sorted from …
Read More »How To Add Sidekiq and Redis to a Ruby on Rails Application
Introduction When developing a Ruby on Rails application, you may find you have application tasks that should be performed asynchronously. Processing data, sending batch emails, or interacting with external APIs are all examples of work that can be done asynchronously with background jobs. Using background jobs can improve your application’s …
Read More »How To Migrate Redis Data to a DigitalOcean Managed Database
Introduction There are a number of methods you can use to migrate data from one Redis instance to another, such as replication or snapshotting. However, migrations can get more complicated when you’re moving data to a Redis instance managed by a cloud provider, as managed databases often limit how much …
Read More »How To Change Redis’s Configuration from the Command Line
Introduction Redis is an open-source, in-memory key-value data store. Redis has several commands that allow you to make changes to the Redis server’s configuration settings on the fly. This tutorial will go over some of these commands, and also explain how to make these configuration changes permanent. How To Use …
Read More »