Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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…
Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their experiences and skills with us. For 7 years now, data fanatics have been meeting in Poland once a year to share their knowledge with…
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…
Here’s a short post about a conference I’m attending right now. SQLDay is one of the biggest events in Europe dedicated to the Microsoft data platform, including databases, Big Data and Business Intelligence solutions, and advanced data analytics. The conference is organized by the Data Community Poland association.Sessions from previous years are available on their YouTube channel. I have the…
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…
The Average case As a skilled developer, you are well-versed in the latest trends and fully capable of building an application from scratch. From the frontend to the RESTful API backend, through to the ORM and the database, you have experienced it all.Having participated in numerous projects and developed substantial code, you have begun to receive feedback from your Sysadmins…
Recently the openSUSE project announced the Alpha release of Leap Micro 6.0. This version of the openSUSE operating system is optimized for container workloads and edge computing. One of the cool features of this version of the OS is, that the root file system is read only. Updates to the operating system are atomic / transactional, which means the Btrfs…
This is the third post in this little series about bcachefs. The first post was all about the basics while the second post introduced bcachefs over multiple devices. What we did not discuss so far is, what bcache has to offer when it comes to mirroring. By default bcachefs stripes your data across all the devices in the file systems.…
In the last post, we’ve looked at the very basics when it comes to bcachefs, a new file system which was added to the Linux kernel starting from version 6.7. While we’ve already seen how easy it is to create a new file system using a single device, encrypt and/or compress it and that check summing of meta data and…
When Linux 6.7 (already end of life) was released some time ago another file system made it into the kernel: bcachefs. This is another copy on write file system like ZFS or Btrfs. The goal of this post is not to compare those in regards to features and performance, but just to give you the necessary bits to get started…
