Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1286

LP #1460783: pt-online-schema-change - using dsn only picks up last IP address given

    XMLWordPrintable

    Details

      Description

      **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

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist