FW: Replication

2003-12-15 Thread Luc Foisy
I sent this out friday, but didn't see it come through to the list, so sorry if it comes up twice if the original is lost in lala land at the moment. -Original Message- From: Luc Foisy Sent: Friday, December 12, 2003 4:17 PM To: MYSQL-List (E-mail) Subject: Replication The scenario we

FW: Replication - Slave Backup to Master

2003-11-13 Thread nm
Hi I set a 2-way replication on 2 servers. I made some test transactions and it is working. I can make the clients go to any of my servers and the replication is done in real time, or so. It looks great. What are the potential problems I could have? Suggestions? Do you have any experience? (usin

Fw: Replication Problem (XP+mysql4.0.14)

2003-08-27 Thread Massimo Petrini
nobody have answer ? For me it is very urgent to kwow when the .15 version will be avalaible . Tks - Original Message - From: "Massimo Petrini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "I.P." <[EMAIL PROTECTED]> Sent: Friday, August 22, 2003 1:16 PM Subject: Re: Replication Problem

Re: Fw: Replication

2003-08-23 Thread Fred van Engen
Sam, On Fri, Aug 22, 2003 at 08:37:33PM -0400, sam [EMAIL PROTECTED] wrote: > So, you are saying that the fact that replication is > not working when we re-connect is not a bug. > > Replication is all about passing data from one node > (a master) to the next (the slave). I do not know what > it

re: Fw: Replication

2002-11-02 Thread Victoria Reznichenko
Alexander, Friday, November 01, 2002, 2:02:18 PM, you wrote: AB> Every time I want to replicate, do I have to restart? No. Use SLAVE START and SLAVE STOP commands. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensi

Fw: Replication

2002-11-01 Thread Alexander Burbello
Every time I want to replicate, do I have to restart? Alexander sql,query - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Alexander Burbello" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 9:33 PM Subject: Re: Replication > On Thu, Oct

Re: FW: Replication reset

2001-12-28 Thread Sasha Pachev
On Friday 28 December 2001 10:18 am, Steve Rapaport wrote: > I didn't think it was possible to put arbitrary mysql commands like SHOW > MASTER STATUS into a script. ?I had assumed I was limited to the > shell-level utilities like mysqlimport and mysqldump. > How exactly do I put the > interactiv

Re: FW: Replication reset

2001-12-28 Thread Steve Rapaport
>>How do we automatically know the master has failed and record that offset? >> > > You need to have your system set up in such a way that failover event will > trigger the execution of a script, which will do all the magic. Good idea! I didn't think it was possible to put arbitrary mysql com

Re: FW: Replication reset

2001-12-28 Thread Sasha Pachev
> > Here is how you can do the above: > > > > * make sure slave runs with log-bin. > > > > * before you direct updates to the slave, record the binlog offset and > > position on the slave by running SHOW MASTER STATUS ( on the slave not on the > > master!) > > > Whoops! When the failover

Re: FW: Replication reset

2001-12-27 Thread Steve Rapaport
Sasha, thanks for your help! But I'm not sure we're in agreement about what is happening yet: Sasha Pachev wrote: > On Wednesday 26 December 2001 01:24 pm, Venu wrote: > >>Since replication is only one-way, there really shouldn't be any updates >>happening on the slave, but in the failover ca

Fw: replication problems & questions

2001-08-15 Thread Neil Tompkins
Also regarding this matter, is it possible that I would on a local copy of the data on my own computer and it is then replicated automatically back to the ISP database ? Thanks Neil - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, A