On Wed, Jan 17, 2001 at 11:16:27PM -0800, Mike Wexler wrote:
>
> This is a big improvement. What would be really cool would be to
> read lock a table, copy it to the slave, and then tell the slave to
> start paying attention to the binary log for *that* table. Then it
> would repeat this for all tables. During the process, that slave
> would have inconsistent versions of the database, but at the end the
> slave would be entirely consistent with the master.
Yeah, but that would also be quite a bit more tricky to program. :-(
I've got the first version of `myrepl' half done already, so I'll know
real soon if this is likely to do the trick. If this works, I'll think
harder about how to do this on a per-db (or per-table) basis. But I
might not try *too* hard, knowing that the MySQL team is working to
make this easier on their end, too.
> > Damn. And I was planning on going to bed early...
>
> There is always tomorrow...
Good point. I'll sleep tomorrow. :-)
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
