Same LUN presented to four machines, can't see updates from one machine on the other
Posted on 2014-07-16
A guy at work wanted a temporary shared storage between four SQL servers, two virtual and two physical servers. This is so that he can easily do some work that involves importing and exporting data between the servers.
I created a LUN that I presented to the two physical servers and the hosts in the vmware cluster where the virtual machines are. I then created a Raw Device Mapping on the VMs to the LUN and set the multiwriter parameter for the SCSI adapter it used to yes or true(something to that extent) so that the vm would no try to lock the RDM disk for itself and allow two VMs to share it.
All works nice, but it seems that when data is copied from one machine to the shared storage, one of the other machines might not see the files actually being in the file system. The disk might show the right data usage, and we can browse to the folder, but one can't see the files that were copied there from first machine.
We have tried to rescan the disks in diskmanager, and to give the group Domain Users, and all the machine accounts involved full access. We have also tried to restart the machine that does not see the files. This has not helped.
The server OS on all four servers is Windows 2012 R2.