List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 11 2003 4:55pm
Subject:Re: Master (pc) Slave (laptop) Replication
View as plain text  
At 11:48 -0500 3/11/03, Daniel Negron/KBE wrote:
>I have set up replication and have it working properly for the most part.
>If I update the master the slave follows suit.  But my slave is a laptop,
>that I use for testing but would like that data to stay up to date withthe
>master.  Overnight if 'live changes take place on the Master, while the
>slave is not connected,
>
>How to I sync up the slave ? (without dumping the db or creating a
>snapshot)
>
>mysql - master = 3.23.33
>mysql - slave = 3.23.52

It shouldn't matter.  Slave servers retry occasionally when the connection
breaks.   There are startup options you can use to set the number of retries
and the interval between them.

>
>
>Thank you,
>
>
>-----------------------------------------------------------
>         ---------                Daniel Negron
>
>       //         \\            *****************
>      /  _  __ ___  \    Lotus Notes Admin / Developer
>     |  | |/ /| _ )  |   KB Electronic, Inc.
>     |  | ' < | _ \  |   12095 NW 39th Street
>     |  |_|\ \|___/  |   Coral Springs, FL. 33065
>      \     \_\     /    954.346.4900 x 122
>       \\         //     email: danegron@stripped
>
>         ---------       http://www.kbelectronics.com
>-----------------------------------------------------------
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread134461@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
Master (pc) Slave (laptop) ReplicationDaniel Negron/KBE11 Mar
  • Re: Master (pc) Slave (laptop) Replicationgerald_clark11 Mar
Re: Master (pc) Slave (laptop) ReplicationPaul DuBois11 Mar
Re: Master (pc) Slave (laptop) ReplicationDaniel Negron/KBE11 Mar