Database Operations at Groupon using Ansible
Make DBA life easier by Automation
Over 25 years of experience in Database Technologies, Team Lead, Software Analysis, Design and Software Development in various commercial packages including Mortgage sales & servicing, Shop Floor Execution, and Identity Management, Supply Chain Performance Management System, Social networking and e-commerce marketplace. Primarily Managing Relational databases including MySQL, PostgreSQL and Oracle. Years of production support on these databases, troubleshooting, performance tuning on needed databases.
For more details: https://www.linkedin.com/in/manidba/
No video of the event yet, sorry!
Most of the database operations can be automated using DevOps tool. At Groupon we have automated our database operations using Ansible Playbook that includes Database Provision, User creation, Whitelisting application servers(Grants), Setting up replication, Destroying/decommissioning instances, Failover databases with data center and failover to DR center. Interesting tools can be developed using Ansible that can run against 100's of databases. Similar presentation is presented at Percona Live 2018 conference in Santa Clara.
- 45 min
- PGConf India, 2019
- Case Study