Hi Sasha,
Sasha Pachev wrote:
> Apparently, LOAD TABLE FROM MASTER is buggy - until we get it cleaned up, use
> mysqlhotcopy to copy the tables instead. I'll be doing a thorough code
> examination shortly.
nice to hear, this seems to decrease the number of places wher the bug can
hide ;-)
> It is possible to add another slave to the already
> running replication with the following trick:
>
> * lock all table on the master for read ( FLUSH TABLES WITH READ LOCK)
> * SHOW MASTER to get the the current log and the current position
> * quickly copy all the tables to a local directory ( can be remote, but local
> is better to minimize downtime)
> * UNLOCK TABLES on the master
> * copy all the backed up tables to the slave
> * start the slave with --skip-slave-start
> * CHANGE MASTER TO MASTER_LOG_POS=remembered_pos,
> MASTER_LOG_FILE=remembered_log_file;
> * SLAVE START
AAAAARRRRRRGGGH. The mysql-Documentation is best read with open eyes.
I did countless times step over chapter 11 but I did NOT find the
lines mentioning MASTER_LOG_POS and MASTER_LOG_FILE.... my fault.
perhaps you could change the example in the documentation (11.5)
that reads
CHANGE MASTER TO
MASTER_HOST='master2.mycompany.com',
MASTER_USER='replication',
MASTER_PASSWORD='bigs3cret',
MASTER_PORT=3306;
just to include the other options too. This example I've read several
times, it just hit my eyes every time I got through that chapter.
> We do have plans to automate all of that with one command - SLAVE SYNC in
> 3.23 branch. In 4.0 it will be even better - master tables will not be
> locked.
very fine, this will be our solution.
regards,
Werner.
--
Werner Maier E-Mail: [EMAIL PROTECTED]
fidion GmbH Berner Straße 2, 97084 Würzburg
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
