DBA Operations, DevOps Louis Mugnano DBA Operations, DevOps Louis Mugnano

When “Nothing Changed” Breaks Your Greenplum Performance

Experiencing Greenplum performance issues after a network change? If Informatica ETL jobs are suddenly slow but CPU, memory, and disk look normal, the problem may be hidden in the Greenplum interconnect layer. This post explains how subtle backend network behavior, UDP retries, and inter-segment communication issues can quietly degrade MPP database performance.

Read More

Greenplum Architecture Assessment Automation

From script sprawl to structured, drill-down diagnostics.

When I assess customer Greenplum environments, I lean on a suite of lightweight shell utilities that make deep inspection fast and repeatable. At the core is gpview.sh, an interactive catalog viewer. Around it are wrappers for scheduled health checks, single-report runs, and persistence for trending over time.

Read More

Kickstarter: Automating Backup, Replicate & Restore in Greenplum

Disaster Recovery (DR) isn’t just “take a backup.” At MPP scale, you need a repeatable end-to-end flow with minimal coordination and downtime. This post walks through the DBA Operations Kickstarter framework that wraps gpbackup, gpbackup_manager, and gprestore into a fully automated DR pipeline

Read More

Kickstarter: Automating Partition Maintenance in Greenplum

Partitioning is a cornerstone of scalable analytics in Greenplum Database. The hardest part of partitioning isn’t design, it’s keeping partitions current. The kickstarter Partition Maintenance toolset is a set of Bash/Python utilities that operationalizes this lifecycle for Greenplum. This post will dive into this set of tools.

Read More

Operational Excellence on Day One: Introducing the DBA Operations Kickstarter

The DBA Operations Kickstarter is a comprehensive toolkit designed by Mugnano Data Consulting to automate and operationalize best-practice DBA workflows for Greenplum and Cloudberry environments. Whether you're onboarding a new system or stabilizing an existing one, this solution delivers an enterprise-grade operational foundation in hours, not months.

Read More