You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Records that are already in place in the source table that gh-ost acts on are put into the target table correctly, eg
A source record with the column enumerated as AMEX would appear in the target table as the string "AMEX"
Records that are inserted into source table during the gh-ost operation (between the start of the gh-ost operation and the cutover) will appear in the target table tokenised, eg
An inserted record with column enumerated as AMEX would appear in the target table as string "1", PAYPAL would appear "2" etc
The text was updated successfully, but these errors were encountered:
Source table has enum columns populated with TEXT entries of the form :
pay_id
enum('AMEX','PAYPAL','CASH','CHEQUE') NOT NULL,Gh-ost execution :
Define the target DB, table name and the alter string
mdb="live"
mtable="payments"
malter="CHANGE pay_id pay_id VARCHAR(255) NOT NULL"
file="gh-ost-updates$(date +%Y%m%d)"
gh-ost
--max-load=Threads_running=25
--critical-load=Threads_running=1000
--chunk-size=1000
--max-lag-millis=1500
--conf=/root/.my.cnf
--host=127.0.0.1
--database="$mdb"
--table="$mtable"
--verbose
--alter="$malter"
--allow-master-master
--allow-on-master
--cut-over=default
--exact-rowcount
--concurrent-rowcount
--default-retries=120
--panic-flag-file=/tmp/ghost.$mtable.panic.flag
--postpone-cut-over-flag-file=/tmp/ghost.$mtable.postpone.flag
--execute
| tee -i "$file-$mtable.sql.log"
Records that are already in place in the source table that gh-ost acts on are put into the target table correctly, eg
A source record with the column enumerated as AMEX would appear in the target table as the string "AMEX"
Records that are inserted into source table during the gh-ost operation (between the start of the gh-ost operation and the cutover) will appear in the target table tokenised, eg
An inserted record with column enumerated as AMEX would appear in the target table as string "1", PAYPAL would appear "2" etc
The text was updated successfully, but these errors were encountered: