examples for pt-online-schema-change

examples for pt-online-schema-change

```shell

pt-online-schema-change \
    --execute \
    --no-check-alter \
    --ask-pass \
    --recursion-method none \
    --set-vars lock_wait_timeout=3 \
    --alter "change serial_code warehouse_code varchar(100) not null default ''" \
    u=xcf,h=xcfapp-mysql,D=xcf_mfarm,t=fresh_warehouse

pt-online-schema-change \
    --execute \
    --no-check-alter \
    --ask-pass \
    --recursion-method none \
    --set-vars lock_wait_timeout=3 \
    --alter "add column url varchar(100) not null default ''" \
    u=xcf,h=devdb,D=xcf_mfarm,t=explore_tab
    
pt-online-schema-change \
    --execute \
    --no-check-alter \
    --ask-pass \
    --recursion-method none \
    --set-vars lock_wait_timeout=3 \
    --alter "add column data_json blob" \
    u=xcf,h=devdb,D=xcf_mfarm,t=fresh_warehouse
    
```