MySQL Forums
Forum List  »  Quality Assurance

sharing tables among n+1 mysqld processes
Posted by: Eric Robinson
Date: May 09, 2008 06:52AM

Sorry for cross-posting this, but I'm not sure which forum is the correct place for this question.

The following page describes a technique for using Linux symlinks to reference database tables.

http://dev.mysql.com/doc/refman/5.1/en/symbolic-links-to-tables.html

We have a large read-only database (MyISAM) and we want to give several instances of mysqld access to it without having to create multiple copies of the database on disk.

Basically, the above article says you can symlink the MYD and MYI files, but not the FRM file. However, it does NOT explicity state whether it is safe to use this technique to give multiple mysqld instances access to the same physical database files.

Can anyone shed light on this question? Is it safe to use this symlink technique to allow multiple instances of mysqld to access the same read-only database?

Options: ReplyQuote


Subject
Views
Written By
Posted
sharing tables among n+1 mysqld processes
3077
May 09, 2008 06:52AM


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.