RE: Re[2]: database synchronization

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

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

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

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

HTH

Peter

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

-----Original Message-----
From: Martin Hudec [mailto:corwin@corwin.sk]
Sent: 29 October 2002 08:44
To: Peter Lovatt
Cc: php-db@lists.php.net
Subject: Re[2]:  database synchronization


Hello Peter,

nice reading....looks like i need to get binary log with queries that
modified some data...okay....and use queries from this log on our
slave database....okay

mysqlbinlog log-file | mysql -h server_name

i suppose server_name is hostname.... but what if this hostname
changes (or IP)....

looks like all i have to do is setup to create binary log on master
(other server with various IPs)....then on our machine i will set up
script which will check for new log files in example each 4 hours and
use them....first question...how will i use queries from logfile to
update mine database? and what if other (master) server is not online
(dialup)? Should i make that master server connect to our
server?...Because i think it will be better to send those log files
directly to slave server with stable and well known IP...and make
remote update....than to try to find changing ip of master
server....that puts me to another problem...what if master is running
windows? I can create these scripts on linux..but what on windows?


--
Best regards,
 Martin                            mailto:corwin@corwin.sk

Tuesday, October 29, 2002, 9:29:43 AM, you wrote:

PL> Hi

PL> Take a look at replication

PL> http://www.mysql.com/doc/en/Replication.html

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> -----------------------------------------------

PL> -----Original Message-----
PL> From: Martin Hudec [mailto:corwin@corwin.sk]
PL> Sent: 29 October 2002 08:18
PL> To: php-db@lists.php.net
PL> Subject:  database synchronization


PL> Hello,

PL>       maybe this is not to be posted here but I am working on this
PL>       using PHP and MySQL (one application for travel agencies)

PL>       Does someone know how to synchronize automatically two
PL>       databases....i have one database running on my server with
PL>       static IP and another, from which we are taking updated records,
PL>       on another computer with static or dynamic IP.....has someone
PL>       tried to solve this?

PL> --
PL> Best regards,
PL>  Martin                          mailto:corwin@corwin.sk


PL> --
PL> PHP Database Mailing List (http://www.php.net/)
PL> To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux