-
Type:
Bug
-
Status: Done
-
Priority:
Low
-
Resolution: Invalid
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Launchpad URL:
**Reported in Launchpad by Dave Gregg last update 02-06-2015 18:40:24
We have a Master and 2 Slaves
Master = 192.168.192.138
Slave 1 = 192.168.192.137
Slave 2 = 192.168.192.136
When issuing the following....
pt-online-schema-change h=192.168.192.138,h=192.168.192.137,h=192.168.192.136,D=menagerie,t=MyGuests --check-interval=5 --max-lag=10 --alter "modify email varchar(256);" --execute
it appears to only pick up the last IP address in the string - i.e. -> "h=192.168.192.136" (which is a slave) and only modifies the
schema on that system. Debug shows an empty DSN string ??
Is this only suppose to connect to the MASTER ??? and thus find the Slaves from that??
I see in the documentation - it specifies to have multiple IP addresses in the "table" - if you want to monitor the hosts for REPLICATION LAG time. So are we suppose to only utilize the MASTER IP Address on the command line?
i.e. - like this ?
pt-online-schema-change h=192.168.192.138,D=menagerie,t=MyGuests --check-interval=5 --max-lag=10 --alter "modify email varchar(256);" --execute