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 mysqld instance then what you suggest would be a very bad idea and will certainly lead to data corruption. If the page locking is managed by the filesystem then I don't see a problem with what you suggest. If the latter is the case and you want to use NFS to access the datadir make sure you enable the lock daemon for NFS on the remote server. In general, BDB is not as well supported in MySQL as the other types and I'm sure you can achieve what you're trying to do using another method (replication, clustering for example) Cheers, Andrew -----Original Message----- From: ZHANG JIAYING [mailto:[EMAIL PROTECTED] Sent: Friday 30 January 2004 20:06 To: [EMAIL PROTECTED] Subject: Multiple mysql servers with the same datadir Hi, all. I notice this is not recommended in the manual. But I wonder if not considering performance, when using dbd as the table type, are there any problems in these two cases? 1) running multiple mysqld processes on the same machine with the same datadir. 2) running multiple mysqld on different machines. but they use the same datadir through NFS. I think there will be problems when using other type of databases. But I heard dbd uses page level lock. So if just talking about consistency, are these two cases ok? Thanks a lot! --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
