3247 - 数据库管理员 - DevOps 的无名英雄.pdf

1、Orlando,FLOctober 69IBM TechXchange 20253247Ron Coleman&Anthony AnterDBAs The Unsung Heroes of DevOpsWhat is an ApplicationIBM TechXchange|2025 IBM Corporation2Infrastructure Operating System&Utilities Workflows Automation Source Code Meta-Data Data Schema Data Current Application Development IBM Te

2、chXchange|2025 IBM Corporation3An application change is planned and ready to go,follows the current automated pipeline to Production Schema changes are required to support this change,a new“pipeline”is needed for this parallel change to coincide with the code changes,these are typically handled manu

3、allyDBA ReviewManual Update SQL Changes are included in the updated code,Cobol-DB2 or Stored Procs,these are manually reviewed by DBAs DBA ReviewThis is assuming these SQL changes are reviewed ahead of deployment DevelopBuildScanDeployTestYou now have 3 engagements for a single“Change”that need to b

4、e coordinated tying up 1 to(n)resourcesThere is a better way!IBM TechXchange|2025 IBM Corporation4DevelopBuildScanDeployTestCode CoverageModern IDEAutomated SQL Scans DBA ReviewAutomated Schema Updates DBA ReviewProductionAutomated Test Data and Testing All changes are facilitated via a single autom

5、ated pipeline SQL is scanned and reviewed as part of the pipeline before it goes into production Schema changes are a part of the application and are pushed with the application changes DBAs are engaged only as needed in exception casesAll your tooling works together across your whole application au

6、tomating the full change Standard Pipeline IBM TechXchange|2025 IBM Corporation5Changes can be automated via a standard DevOps pipeline with our webhooks and open borders approach This pipeline can move changes through your entire lifecycle,Dev-QA-Pre-Prod-ProductionAdd Data Mana