|
Paul, I see a few problems in the configuration you described.
You explained that I can kill the MySQL on the Master, tar it up, copy the
data to the Slave and activate it as the Slave. Unfortunately this is not
how MySQL works. MySQL requires that the Master and Slave be identical data
files, *IDENTICAL* that means the Master (tar file) cannot change before the
Slave comes online.
Mike
> Michael McConnell wrote:
>
> > Paul, you said that I could simply copy the Data from the Slave to a new
> > Slave, but you must keep in mind, in order to do this MySQL requires
that
> > the Master and Slave data files be IDENTICAL, that means the Master must
be
> > turned off, the data copied to the slave, and then both systems
activated.
> > Resulting in serious downtime.
> >
>
> You only have to make a copy of the data one time when you initial set
> up your Master the first time. As long as it takes to do this is your
> downtime:
>
> kill mysqlpid
> tar cvf mysql-snapshot.tar /path/to/mysql/datadir
> /path/to/mysql/bin/safe_mysqld
>
> Your down time is essentially only how long it takes to copy your 6 gigs
> of data NOT across a network, but just on the same machine. (which is
> far less than a myisamchk on the same data) Once that is done, at your
> leisure you can copy the 6 gigs to the slave while the master is still
> up and serving requests.
>
> You can then continue to make slave after slave after slave just by
> copying the original snap shot to each one. The master never has to be
> taking offline again.
>
> --
> =======================================================================
> Paul J. Baker Internet Systems Developer
> pbaker@xxxxxxxxxxxxxxx Where2GetIt.com
> phone 847-498-0111x234
> fax 847-480-7422
> =======================================================================
>
>
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
|
