Two separate MySQL servers (instance) on Windows Server 2008 running concurrent to serve requests. Database files on SAN. Does MySQL supports this setup?


Given that a SAN is just a block device MySQL doesn't care.

What you can't do, even with a cluster filesystem (which, last I knew wasn't in Windows Server) is have multiple instances pointing at the same disk, you could only do a failuover configuration.

  • So, I can only have one instance active, the other one just lying idle waiting to take over in case the master instance fail. Thks for the input. – Iman Jul 18 '09 at 16:25

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy