[BNM] synchronise two mysql dbs

[Alan Newman]

Hi Nick,

No worries.

There is more information here:

http://dev.mysql.com/doc/refman/5.0/en/replication.html

You can even do clustering as well as asynchronous updates. Apparently (from
talking to people to people that have done it in high risk environments) it
works very well.

Regards,

- Alan


-----Original Message-----
From: Nick Wilsdon [mailto:n.wilsdon at e3internet.com]
Sent: 04 September 2006 12:26
To: 'Brighton New Media'
Subject: Re: [BNM] synchronise two mysql dbs


> MySQL 5 has 'full on' replication - if that helps.
>What version are you using?

Hi Alan,

Thanks for the reply -

The server is running 4.1.21-standard but the local Ubuntu box is on 5.0.22.
I can probably update the main server though if that will get this working.


Best Regards,

Nick

Managing Director
e3internet
http://www.e3internet.com

P please consider the environment - do you really need to print this email?





--

BNM info/subscription/archives: http://www.brightonnewmedia.org/

BNM archive search: http://www.roddis.org/bnm/search.php
BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
BNM Flickr group: http://www.flickr.com/groups/bnm/

BNM powered by http://www.screen-play.net/