Joan Frey has more than three years of experience in the IT sector, specializing in C and C# development, with additional knowledge of Linux and SQL. Prior to dbi services, he was an Analyst Developer Intern at Euro Information Développement in Strasbourg and an IT Help Desk intern at EuroAirport. He holds a computer engineering degree specializing in information systems from the University of Technology of Belfort-Montbéliard (UTBM). His industry experience includes banking and aviation.
Introduction This blog is a follow-up to my previous post: MariaDB Repair Replication through DB Restore. A client recently experienced a crash on the database slave in their MariaDB cluster within their QA environment. I successfully restored the database using the procedure detailed in the earlier blog. However, a few weeks later, the database slave crashed again, this time in…
In today’s data-driven world, monitoring and visualizing the health and performance of your database clusters is a must. With tools like Prometheus and Grafana, you can gain valuable insights into your PostgreSQL Patroni setup, ensuring its smooth operation and proactive maintenance. In this guide, we’ll walk you through the steps of installing and configuring Prometheus and Grafana to monitor your…
Introduction Maintaining database replication integrity is paramount for businesses relying on databases. Replication ensures that changes made on the master database are reliably propagated to replica databases, guaranteeing data consistency and availability across the system. In this comprehensive guide, we’ll dive into the process of restoring a MariaDB database and repairing replication, in the context of a “last hope” solution.These…
If you’re encountering the etcd error “etcdserver: mvcc: database space exceeded,” it means your etcd database has exceeded its storage limit. This can occur due to a variety of reasons, such as a large number of revisions or excessive data accumulation. However, there’s no need to panic; this issue can be resolved effectively. I know that there is already plenty…
In a distributed database system like PostgreSQL managed by Patroni, etcd plays a critical role as the distributed key-value store for cluster coordination and configuration. As your system evolves, upgrading etcd becomes necessary to leverage new features, bug fixes, and security enhancements. However, upgrading etcd in a live cluster requires careful planning and execution to ensure data integrity. In this…
1. Introduction In the world of PostgreSQL database management, ensuring robust backup strategies is mandatory. This week I discovered on postgresql.org latest news one useful tool that streamlines this process: pg_back. pg_back serves as a dedicated dumping tool designed for PostgreSQL. Its primary objective is to facilitate the comprehensive dumping of either all or specific databases, along with global entities,…
I am thrilled to share that I had the opportunity to attend the 13th Annual PostgreSQL Conference Europe in Prague which took place between the 12th and the 15th of December. It was my first participation at the PGConf.eu and even at any conference, and it was an enriching experience beyond expectations. My first surprise was the number of people…
PostgreSQL, an open-source relational database management system, offers robust features and capabilities for data storage and management. Deploying PostgreSQL within the Oracle Cloud Infrastructure (OCI) provides a scalable and reliable environment. In this guide, we’ll explore the process of setting up PostgreSQL in OCI. We will also push a bit more to learn how backup/restore and failover works. Let’s discover…
pgFormatter is a command-line tool used to format SQL code for PostgreSQL databases. It helps improve code readability and maintainability by applying consistent indentation and formatting rules to your SQL queries. This guide will walk you through the process of installing and using pgFormatter on a Linux system, specifically openSUSE. I. Installation For this guide, I will install pgFormatter using…
Managing databases is a crucial aspect for a DBA, and PostgreSQL is a powerful open-source relational database management system that is widely used. To interact with a PostgreSQL database, DBA and developers often rely on command-line tools. The default tool that is used is psql. What if I told you that you can simplify the interaction with your database with…
In the world of database management, high availability and data integrity are of most importance. Patroni, a robust open-source solution, offers a way to manage and maintain PostgreSQL high availability clusters seamlessly. However, even with tools like Patroni, you can face challenges. The setup: Patroni Cluster Installation I had the mission of setting up a Patroni cluster for a critical…
Welcome to this comprehensive guide on implementing persistent data in your Vue application using Pinia! If you’re already running a Vue application with Pinia, you’re in the right place. But if you’re not there yet, don’t worry – I’ve got you covered. Before we dive into the details, if you haven’t set up a Vue app with Pinia yet, make…
