List:General Discussion« Previous MessageNext Message »
From:Martin Hudec Date:October 29 2002 9:18am
Subject:Re[4]: [PHP-DB] database synchronization
View as plain text  
Hello Peter,

okay :)))....so far I understand...but....hmmm let me explain....

I have server of travel agencies records (we need to update this, so
it is slave) with stable IP....and then bunch of other computers (from
these we are updating...so they are all masters) in various travel
agencies...but not all of them have stable IP (some joins using
dialup...some have stable line)...some girl there updates
database...and they may not be on net....:).....
So in this case i have one slave and many masters.....

solution one:

My server (slave) has to periodically check for updates....when
masters have stable IP I can make list of IPs and then connect to each
server and take binary update log...and use it....but what can i do
when master has dynamic IP? So i discard this solution....

solution two...better...from my point of view ;):

Masters with stable IP will update in period of for example 4
hours....masters with dynamic IP will update when they are online
(girl browsing on chatting sites ;)))....that puts the question if
there is possible to make remote update (sending binlog from master to
slave and automatically updating slave)(but if i understood your
previous mail...synchronization (replication) is done automaticaly....
the question two is what if this master is running Windows 98 with
MySQL-win for example? Is that possible to make also in windows?

I will try to post this also to mysql list....

-- 
Best regards,
 Martin                            mailto:corwin@stripped

Tuesday, October 29, 2002, 10:05:00 AM, you wrote:

PL> Hi

PL> Replication works continuously when the two databases are in contact with
PL> each other, unless you specify otherwise. Likewise, if you connect
PL> periodically, MySql will synchronise the two databases itself.

PL> With replication, MySql logs everything the master does. When a slave logs
PL> in (you can have any number of slaves) it checks the master logs to see how
PL> up to date it is, and 'catches up' with the master.

PL> Once it is set up correctly you don't need to do anything yourself.

PL> HTH

PL> Peter

PL> -----------------------------------------------
PL> Excellence in internet and open source software
PL> -----------------------------------------------
PL> Sunmaia
PL> www.sunmaia.net
PL> tel. 0121-242-1473
PL> -----------------------------------------------

Thread
Re[4]: [PHP-DB] database synchronizationMartin Hudec29 Oct
  • RE: Re[4]: [PHP-DB] database synchronizationPeter Lovatt29 Oct
    • Re[6]: [PHP-DB] database synchronizationMartin Hudec29 Oct