MySQL Bugs: #54299: Multiple Instance, Symlinked Tables

Bug #54299	Multiple Instance, Symlinked Tables
Submitted:	7 Jun 2010 14:47	Modified:	8 Jun 2010 5:48
Reporter:	patrick maartense	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.47	OS:	Linux (Suse 11.2)
Assigned to:		CPU Architecture:	Any
Tags:	symlink

Description:
When having Multiple Instances running where some tables are Symlinked data is not updated on other instances when doing INSERT on one Instance

How to repeat:
create multiple instances with seperate Data Directories
symlink one table (data / Index) , keep .frm in datadir for the instance

do a select on both instances
insert a record in one instance

data change will not show in other instance

Thank you for the report.

Please explain what you mean by multiple instances? Do you access to same table files from 2 mysqld server instances?

Yes indeed

one MySQL server running on port 3306 other on other ports
we need one User Database for all  Applications, where other Tables are different per Server instance

Setup like this :

--SERVER 1 --- /var/data/Server1/DB1
                                   |-Usertable
                                   |-Table2                                   
--SERVER 1 --- /var/data/Server1/DB2
                                   |-Table1
                                   |-Table2                                   

--SERVER 2 --- /var/data/Server2/DB1
                                   |-Usertable SYMLINKED to DB1 (MYD/MYI)
                                   |-Table2                                   
--SERVER 2 --- /var/data/Server2/DB2
                                   |-Table1
                                   |-Table2

Thank you for the feedback.

This is unsupported: you can not share 1 table between 2 servers. Use MySQL Cluster, replication or another solution.