Few of the problems faced by DBA’s while running alters using pt-online-schema-change are as follows: Creation of Triggers on Slave may get blocked due to a long running select query Rename of old and new table on slave may get blocked due to a long running select query This utility aims to support DBA's with the above problems.
MySQL (Percona MySQL, Community, and MariaDB) and Postgres DBA and Galera Clusters with 7 years of experience in database administration. Most of my experience has been with E Commerce companies like Lazada (An Alibaba Group Company in Singapore and previously with Snapdeal in India. Purpose of the talk : discuss solution Covered technologies : online alters Target audience : DBA's Audience takeaway : Well tested solution for database operations Looking forward to actively attend the upcoming Percona Live Conference and meet and learn new things. Linked Profile: linkedin.com/in/vishalmysqldba