maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Setting up a new slave easily
CREATION DATE..: Thu, 30 Jun 2011, 15:12
SUPERVISOR.....: Knielsen
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 209 (http://askmonty.org/worklog/?tid=209)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

The current procedure to setup a slave is:
* mylvmbackup (or similar snapshot) on a slave
* restore it to a new box
* recover InnoDB
* connect it to the master.

We'd like to have a command that can be issues to an empty database, will
download the data from a master (or a co-slave), and then attach the new slave
to the master (using the configuration provided on the command line or by the
co-slave).

Requirements:
* Should be done at SQL level.
* With progress report.
* The data should move at disk speed; No index creation, ship binary index data
from the co-slave or master.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)