RE: Multiple mysql servers with the same datadir

2004-02-02 Thread ZHANG JIAYING
Hi, Andrew. Thank you very much for your explanation. And yes, I actually wanted to mean BDB, instead of DBD. I just checked BDB document. It seems they maintain their own locks. So my two cases will lead to data corruption. I wonder if there are any database management systems implementing

RE: Multiple mysql servers with the same datadir

2004-02-02 Thread Andrew Braithwaite
system is cpu or ram bound. If it's diskbound then you won't achieve scalability this way. Cheers, Andrew -Original Message- From: ZHANG JIAYING [mailto:[EMAIL PROTECTED] Sent: Monday 02 February 2004 20:35 To: [EMAIL PROTECTED] Subject: RE: Multiple mysql servers with the same datadir

RE: Multiple mysql servers with the same datadir

2004-02-01 Thread Andrew Braithwaite
Hi, I think you're getting mixed up between DBD (data base driver) and BDB (BerkeleyDB) but I reckon you mean BDB... I'm not sure if the locking of the page (i.e. the whole table file) is done at the filesystem level or is managed internally by each mysqld instance. If it is managed by each