Database Operations at Groupon using Ansible
Make DBA life easier by Automation
Presented by:
Mani Subramanian
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!
Download slides
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.
- Date:
- 2019 February 14 - 14:00
- Duration:
- 45 min
- Room:
- Ballroom 4
- Conference:
- PGConf India, 2019
- Language:
- Track:
- Case Study
- Difficulty:
- Intermediate
- Massively Parallel Postgres Database on Kubernetes
- Start Time:
- 2019 February 14 14:00
- Room:
- Ballroom 1
- The PostgreSQL Query Planner
- Start Time:
- 2019 February 14 14:00
- Room:
- Ballroom 3