Deploying MySQL on Kubernetes with Persistent Volumes and Secrets

Deploying Production-Ready, High-Performance MySQL on Kubernetes! Excited to share our architecture for a robust, scalable, and highly available MySQL setup leveraging the power of Kubernetes and KubeDB. Key components in this setup: KubeDB: Manages the entire MySQL Master-Slave replication lifecycle automatically. ProxySQL (HA with Keepalived/Virtual IP): Handles connection routing (read/write splitting) and improves performance with query caching for static content. Keepalived: Ensures seamless failover and High Availability for the ProxySQL layer using a Virtual IP. XtraBackup/Minicube (S3): Provides reliable and automated database backup and recovery. Grafana/Prometheus: Delivers real-time monitoring and observability via mysql-exporter. This architecture ensures zero downtime and optimal performance for demanding applications. #Kubernetes #KubeDB #MySQL #ProxySQL #HighAvailability #DevOps #SRE

Zero(ish)-Downtime PostgreSQL Upgrade   Recently completed a successful upgrade from PostgreSQL 11 → 15.13 using AWS RDS Blue/Green Deployment, achieving less than 2 minutes of downtime during the final cutover.   Here’s the high-level process we followed: 1️⃣ Schema Preparation – Removed deprecated OID columns (SET WITHOUT OIDS) and dropped old aggregates to ensure Postgres 15 compatibility. 2️⃣ Feature Flag – Temporarily disabled weblog inserts (via a feature flag) to prevent blocking on large tables during schema migration. 3️⃣ Blue/Green Deployment – Used AWS-managed replication to sync the upgraded “Green” DB with production “Blue.” 4️⃣ Cutover – Switched traffic to the upgraded DB (took <2 mins). 5️⃣ Validation & Monitoring – Verified transactions, cron jobs, and application connectivity post-upgrade. This approach allowed us to complete a major version upgrade without noticeable downtime and with no data loss.   Next stop → PostgreSQL 16 #PostgreSQL #AWSRDS #DatabaseUpgrade #BlueGreenDeployment #DevOps #ZeroDowntime

Continuing on my previous post on creating a SAAS which create instant postgres instances. What will be added features that you will like in the application?? #DB #Postgres #SQL #SQLServer #Database

Scaling Postgres 388 is released! In this episode, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? https://lnkd.in/eHXb6uwi #Postgres #PostgreSQL

Here is an article on 𝗦𝘁𝗿𝗲𝗮𝗺𝗶𝗻𝗴 𝗥𝗲𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗜𝗻𝘁𝗲𝗿𝗻𝗮𝗹𝘀 of #PostgreSQL authored by Avinash Vallarapu (Avi) Our experts spend a good amount of time on developing and deploying our tools like #HexaRocket, to simplify #database #migrations from #𝗢𝗿𝗮𝗰𝗹𝗲, #SQLServer #MySQL and #MariaDB to #𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟. During this time, we realized that a lot of users want to understand the internals of Streaming Replication, and thus Avi decided to published this article. 𝗦𝘁𝗿𝗲𝗮𝗺𝗶𝗻𝗴 𝗥𝗲𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 Streaming replication is undoubtedly the most robust and the stable replication technique, that is simple to configure and ultimately faster, compared to many database technologies. This replication technique is driven by few background processes that talk to each other, stream WAL records and synchronize them to data files. In this article, you should witness the internals of Streaming Replication and understand how it functions in details. If you are looking for a simple solution to migrate from Oracle or any Database to PostgreSQL, connect with us at 𝗰𝗼𝗻𝗻𝗲𝗰𝘁@𝗵𝗲𝘅𝗮𝗰𝗹𝘂𝘀𝘁𝗲𝗿.𝗮𝗶 and ask for a demo on #𝗛𝗲𝘅𝗮𝗥𝗼𝗰𝗸𝗲𝘁. Read the blog: https://lnkd.in/gdWPgPJ2 #postgresql #postgres #oracle #streamingreplication #highavailability #replication #hexarocket

Mydbops Live Webinar! What's New in PostgreSQL 18. PostgreSQL 18 introduces major performance and developer experience upgrades. From a new asynchronous I/O system to enhanced developer tools, this version focuses on improving speed, security, and how you get your work done. Download the presentation slides: https://lnkd.in/g2e46vbp #Mydbops #Postgresql18 #pgsql18 #webinar #database #upgredes #database #opensource #learning #Devops

📊 NEW BLOG ALERT | MongoDB Best PracticesMongoDB Schema Versioning and Validation Made SimpleStruggling with MongoDB's schema flexibility? Here's how to maintain data integrity without losing agility! 🎯Key Takeaways for DBAs: ✅ Schema Validation - Enforce structural consistency while keeping flexibility ✅ Version Control - Track and manage data evolution systematically ✅ Data Governance - Prevent corruption at the database layer ✅ Migration Strategies - Upgrade schemas without downtime What You'll Learn: → Implementing $jsonSchema validators effectively → Handling validation modes (strict vs. moderate) → Adding _schemaVersion fields for traceability → Managing backward compatibility during transitions → Real-world DBA workflows and best practices Why This Matters: MongoDB's flexibility is powerful — but without structured validation, it becomes chaos. Learn how to balance developer freedom with operational stability. 📖 Read the full guide: https://lnkd.in/g_ebJmC5 💬 Questions? Let's connect: 📞 +91-6385312716 | +91-8870076562 More Insights: www.genexdbs.com #MongoDB #DatabaseManagement #SchemaValidation #DBA #DataGovernance #GenexDBS #DatabaseAdministration #NoSQL #TechBlog

🚀 𝗗𝗮𝘆 𝟲𝟲 - 𝗗𝗲𝗽𝗹𝗼𝘆 𝗠𝘆𝗦𝗤𝗟 𝗼𝗻 𝗞𝘂𝗯𝗲𝗿𝗻𝗲𝘁𝗲𝘀 #KodeKloud #100DaysOfDevOps 𝗛𝗲𝗿𝗲’𝘀 𝘁𝗵𝗲 𝘁𝗮𝘀𝗸 👇 ✅ Created Persistent Volume & Persistent Volume Claim for data persistence ✅ Secured credentials using Kubernetes Secrets 🔐 ✅ Deployed a MySQL container using a Deployment manifest ✅ Exposed MySQL using a NodePort Service on port 30007 ✅ Verified everything with kubectl get pods, svc, pvc, pv 🔗 Github Link: https://lnkd.in/gUvh5Kcj 💡 𝗞𝗲𝘆 𝗧𝗮𝗸𝗲𝗮𝘄𝗮𝘆𝘀:  • Always store credentials securely in Secrets — never hardcode them.  • Persistent Volumes ensure data stays safe even if Pods restart.  • Kubernetes makes deploying databases predictable and repeatable. #DevOps #Kubernetes #MySQL #100DaysOfDevOps #KodeKloud #Containers #CloudNative

🚀 High Availability for PostgreSQL with FortiADC & Patroni 🚀 Ensuring database uptime is critical for modern applications. By integrating FortiADC with PostgreSQL managed by Patroni, we achieve true automatic failover and load balancing between database nodes. ✅ Key benefits: Automatic leader detection: FortiADC instantly identifies the Primary (Leader) node. Zero downtime failover: When the current Primary goes down, traffic is immediately redirected to the new Primary. Replica awareness: Read-only replicas can be monitored and excluded from write traffic automatically. Seamless HA: No manual intervention required, ensuring your applications remain available even during node failures. This setup empowers organizations to maintain reliable, high-performance database clusters while simplifying traffic management at the application layer. 💡 Takeaway: Combining FortiADC with Patroni for PostgreSQL allows you to deliver continuous database availability, improve resiliency, and reduce operational risk. Video: https://lnkd.in/eTZGiv4P Download: https://lnkd.in/ep6CcyBM #Fortinet #PostgreSQL #Patroni #FortiADC #HighAvailability #Load Balancing