Re: [Fwd: Re: Replication syncronization lag.]

2004-01-15 Thread Neil Gunton
Jonathan Tullett wrote: > > Further to the email below,I performed the upgrade last night and we are > now running mysql 4.0.16. > > the last on the syncronization hasnt reduced any, so if anyone knows how > else I can keep these two databases in sync, I would be very intereste

[Fwd: Re: Replication syncronization lag.]

2004-01-15 Thread Jonathan Tullett
Further to the email below,I performed the upgrade last night and we are now running mysql 4.0.16. the last on the syncronization hasnt reduced any, so if anyone knows how else I can keep these two databases in sync, I would be very interested in knowing how! now that we are running the 4.0

Re: Replication syncronization lag.

2004-01-13 Thread Jonathan Tullett
Hello, Many thanks for your reply! I am currently syncronizing two MySQL servers (version 3.23.49) on a very high traffic website. There are, at peak times upwards of 600 updates a second (and many many more selects) During these times the slave database will fall out of sync, sometimes by s

Re: Replication syncronization lag.

2004-01-08 Thread Fred van Engen
Jonathan, On Thu, Jan 08, 2004 at 12:54:06PM +, Jonathan Tullett wrote: > I am currently syncronizing two MySQL servers (version 3.23.49) on a > very high traffic website. > > There are, at peak times upwards of 600 updates a second (and many many > more selects) > > During these times the

Replication syncronization lag.

2004-01-08 Thread Jonathan Tullett
Hello. I am currently syncronizing two MySQL servers (version 3.23.49) on a very high traffic website. There are, at peak times upwards of 600 updates a second (and many many more selects) During these times the slave database will fall out of sync, sometimes by several thousand seconds (im a

RE: Syncronization between two databases

2002-01-08 Thread Roger Baklund
* Marco Frazzoli > I need to syncronize two indentical MySQL databases. > > The A database is on a server permanently connected to the Internet > trough an ADSL connection, while the B database is on a server equipped > with an ISDN connection. > > How can I keep the two databases identical? By n

Re: Syncronization between two databases

2002-01-08 Thread Jeremy Zawodny
On Tue, Jan 08, 2002 at 10:49:32PM +0100, Marco Frazzoli wrote: > Jeremy Zawodny wrote: > > > On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: > > > >>Hi! > > > > Have you looked at MySQL's built-in replication? > > Yes. But it seems to be created for a permanent connection betw

Re: Syncronization between two databases

2002-01-08 Thread Marco Frazzoli
Jeremy Zawodny wrote: > On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: > >>Hi! > > Have you looked at MySQL's built-in replication? Yes. But it seems to be created for a permanent connection between two databases... or can I make a replica using a dial-up connection (such as

Re: Syncronization between two databases

2002-01-08 Thread Jeremy Zawodny
On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: > Hi! > > I need to syncronize two indentical MySQL databases. > > The A database is on a server permanently connected to the Internet > trough an ADSL connection, while the B database is on a server > equipped with an ISDN connectio

Syncronization between two databases

2002-01-07 Thread Marco Frazzoli
Hi! I need to syncronize two indentical MySQL databases. The A database is on a server permanently connected to the Internet trough an ADSL connection, while the B database is on a server equipped with an ISDN connection. How can I keep the two databases identical? Thanx Marco Frazzoli PS: S

RE: Database Syncronization

2001-12-10 Thread Jonathan Hilgeman
Syncronization Hi I have a similar database on the local and remote server. I want to syncronize the two. Please Help Ananth __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

Re: Database Syncronization

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:12:58AM +, [EMAIL PROTECTED] wrote: > On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote: > > You may want to have a look at "replication" in the fine manual: > > http://www.mysql.com/doc/R/e/Replication.html > > A lot of info there! But it seems to ap

Re: Database Syncronization

2001-12-10 Thread Kevin Donnelly
On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote: > You may want to have a look at "replication" in the fine manual: > http://www.mysql.com/doc/R/e/Replication.html A lot of info there! But it seems to apply mainly to v4. I'm not sure of Ananth's situation, but what I want to do is h

Re: Database Syncronization

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 02:17:07AM -0800, [EMAIL PROTECTED] wrote: > Hi > I have a similar database on the local and remote > server. I want to syncronize the two. > > Please Help I would love to, if I knew what's the problem. You may want to have a look at "replication" in the fine manual

Database Syncronization

2001-12-10 Thread Ananth Rajaraman
Hi I have a similar database on the local and remote server. I want to syncronize the two. Please Help Ananth __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --

Syncronization

2001-04-18 Thread Andrew Dennison
Here's the situation. I have two application servers, each running their own mysql databases. If one goes down, the other takes over for it. But when it comes back up, whatever user preferences were stored on the other server during the downtime are lost. I need a way to syncronize the databas