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

Turn “Ad-Hoc Chaos” into Trusted Self-Service BI

Self-service BI works when the data foundation removes friction for business users. Our reusable dimensional framework gives you trusted definitions, “as-was” and “as-is” choices, foolproof joins, and upstream data quality checks, so teams can explore confidently without hand-coding SQL or exporting to Excel (or god help us all MS Access).

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

Push the Logic to the Data: Using PL/Python and GreenplumPython for Scalable In-Database Processing

Demonstrate how to leverage PL/Python and the GreenplumPython library to push data transformation logic directly into the Greenplum Database. This approach aligns with a key best practice in big data architecture: move processing to the data, not the other way around. Achieve a scalable, more secure, more cost effective solution for your Python dev team.

Read More

Predicting Customer Churn Using Greenplum and gpmlbot

This blog summarizes a demonstration delivered to a customer interested in understanding how Greenplum can be used for machine learning, without exporting data to external systems. The objective was to showcase how churn modeling can be prototyped and iterated entirely within Greenplum using the gpmlbot utility, which automates feature preparation, model training, and evaluation.

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