Re: Replication and transaction questions

2002-04-03 Thread Heikki Tuuri
Hi! - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, April 03, 2002 9:00 AM Subject: Re: Replication and transaction questions > On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote: ... >

Re: Replication and transaction questions

2002-04-02 Thread Jeremy Zawodny
On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote: > HI, > > I have two questions: > > 1) is there a way to tell my mysql master not to log failed > executions, such as creation of existing tables, drop of inexistant > databases etc? It's been a while since I checked, but it either doe

Replication and transaction questions

2002-04-02 Thread Nico Sabbi
HI, I have two questions: 1) is there a way to tell my mysql master not to log failed executions, such as creation of existing tables, drop of inexistant databases etc? Each of these operations lock the slave, and I believe that it' conceptually wrong logging them, since they never took pla

replication and transaction problem

2002-02-15 Thread Catalin Grigoroscuta
Hello everyone I've read about replication mechanism in MySQL, but I've still got some reservations regarding transactions. In the manual thay say that in case of a transaction, all update instructions are hold in a cache, and on commit they are written to the binary transaction log. After the u

Re: Replication and Transaction

2001-06-12 Thread Benjamin Pflugmann
Hello. Sorry, but I fear, I am not sure what you mean by "sync of a row". In MySQL, replication sends complete commands to the slave and if the command is received completely, it will be executed. The server holds a log about all commands and when the connections breaks, the slave remembers the

Replication and Transaction

2001-06-12 Thread Paulo Angelo
Helo, I'm intersted to know about MySQL replication, I could make it work, I will send some problems I found later. I have a question about the replication in MySQL: Does it implement transaction? Imagin if the connection break exactly in a sync of a row. What hap