1914 - 数据库操作 (DbOps).pdf

1、Orlando,FLOctober 69IBM TechXchange 20251914Database Ops(DbOps)Davorin KremenjaUniversity Computing Centre,University of ZagrebDevOps EngineerStatusBackgroundObjectivesImplementation&ToolsObservabilityEcosystemFuture plansConclusionQ&AAgendaTerminology/definition overloadDatabase DevOpsDatabase Ops(

2、DbOps)Data Ops(only for analytics?)Can it fit into GitOps?Is it just about automation?Main objectivesMust have:common tools and interfaces for all teamsApply DevOps principles and tools in day-to-day DB administrator/developer tasksDelegate(some of the)DBA workload to developers but.Relieve develope

3、rs of a need to know the Informix(and other RDBMS)internalsBonus featuresIntegrate databases into existing automated development pipelinesExpose data sources as first class building blocksStreamline release management100%open source toolingUsed and trusted by big namesReusing established company-wid

4、e toolsSimple to extendTechnology StatusCompany50+years,180 employeesnational IT infrastructure provider for science&higher educationpart of University of Zagreb,Croatia(350+years)Teams100 IT/tech employees,bespoke information systemsvery diverse teamsinfrastructure/virtualization teamLinux sysadmin

5、sbackup/archive adminsJava desktop(Swing)devsJava/.Net/PHP web devsR devs/analystsand a handful of DbOps/DevOps/SRE folksSystemsa number of existing,large,bespoke systems written in Java,.Net and PHPdesktop/standalone&web appsnew and existing reporting/analytics systemsInformix based data warehouses

6、(not IWA,“plain“IDS)R/Shiny standalone appsCompany Backgroundreuse existing DBA expertisereuse existing scriptsutils2_ak most generic functionality already therein-house built for remaining bespoke needsmainly shell via cronexpose through common,simple to use interfaceenforce security through standa