Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

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.

share|improve this answer
    
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
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.