PostgreSQL High Availability: Active/Active Replication Explained

postgresql active/active, postgres active active, postgresql ha

Postgres High Availability: Setup Active/Active Replication Active/active replication is an advanced setup for PostgreSQL databases that helps achieve high availability and load balancing. It involves the use of the Bi-Directional Replication (BDR) plugin. Here are step-by-step instructions on setting this up. Step 1: Prepare Your PostgreSQL Servers Firstly, you will need at least two servers … Read more

PostgreSQL By Example: Show Tables with PSQL

postgres show table, psql show table, postgres list tables

Navigating your PostgreSQL database requires a keen understanding of its structure, including how to show tables using the command line interface, psql. In this guide, we’ll walk you through this crucial task, demonstrating how to easily and efficiently display and understand your database tables. Whether you’re a beginner or experienced user, mastering this skill is … Read more

PostgreSQL Vacuum Analyze: Improve Query Performance in 3 Steps

postgresql vacuum, postgres vacuum

What is the Purpose of PostgreSQL Vacuum? As you navigate the intricate world of PostgreSQL, understanding the “vacuum” process is vital. Essentially, the vacuuming procedure plays a crucial role in maintaining the health of your PostgreSQL database. Its primary function? To recover space that’s no longer in use by the database but still occupied due … Read more

How to Restart SSH in Solaris 10/11

restart ssh solaris, restart sshd

Today, let’s delve into how to initiate the SSHD service in both Solaris 10 and Solaris 11, two widely utilized versions of the Solaris Operating System. With the right steps, you’ll be able to restart SSH service in Solaris easily. Lets jump right in… Step 1: Ensure Installation Before we can restart SSH service, we … Read more

PostgreSQL Write Ahead Log (WAL) Explained

postgres wal, postgresql wal, write ahead log

Write Ahead Logging (WAL) is a pivotal component of PostgreSQL. The principle of WAL is straightforward yet profound: every action that modifies the database content is recorded into a log before it’s applied to the database. This action-first, record-later methodology improves the durability and consistency of the database by providing an audit trail, which becomes … Read more

PostgreSQL:Physical vs Logical Replication (w/ TL;DR)

postgresql replication, logical, streaming, physical, logical vs streaming

Replication—the act of duplicating data across multiple database servers— is a cornerstone feature in PostgreSQL. It facilitates high availability, enhances read scalability, and provides a means for data distribution. PostgreSQL mainly supports two replication types: physical and logical replication. Let’s dive deeper into the world of PostgreSQL replication and unravel the difference between these replication … Read more

Setup a MariaDB Galera Cluster on Ubuntu: Step-by-step Guide

mariadb, mysql, clustering, cluster

In this tutorial, we will show you how to setup a MariaDB Clustering using Galera on Ubuntu. In addition to these easy install instructions, we’ll explain what is MariaDB clustering, how does cluster work, and how to enable clustering in MariaDB on Ubuntu. MariaDB is a popular open-source database management system that offers high performance, … Read more

5 Ways to Pass Command-Line Parameters to a Linux Shell Script

bash arguments, pass parameter, pass argument to script

Command-line parameters are an efficient way to control the behavior of your shell scripts. They can make your scripts more dynamic, easier to use, and more powerful. In this blog post, we will delve into five ways you can pass command-line parameters to a Linux shell script. First, a little about various Linux Shells… Linux … Read more

How to Enable PostgreSQL Performance Logging

postgresql reset statistics, pg_stat_reset

Performance monitoring and optimization are crucial aspects of managing a PostgreSQL database effectively. One powerful tool in your arsenal is performance logging, which allows you to collect detailed information about the database’s internal processes and query execution. In this blog post, we will explore the steps to enable performance logging for PostgreSQL, providing you with … Read more

How to Start PostgreSQL Automatically on Ubuntu Boot

postgresql reset statistics, pg_stat_reset

We will guide you through the steps to set up PostgreSQL to start automatically on Ubuntu boot. PostgreSQL is a popular open-source relational database management system used by many developers and organizations worldwide. In Ubuntu, you can configure PostgreSQL to start automatically upon system boot, ensuring that your database server is always up and running. … Read more

How to Enable Replication for PostgreSQL on Ubuntu

data replication, postgres replication, postgresql replication

PostgreSQL replication is a method of copying and maintaining database objects, such as schemas and tables, in multiple database systems distributed across different locations. This article will guide you through the steps to set up and enable data replication for PostgreSQL on Ubuntu. Types of PostgreSQL Data Replication PostgreSQL data replication refers to the process … Read more

Understanding Java Memory Leaks and 4 Free Tools For Detection

java memory leak

This article will explain what is a Java memory leak and suggest tools for detection. Memory leaks can cause a Java program to run slowly or crash altogether. Detecting memory leaks in Java can be a challenging task, especially if you don’t have the right tools and techniques at your disposal. In this blog post, … Read more

RPM Installation Dependencies – Explained

rpm dependencies, linux, ubuntu

You will learn how to manage dependencies during RPM installation on Linux servers such as CentOS, RHEL, Fedora, and Ubuntu. We’ll provide step-by-step instructions on how to properly handle dependency issues and solve common issues. Whether you build your own RPM or use third-party, we’ll cover it in this guide. About RPM and Dependencies Each … Read more

Build an RPM in CentOS, RHEL and Ubuntu Linux

build rpm linux, build rpm ubuntu

Discover how to build RPM packages on Ubuntu, CentOS, Fedora, and Red Hat. Follow our step-by-step guide to mastering RPM creation easily. RPM Package Manager, commonly known as RPM, is a versatile open-source package management tool that provides a simple way to build, install, verify, update, and uninstall software packages. This article guides you through … Read more

Explained: Cassandra Compaction Strategies

cassandra compaction strategies, compaction strategy

We’ll explain all about Cassandra compaction, compaction strategies, and how to choose the best for your use-case. We’ll explain everything you need to know in this post. Apache Cassandra, a highly scalable and high-performance distributed database, owes much of its flexibility and efficiency to its compaction process. Compaction is a core element in the Cassandra … Read more

Cassandra Data Model by Example: A Comprehensive Guide

cassandra, data model, data modeling

Building a performance optimized data model in Cassandra may seem overwhelming. However, following a few simple best practices when initially designing your schema will help reduce refactoring nightmares down the road. Let’s jump right in… Cassandra Data Modeling Best Practices 1. Create a table for each query pattern Designing a table for each query pattern … Read more

10 Ways To Improve Cassandra Read Performance: Ultimate Guide

cassandra compaction, compaction strategies, compaction strategy

We discuss 10 ways to improve Cassandra read performance and reduce latency. But first, we’ll discuss read vs write performance, and what is the expected read latency. Cassandra performance tuning can be daunting, but hopefully this article will get you comfortable with some of the terminology. Apache Cassandra is a distributed NoSQL database that is … Read more

Understanding PostgreSQL Reset Statistics with pg_stat_reset

PostgreSQL Reset Statistics with pg_stat_reset

This article will explore focus on how to PostgreSQL reset statistics using the pg_stat_reset command. We will discuss what this command does, when and why to use it, and the impact it has on your PostgreSQL database. Efficiency is important, so check out this article on how to reload config using pg_ctl without restarting the … Read more

PostgreSQL Essentials: Reload pg_hba.conf

postgresql reset statistics, pg_stat_reset

This file controls client authentication, and its modifications won’t take effect until you reload pg_hba.conf. In this comprehensive guide, we’ll answer the top ten questions about reloading the pg_hba.conf file. What is the command to reload the pg_hba.conf file in PostgreSQL? The command to reload pg_hba.conf file in PostgreSQL is fairly simple. Use the following … Read more

How to Append Files in Linux: A Comprehensive Guide

how to append files in linux

If you are a Linux user, understanding how to append files in Linux is an essential skill that will undoubtedly prove useful in various scenarios. The term ‘append’ in computing means to add or attach something at the end. In Linux, it specifically refers to adding data to the end of a file. This article … Read more

Cassandra Tombstones Performance Impact & Tips to Avoid

cassandra tombstones

In this post, we will explore what tombstones are, why they can negatively affect Cassandra performance, and how to avoid them. Apache Cassandra is a highly scalable and distributed NoSQL database that uses a unique data model designed to handle large amounts of data across many commodity servers, with high availability and fault tolerance. However, … Read more

PHP

Creating a Continuous Integration Pipeline for Laravel with Jenkins

laravel php

This article will get you started on creating a Laravel CI/CD pipeline in Jenkins. There are tremendous productivity gains to implement CI/CD in Laravel. In case you missed it, be sure to read our post on setting up Laravel project in MacOS Docker. Step 1: Install Jenkins Before we can start building Laravel projects in … Read more

Add a Code Coverage Build Gate in SonarQube for Java Projects

java, software, software development

In software development, code coverage refers to the percentage of code that is covered by automated tests. Code coverage is a critical metric for determining the effectiveness of your testing strategy. SonarQube is a popular open-source platform for continuous code quality inspection that can help you keep track of your code coverage. In this blog … Read more

Java HashMap vs HashTables – Explained

hashtable vs hashmap performance

Hash tables are a fundamental data structure used in computer science to implement dictionaries, associative arrays, and sets. In Java, the two most commonly used hash table implementations are the HashMap and HashTable classes. Both classes provide similar functionality, but they differ in their performance characteristics, thread-safety, and feature set In this blog post, we … Read more