[Gluster-users] Gluster + MySQL WH question

Charlie Waters cwaters at alchemysi.com
Wed Feb 18 13:46:51 UTC 2009


Hello all,

I am looking to build a scalable MySQL data warehouse and am  
considering GlusterFS.  Specifically, I would like to use the Switch  
Scheduler to store MyISAM and Infobright tables across the parallel  
disk cluster.  Perhaps something like

option switch.case a*:brick1, 1*:brick1, b*:brick2, 2*:brick2,  
c*:brick3, 3*:brick3, etc....

Furthermore, I suspect the Switch Scheduler could reference a  
subvolume where GFS1 handles tables 0*, 3*, 6*, 9* and GFS2 handles  
1*, 4*, 7* and GFS3 handles tables 2*, 5*, 8* (and alpha in a similar  
manner), thus somewhat abstracting the logical versus physical  
storage.  To scale horizontally, more nodes could be added to GFS1,  
GFS2, and GFS3 as performance/storage requirements dictate.

Are there any examples of such a thing being done?  Am I WAY off base  
here?  Any guidance would be helpful as we are still in the planning  
stages of this.  Many thanks!

--Charlie




More information about the Gluster-users mailing list