MySQL Bugs: #50284: Backup to multiple locations at the same as well as different servers

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:	None
Category:	MySQL Server: Backup	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	Rafal Somla	CPU Architecture:	Any

Description:
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.

Thank you for the feature request.

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.