Re: Reason for MySQL Replication Slave Crash

2010-02-12 Thread Manasi Save
Dear Shawn, Thanks for the quick reply. To your points, First I have a query regarding your last line if I want to run master-master replication I should run it in active-passive mode. Does that mean that I should run only one master at a time. But I am doing it because I am not keeping two

Re: how things get messed up

2010-02-12 Thread Ann W. Harrison
Martijn Tonies wrote: For example, the Firebird DBMS stores (longer) Blob data not right there in the record, so whenever you don't request the blob (that is, not selecting it), it ignores it completely and it can go through the file quickly. As do most of the MySQL storage engines. Cheers,

Re: Reason for MySQL Replication Slave Crash

2010-02-12 Thread Shawn Green
Hello Manasi, Manasi Save wrote: Dear All, I am using MySQL Master-Master Replication. Where most of the times it is happening that my slave crashes with two errors either :- 1. Duplicate Entry (Error No:- 1062) That means that a row with the same PRIMARY or UNIQUE key value(s) already

Reason for MySQL Replication Slave Crash

2010-02-12 Thread Manasi Save
Dear All,I am using MySQL Master-Master Replication. Where most of the times it is happening that my slave crashes with two errors either :- 1. Duplicate Entry (Error No:- 1062)2. Does not find the row for update or delete. (Error No :- 1032)Well I google the problem but unable to find exact reaso

Re: how things get messed up

2010-02-12 Thread Vikram A
Sir, Thanks for your suggestion, I will go for blob storage, because our application will maintain the data on yearly basis[stupersonal2008, stupersonal2009 etc.]. So i feel we may not face such kind of performance issue in our application. Thank you VIKRAM A ___

Re: how things get messed up

2010-02-12 Thread Johan De Meersman
On Fri, Feb 12, 2010 at 9:19 AM, Vikram A wrote: > I am in the situation to storing student and staff images. every year 2000 > new photos has to be added in our application. > > Can i have your suggestion, which is the best one, storing as a blob Or > using NFS? > It will be great help to me, be

Re: how things get messed up

2010-02-12 Thread Vikram A
Sir, I am in the situation to storing student and staff images. every year 2000 new photos has to be added in our application. Can i have your suggestion, which is the best one, storing as a blob Or using NFS? It will be great help to me, because such experts are sharing your own experience on