Modernizing On-Premise Infrastructure for Database Scalability
summary
An alert‑driven automation provisions and reclaims EMC PowerMax storage for SQL Server clusters by writing requests to an internal SQL table via a Swagger API, then letting scheduled Jenkins CI/CD pipelines run idempotent Python/Groovy/Powershell jobs that validate storage arrays, perform LUN mounts, update status, and notify via Slack while logging to Splunk. The system handles thousands of requests/month, runs dozens of Jenkins branches in parallel, averages less than 30 minutes turnaround, reduces manual work to zero and saves millions in licensing and storage costs.
AI-written summary · about
chapters (10)
- 0:00Introduction and speaker background
- 2:38Cloud vs on-premise infrastructure
- 5:09Challenges of on-premise management
- 7:18DevOps methodologies for infrastructure
- 11:33Alert-driven storage provisioning
- 18:14Benefits of the automation system
- 21:05Key technical details of automation
- 22:31Challenges and improvements
- 24:18Database movement and failover automation
- 26:45Summary and conclusion
related talks
38mDeploying Database Clusters in the Cloud
48mAzure Stack HCI and Microsoft Hybrid Data Services
42mBuilding Elastic Infrastructures
01h 03mWindows at Scale
20mWhat Playing Minecraft Taught Me About DevOps
28mHybrid database-as-a-service for DevOps
29mTaming the Hybrid Beast with DevOps
28mDesigning for Failure: How to Manage Thousands of Hosts Through Automation