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

[7 Jun 2010 14:47] patrick maartense
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
[7 Jun 2010 17:15] Sveta Smirnova
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?
[8 Jun 2010 5:15] patrick maartense
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
[8 Jun 2010 5:48] Sveta Smirnova
Thank you for the feedback.

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