Edit
DevOpsGrind
http://www.devopsgrind.com/Last activity: -
Probably Closed - Reference to Mercusuar
Work Overview
- Managing over 2000 servers in AWS and AWSCN (China).
- Controlling change management on 500+ Mongo servers and 200+ MySQL servers.
- AWS Services: EC2 instance management, AMI, Snapshots, Volume management, S3
- Deployed MySQL instances successfully.
- Configured master-master and master-slave replication for failover and reporting.
- Right sizing of several servers according to the need
- Partitioned our ever-growing database for pruning and archival records.
- Slow query optimization.
- Automation of scripts and logs.
- Implemented Percona toolkit and monitoring tools.
- Scripted mysqldump, zfs snapshots, aws snapshots and Percona Xtrabackup to backup databases in different scenarios.
- Successful Point-in-Time Recovery Using Binary Logs, xtrabackup copies and snapshots.
- Designed a process to prune and archive old data to keep the database efficient and within capacity. S3 Archiving
- Deployed MongoDB using replica sets.
- Implemented Sharding to scale up.
- Designed ETL job for mongo analytics server using AWS snapshots.
- Deployed PostgreSQL 9.2 for analytics and planned successful upgrade to 9.4
- Ansible automation and implementation for different release projects.
- Managing over 2000 servers in AWS and AWSCN (China).
- Controlling change management on 500+ Mongo servers and 200+ MySQL servers.
- AWS Services: EC2 instance management, AMI, Snapshots, Volume management, S3
- Deployed MySQL instances successfully.
- Configured master-master and master-slave replication for failover and reporting.
- Right sizing of several servers according to the need
- Partitioned our ever-growing database for pruning and archival records.
- Slow query optimization.
- Automation of scripts and logs.
- Implemented Percona toolkit and monitoring tools.
- Scripted mysqldump, zfs snapshots, aws snapshots and Percona Xtrabackup to backup databases in different scenarios.
- Successful Point-in-Time Recovery Using Binary Logs, xtrabackup copies and snapshots.
- Designed a process to prune and archive old data to keep the database efficient and within capacity. S3 Archiving
- Deployed MongoDB using replica sets.
- Implemented Sharding to scale up.
- Designed ETL job for mongo analytics server using AWS snapshots.
- Deployed PostgreSQL 9.2 for analytics and planned successful upgrade to 9.4
- Ansible automation and implementation for different release projects.