pt-online-schema-change data-dir can not be used remotely

Bug #1742786 reported by Bryce Moore on 2018-01-11
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to

Bug Description

If --data-dir option is specified in pt-online-schema-change, the directory given must be writable for the executing user on the localhost that pt-online-schema-change is executed from, even if the target database is remote. Without this, the tool fails with "directory is not writable". This prevents using pt-online-schema-change from a remote application or administrative server that is not set up as a database server.

To reproduce, run the following on a server that does not have directory "/var/lib/mysql_archive" but has connectivity to "remotehost" that does have "/var/lib/mysql_archive":

pt-online-schema-change --config ptoolkit.cfg --alter "engine=innodb" --data-dir /var/lib/mysql_archive --execute h=remotehost,D=db1,t=tb1

Bryce Moore (bmoore29) on 2018-01-11
description: updated

This is a MySQL limitation.

Changed in percona-toolkit:
status: New → Invalid

Percona now uses JIRA for bug reports so this bug report is migrated to:

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

Other bug subscribers