Two separate MySQL servers (instance) on Windows Server 2008 running concurrent to serve requests. Database files on SAN. Does MySQL supports this setup?
Running MySQL directly on a SAN LUN as shared storage does not work, unlike Oracle with ASM.
You can go different directions:
- Running a cluster file system (GFS2 or OCFS) on all nodes, putting the MySQL database files there.
- Using a NAS Server providing the storage via a network file system
- Having one LUN for each server and running MySQL cluster (NBD storage engine)
- Using MySQL replication with shared-nothing-nodes