info@solusidb.com

Category: tutorial

Clear Systemd Journal Logs in Ubuntu 22.04

Clear Systemd Journal Logs in Ubuntu 22.04

systemd uses its own logging system called the journal. It’s a centralized logging system that collects logs from all parts...

Configurations in PostgreSQL for Heavy Read Workloads

Configurations in PostgreSQL for Heavy Read Workloads

Configuring PostgreSQL and the operating system for a heavy read workload involves optimizing various settings to improve performance, reduce latency,...

Configurations in PostgreSQL for Heavy Write Workloads

Configurations in PostgreSQL for Heavy Write Workloads

Optimizing PostgreSQL and the operating system for a heavy write workload involves careful tuning of both PostgreSQL settings and OS...

Calculating maximum connections in PostgreSQL

Calculating maximum connections in PostgreSQL

Calculating the maximum number of connections for a PostgreSQL server involves considering both the available RAM and CPU. Here’s a...

PostgreSQL – Logical Replication – Overview

PostgreSQL – Logical Replication – Overview

Pada PostgreSQL memiliki fitur replikasi, yang bertujuan untuk menjaga availability data yang kita miliki, meminimalisir resiko terjadinya kehilangan data yang...

Swiss Army knife for managing  PostgreSQL

Swiss Army knife for managing PostgreSQL

The following are some commands commonly used by DBAs as tools for checking PostgreSQL databases Uptime service PostgreSQL SELECT (now()...

Upgrade MySQL-5.7 to MariaDB-10.2 Galera

Upgrade MySQL-5.7 to MariaDB-10.2 Galera

Scenario Existing server -DB: MySQL-5.7 Master-slave, DB size: 140GB New Server – DB = MariaDB-10.2 (Galera Cluster) Following are the...

Setup Maxscale HA using Keepalived and Maxctrl

Setup Maxscale HA using Keepalived and Maxctrl

MariaDB MaxScale is a database proxy which does load balancing and query routing from client applications to backend database servers....