Not the answer you need?
Register and ask your own question!

pt-online-schema-change usage between master and slave mysql server

ashoknixashoknix EntrantCurrent User Role Beginner

I have Master and slave setup with version: 5.5.56-MariaDB MariaDB Server

I need to add index for "create_time" column. I am planning to alter using pt-osc running such command in Master server
pt-online-schema-change D=obs_db,t=ob_status,h=localhost --alter "ADD INDEX (create_time)" --alter-foreign-keys-method="auto" --execute --set-vars="innodb_lock_wait_timeout=50"

Do I need to add anymore options for slave?
Will slave get replicated instantly?

Please advise..



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.