🚀 Day 9 of #100DaysOfDevOps – MariaDB Troubleshooting 🐬💥 Today’s challenge was a critical one — the Nautilus application in Stratos DC couldn’t connect to the database. After investigation, the issue turned out to be that the MariaDB service was down on the database server. 🔍 I approached it methodically: SSH’d into the DB server and confirmed that mariadb was inactive. Checked the logs via: journalctl -xeu mariadb Identified that the root cause was either: Missing or misconfigured data directory (/var/lib/mysql) Or permission issues with /run/mariadb 🔧 Solution: Recreated the missing mysql data directory Set correct permissions: chown mysql:mysql /run/mariadb systemctl restart mariadb Check the result with: mysql -u root ✅ Result: MariaDB is back online, and the application can connect again smoothly. 📘 This was a great hands-on exercise in real-world database recovery and service troubleshooting — skills every DevOps engineer must have! #DevOps #MariaDB #Linux #SystemAdministration #Troubleshooting #KodeKloud #100DaysOfDevOps #LearningByDoing #DatabaseRecovery
MariaDB Troubleshooting: A Hands-On DevOps Challenge
This title was summarized by AI from the post below.
More Relevant Posts
-
🚀 Dive into PostgreSQL 18: Leveling Up Performance, Security & Developer Experience! PostgreSQL 18 is here—and it's loaded with performance, security, and developer-friendly upgrades. Discover what's new: -- A brand-new asynchronous I/O subsystem that delivers 2–3× faster reads and reduced latency via io_method, including io_uring support on Linux. -- Smarter upgrades with pg_upgrade enhancements—keep planner stats, and upgrade faster and safer. -- Developer-first tools: virtual generated columns, enhanced RETURNING support, and native uuidv7() for timestamp-ordered identifiers. -- Security and ops upgrades: OAuth 2.0 auth, stronger encryption, default data checksums, and better observability. Head to the pgEdge blog to get the full breakdown and understand why PostgreSQL 18 is a must-upgrade for modern workloads. 👉 Read now: https://hubs.la/Q03M3-fW0 #PostgreSQL #Postgres18 #DatabasePerformance #DeveloperTools #CyberSecurity #pgEdge #OpenSource #PostgreSQLProfessionals Ahsan Hadi
-
-
🚨 Seeing the error “The MySQL service could not be started”? This issue often pops up after changing the datadir location, and Windows won’t tell you why. Our latest blog walks you through step-by-step troubleshooting to get MySQL running smoothly again. 👉 Read the guide: https://bit.ly/3K2WOTT #MySQL #DatabaseSupport #Troubleshooting #DBA #DatabaseManagement
-
-
🚀 Excited to share my recent hands-on work with PostgreSQL High Availability! I successfully deployed a PostgreSQL HA cluster using Patroni on CentOS 9. 🔹 Cluster Topology 1 Primary Node 2 Replica Nodes Automated failover & switchover powered by Patroni + DCS Synchronous standby replication ensuring zero data loss with real-time streaming 🔹 Key Highlights Built from scratch: OS-level users, permissions, PostgreSQL setup & Patroni configuration Verified both synchronous & asynchronous replication modes Performed manual switchover with smooth role transitions Validated replication health with 0 MB lag across replicas Ensured readiness for automatic failover during primary node failure 🔹 HAProxy Integration Implemented HAProxy as a single entry point & load balancer Directed all write traffic to the active primary Seamlessly distributed read queries across replicas 🔹 Software Stack Used Patroni – HA cluster management HAProxy – Load balancing & traffic routing Keepalived – VIP management & failover etcd – Distributed configuration store (DCS) Watchdog – Node health monitoring I will be sharing some of the most important PostgreSQL topics such as PgBackRest, Barman, PgBadger, PgBouncer, Patroni, Streaming Replication, Partitioning, and PostGIS. Stay tuned as I dive into real-world use cases, best practices, and hands-on configurations to help strengthen PostgreSQL knowledge. ##PostgreSQL ##PatRoNi ##HighAvailability ##HAPorxy ##DataBase #Administration ##OpenSource #NoSQL_MongoDB
-
-
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to set up the pgAdmin development environment on your machine. T... https://lnkd.in/edP65ysf
-
DocumentDB Gains Linux Foundation Backing, Relational Meets NoSQL Trend: Linux Foundation now supports DocumentDB, a Postgres-based document database with BSON/document API compatibility. Why it matters: Could shift the balance in database choice and interoperability for developers and companies. Question: Will DocumentDB win over use cases currently dominated by MongoDB or other NoSQL tools? Why or why not? 🔁 Repost if you think hybrid DBs are the future 🔔 Follow me for database trends and what to pick when 🌟 Takeaway: Blended SQL/NoSQL functionality is gaining legitimacy
-
-
The latest InfoWorld article by Tom Kincaid, SVP of Database Servers & Tools at EDB and a long-time PostgreSQL contributor, looks at what makes PostgreSQL 18 stand out and where the project is heading next. Tom highlights the momentum behind the release—110 unique contributors delivering more than 200 new features—and explains how that growing community keeps Postgres advancing year after year. He also shares why the improvements in performance, security, and flexibility matter for teams building modern data platforms and AI applications. Read his feature here: https://lnkd.in/ek-tf3u9 #PostgreSQL18 #EDBPostgresAI #PG18 #PGCommunity #OpenSource
-
Did you know MySQL 8.4 is now generally available in Azure Database for MySQL? Two things stand out: ✅ Improved replication management – Get finer control over what data gets replicated, plus better failover behavior for high availability. ✅ Enterprise-ready support – 8.4 follows the same patching and maintenance policies as MySQL 8.0, with automated updates and customizable maintenance windows. We’re excited to support this next step in MySQL’s evolution—and we’d love to hear how you’re putting it to work. More details in the blog: https://lnkd.in/eKC-tiCf
-
-
How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS. What is ClusterControl? ClusterControl is a robust #database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. Prerequisites Before starting the installation, ensure the following: Root or sudo access to your AlmaLinux VPS. ... Keep Reading 👉 https://lnkd.in/gYCsii96 #installguide #mysql #databasecluster
-
How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS. What is ClusterControl? ClusterControl is a robust #database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. Prerequisites Before starting the installation, ensure the following: Root or sudo access to your AlmaLinux VPS. ... Keep Reading 👉 https://lnkd.in/gTF5bw73 #databasecluster #mysql #installguide
Solid debugging steps 💯 — love how you broke it down from logs → permissions → restart. This kind of structured troubleshooting is gold in production!