Re: [PHP-DB] database synchronization. .

[Martin Norland]

M Saleh EG wrote:
Are you running your sites on the same server?
If yes use only one database for all of them.
Unless he's installed the latest of either SSvX* or QFCP**, I'm guessing 
his server isn't installed at multiple sites.
  * [SSvX] Schrodinger's Server vX
  ** [QFCP] Quantum Flux Computing Platform

He could just have all the 'sites' use the same database if they were 
websites, he meant sites as in on-site, e.g. physical locations.

I have to agree that you're basically stuck with either replication, or 
the frequent synchronization you're doing now - depending on whether or 
not the servers can always be on.  Is it possible to have a delay on the 
updating of information - to have a master server for the writes, and 
local slave servers at each site for just reads - or are writes too 
common a change?

Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International 
Outreach x3257
The opinion(s) contained within this email do not necessarily represent 
those of St. Jude Children's Research Hospital.

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

Re: [PHP-DB] database synchronization

[M Saleh EG]

Are you running your sites on the same server?
If yes use only one database for all of them.

RE: [PHP-DB] database synchronization

[Murray @ PlanetThoughtful]

 
I have web based application running on php and mysql and installed on
multiple sites. The data on those sites need to be synchronized (to have
same data on every site after insert/update/delete action in each site).
Currently im using an ftp server to handle synchronization, im using batch
script to export and import data running on each site to the ftp server. but
it still is a tedious job that requires constant monitoring, i need to have
some kind of synchronization agent that can be installed on each site. Is
there any tools for that? 



SQLYog Enterprise has inbuilt MySQL synchronization. It's not free, however,
and may not suit your purposes.

I use it to keep my local development db current (or current as at the end
of each day) with record content from our production db without losing
structural changes I've made to local tables while working on new
functionality.

May be worth taking a look at: http://www.sqlyog.com

Murray

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

RE: [PHP-DB] database synchronization

[Bastien Koert]

have a look into replication...might be what you realy need
http://dev.mysql.com/doc/mysql/en/replication.html
bastien
From: "Andri" <[EMAIL PROTECTED]>
To: "PHP DB List" 
Subject: [PHP-DB] database synchronization
Date: Thu, 12 May 2005 14:09:51 +0700

Hello all, anyone can help me?
I have web based application running on php and mysql and installed on
multiple sites. The data on those sites need to be synchronized (to have
same data on every site after insert/update/delete action in each site).
Currently im using an ftp server to handle synchronization, im using
batch script to export and import data running on each site to the ftp
server. but it still is a tedious job that requires constant monitoring,
i need to have some kind of synchronization agent that can be installed
on each site. Is there any tools for that?
Andri Junardi Ahmad
IT Assistant Manager
Tauzia International Management
Wisma Adi Graha 17th floor
Jl. Jend. Gatot Subroto Kav. 56
Jakarta 12950, Indonesia
t. +62 21 5296 0490 f. +62 21 5296 0491
[EMAIL PROTECTED]
  
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] database synchronization

[Juhan Kundla]

Hei!

Ühel ilusal päeval [29-10-2002 12:14] kirjutas Martin Hudec:
> Hello Peter,

I'm not Peter and i don't know, if i can help, but here is one idea.

> I have server of travel agencies records (we need to update this, so
> it is slave) with stable IPand 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.

So you can't determine database servers' ip addresses, since they may or
may not be dynamic. So don't use the ip address, use hostname and
update this hostname every time ip-address changes. You can do it with
your own scripts and local host file or you can use public services like
www.dyndns.org offers.

Juhan

-- 
Vastus: Sest inimene loeb suunaga ülevalt alla.
Küsimus: Miks ülalpool vastamine on halb?

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

RE: [PHP-DB] database synchronization

[Peter Lovatt]

Hi

Take a look at replication

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

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:18
To: [EMAIL PROTECTED]
Subject: [PHP-DB] database synchronization


Hello,

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

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

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


-- 
PHP Database Mailing List (http://www.php.net/)
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