Bug #50284 Backup to multiple locations at the same as well as different servers
Submitted: 12 Jan 2010 17:29 Modified: 22 Jan 2010 9:31
Reporter: Hema Sridharan Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server: Backup Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Rafal Somla CPU Architecture:Any

[12 Jan 2010 17:29] Hema Sridharan
Currently we can execute backup only to one specific location something like,

BACKUP DATABASE db1 TO '/tmp/db1.bak';

We should also have possibility to backup database to multiple locations at the same time. This will help during catastrophic situation and also reduce time in having multiple copy of databases .

Something like,
BACKUP DATABASE db1 TO '/tmp/db1.bak', '/usr/dump/db1_copy.bak';

Redundant copy of backup (to a local and remote location at the same time) helps in duplicate copy of database.

How to repeat:
This is a feature request and is not currently implemented in MySQL backup.
[12 Jan 2010 17:34] Valeriy Kravchuk
Thank you for the feature request.
[22 Jan 2010 9:31] Lars Thalmann
This can be done using named pipe. Implementing this would 
introduce some complexity into the server. Unless there are 
users asking for this, we do not plan to implement it. 

Anyone who wants this feature is welcome to add a comment 
saying so to this bug report.  If there are many requests, 
we'll change the decision.