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

Bug #1595678 reported by Sveta Smirnova
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Undecided
Carlos Salguero

Bug Description

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

Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

Fix together with bug #1595912

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

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.

Changed in percona-toolkit:
assignee: nobody → Carlos Salguero (carlos-salguero)
status: Confirmed → In Progress
Changed in percona-toolkit:
milestone: none → 2.2.19
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1366

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.