Projects
PT-OSC Automation: GitHub Repository
- Developed an automation tool to streamline schema changes using Percona Toolkit's pt-online-schema-change utility.
- Designed a Python wrapper to handle pre-checks and execution, ensuring seamless and error-free schema modifications.
- Implemented robust pre-check mechanisms, including:
- Validating the node role to ensure operations are executed only on the primary server.
- Ensuring table structure compliance, including the presence of primary key constraints.
- Detecting and handling pre-existing triggers created by the tool to avoid conflicts.
- Assessing table size to ensure it remains within acceptable thresholds.
- Verifying the absence of foreign key constraints in the table structure.
- Populating `percona.dsns` entries with accurate replica details.
- Monitoring replica lag and pausing operations if the lag exceeds the defined threshold.
- Once all pre-checks are completed, the actual execution will start and update the status in a MySQL table.
PT-Archiver Automation: GitHub Repository
- Developed an automation tool to streamline archiver process using Percona Toolkit's pt-archiver utility.
- Designed a Python wrapper to handle pre-checks and execution, ensuring seamless and error-free schema modifications.
- Implemented robust pre-check mechanisms, including:
- Validating the node role to ensure operations are executed only on the primary server.
- Ensuring old table existance, including the presence of primary key constraints.
- Verifying the absence of foreign key constraints in the table structure.
- Populating `percona.dsns` entries with accurate replica details.
- Monitoring replica lag and pausing operations if the lag exceeds the defined threshold.
- Once all pre-checks are completed, the actual execution will start and update the status in a MySQL table.
Multi-Region VM Databases in GCP:
- Developed a solution to deploy multi-region MySQL databases in Google Cloud Platform (GCP).
- Designed a Terraform module to automate the provisioning of multi-region MySQL instances in GCP.
- Configured high availability and failover mechanisms using GCP's Instance group manager.
- Implemented automated backups and monitoring using GCP's Cloud Monitoring and Cloud Storage.
- Ensured secure access by integrating IAM roles and service accounts for resource management.
- Enabled secure communication between instances using VPC peering and firewall rules.