WL#3084: Cluster Disk Data needs to allow for file path configurations

Affects: Server-7.1   —   Status: Un-Assigned   —   Priority: Low

I realize that there is no way for me to split out the data and log files on a
multi data node system. This is not good when it comes to getting the most out
of disk based performance. 


How hard would it be to specify at log and a data path in the config.ini that
would allow users to point these files to different disks?


Example if each system had 4 drives (/data /data1 /data2 /data4)  

[ndbd]
Id: 4
HostName: ndb09
DataPath: .
DiskDataPath: /data
LogGroupPath: /data1

[ndbd]
Id: 5
HostName: ndb07
DataPath: .
DiskDataPath: /data
LogGroupPath: /data1

[ndbd]
Id: 6
HostName: ndb09
DataPath: .
DiskDataPath: /data2
LogGroupPath: /data4

[ndbd]
Id: 7
HostName: ndb07
DataPath: .
DiskDataPath: /data2
LogGroupPath: /data4

Jonathan Miller
Austin, Texas USA
Senior Quality Assurance Developer
MySQL AB www.mysql.com


-----Original Message-----
From: Jimmy Guerrero [mailto:jguerrero@mysql.com] 
Sent: Thursday, January 19, 2006 4:19 PM
To: 'Jonathan Miller'
Subject: RE: 

I asked Robin what his thoughts were on the matter...

<<Should you have the flexibilty in the config file to specify where your
data and log files go to perhaps take advantage of multiple spindles and get
better I/O on multi-node hosts?>>

Absolutely.  Our PS guys have the same faulty attitude and think everyone
buys RAID and no one buys JBOD anymore.  They're wrong.  Tons still use
JBOD.  Further, all the competition allows for such assignments.