November 13, 2012 at 10:31 am
Hi,
I am working on the design of a MS-SQL 2012 failover cluster, running on top of Windows 2008. I am assuming mount point's behavior is similar between Denali and SQL 2008, as I will be using Windows 2008 anyway, but wanted to validate.
Here's the suggested disk layout:
D:\MSSQL\MSSQL10_50.I01\MSSQL
D:\MSSQL\MSSQL10_50.I01\MSSQL\Data
D:\MSSQL\MSSQL10_50.I01\MSSQL\Logs
D:\MSSQL\MSSQL10_50.I01\MSSQL\Backups
Each will be on a different LUN ... where the 1st one, will be for the binaries, next one Data, next one Logs, etc.
Do I have to create to specify a subdirectory under any of those, to avoid Cluster or permissions issues? For instance, when running the MS-SQL setup, do I have to create a sub-directory like this?
D:\MSSQL\MSSQL10_50.I01\MSSQL\Binaries
Or just specify this path: D:\MSSQL\MSSQL10_50.I01\MSSQL ??? ... so binaries will go there and setup will continue???
A similar question I think applies for Data, Log and backups ...
Also, this will be a two node Cluster only, with the possibility of one more SQL fail-over instance, using existing two nodes or servers. Should I really worry about Mount Points or go for a more simple approach, with drive letters?
Thanks in advance,
November 13, 2012 at 10:42 pm
Personally, I'd go for multiple drive letters if you expect only two instances.
I'll throw this out for public ridicule:
1 drive for the sql install (system dbs, sql errorlogs, etc)
1 drive for user db mdf files
1 drive for user db log files
Optionally:
1 drive for tempdb
1 drive for backups
What is more important than the number of drives is the way they are configured.
for example, do you need raid 10 for logs? With enough write caching on the SAN, no!
it is nice from a manageability standpoint to have user db's seperated for moving between clusters, but don't over think it.
November 14, 2012 at 3:45 am
sql-lover (11/13/2012)
Hi,I am working on the design of a MS-SQL 2012 failover cluster, running on top of Windows 2008. I am assuming mount point's behavior is similar between Denali and SQL 2008, as I will be using Windows 2008 anyway, but wanted to validate.
Here's the suggested disk layout:
D:\MSSQL\MSSQL10_50.I01\MSSQL
D:\MSSQL\MSSQL10_50.I01\MSSQL\Data
D:\MSSQL\MSSQL10_50.I01\MSSQL\Logs
D:\MSSQL\MSSQL10_50.I01\MSSQL\Backups
Each will be on a different LUN ... where the 1st one, will be for the binaries, next one Data, next one Logs, etc.
Do I have to create to specify a subdirectory under any of those, to avoid Cluster or permissions issues? For instance, when running the MS-SQL setup, do I have to create a sub-directory like this?
D:\MSSQL\MSSQL10_50.I01\MSSQL\Binaries
Or just specify this path: D:\MSSQL\MSSQL10_50.I01\MSSQL ??? ... so binaries will go there and setup will continue???
A similar question I think applies for Data, Log and backups ...
Also, this will be a two node Cluster only, with the possibility of one more SQL fail-over instance, using existing two nodes or servers. Should I really worry about Mount Points or go for a more simple approach, with drive letters?
Thanks in advance,
It seems to me that you are confusing mount points. Read my article at this link[/url] for more info on mount points.
Taking your scenario above you would first have a root drive, about 100MB in size or even smaller if possible. The root drive would be assigned a drive letter D:
Under this drive you create the folder structure below
D:\MSSQL\MSSQL10_50.I01\MSSQL
Under the MSSQL folder you create any folders that will be used to mount the NTFS volumes. Folders created would be
D:\MSSQL\MSSQL10_50.I01\MSSQL\Data
D:\MSSQL\MSSQL10_50.I01\MSSQL\Logs
D:\MSSQL\MSSQL10_50.I01\MSSQL\Backups
D:\MSSQL\MSSQL10_50.I01\MSSQL\Binaries
The 4 new volumes are then mounted under these folders. Once the volumes are mounted you must create a subfolder under each to facilitate the granting of NTFS permissions. It's all in my article linked above, post back if you're still stuck after reading that.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2012 at 5:35 am
Thanks Perry,
I'll take a look today ...but regardless , with a max of two failover instances on a two node clusters , would you recommend mount points? Besides gaining more flexibility and freedom regards drive letter choice, what else would I potentially miss if I go the drive letter route?
November 14, 2012 at 6:16 am
sql-lover (11/14/2012)
Thanks Perry,I'll take a look today
It will help you understand better 😉
sql-lover (11/14/2012)
but regardless , with a max of two failover instances on a two node clusters , would you recommend mount points? Besides gaining more flexibility and freedom regards drive letter choice, what else would I potentially miss if I go the drive letter route?
Yes i would. Commonly you would use mount points to get round the drive limitations of the OS, but i think that mount points help to keep everything nicely ordered whilst still making use of multiple disks for good performance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 8:51 pm
Perry Whittle (11/14/2012)
Yes i would. Commonly you would use mount points to get round the drive limitations of the OS, but i think that mount points help to keep everything nicely ordered whilst still making use of multiple disks for good performance.
I ended deploying the new Cluster at work using mount points.
Our SAN expert was shocked and amazed of how powerful and simple the mount point is. He actually is planing on using it for future clients, different than us.
To my surprise, he said had never seen it before.
December 5, 2012 at 11:48 pm
Mount points are a standard feature of the NTFS file system and have been for some time. Mounted volumes are very common on Unix systems too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply