Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1595678: pt-online-schema-change does not allow to specify user to check slave if --recursion-method processlist or host is used

Description

**Reported in Launchpad by Sveta Smirnova last update 16-08-2016 09:15:16

There is no way to specify custom user for pt-osc to check slave if recursion-method processlist or host is used.

This is feature request.

Suggested fix: add option --slave-user or similar

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 9:12 PM

**Comment from Launchpad by: Sveta Smirnova on: 24-06-2016 11:53:18

Why this feature is needed?

Currently if I have, say, two servers Master -> Slave I can have full privileged user with name, say, ptosc on master and less privileged user with same name on slave.

But if I have to switch master and slave (in case of failover, for example) I will end up with less privilege user on new master and would not be able to run pt-osc. Workaround for this situation: have highly privileged user on all servers for pt-osc, but this is security breach.

lpjirasync January 24, 2018 at 9:12 PM

**Comment from Launchpad by: Sveta Smirnova on: 24-06-2016 10:42:16

Fix together with bug #1595912

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 9:12 PM
Updated December 20, 2023 at 3:43 AM
Resolved January 24, 2018 at 9:12 PM