MySQL Forums
Forum List  »  Merge Storage Engine

Re: Merge tables and indexes
Posted by: Ingo Strüwing
Date: June 02, 2006 09:43AM

Oh. You meant different machines when you said "servers". usually we mean "mysqld" processes when we talk of servers.

But if you have NFS mounted the other machines DATADIR, it should work in the same way as I decribed in the other thread.

HOWEVER, not all NFS implementation support correct file locking. Unless you are very sure that your machines implement correct file locking over NFS, you _must_ ensure that no two servers (I mean mysqlds) can access the same table.

Please read http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
7446
June 01, 2006 02:13PM
5089
June 01, 2006 06:48PM
5048
June 02, 2006 08:36AM
Re: Merge tables and indexes
4498
June 02, 2006 09:43AM
4226
June 02, 2006 01:28PM
4077
June 06, 2006 11:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.