[Gluster-users] New to Gluster. Question about Postgres on Gluster.

[Christopher Hawkins]

Hi JC, 

Use caution: Databases are not supported but they do work. I have not used PostGres but with MySQL, I've seen the following:

Version 3.0.x : works fine at low load. Under high load the glusterfs client process consumes near 100% CPU. 

Version 3.1.0(qa9) : works great. Testing MySQL as a back end for a php web app shows that response times are about 35% slower than when MySQL is running on local disk (10k sata drive, gig-e as interconnect). I.e., 150ms response time turned to about 200ms. Hugely impressive considering the speed difference between local disk and a synchronous cluster filesystem! This ratio held true at low and heavy load. I pushed the app literally until the server was swamped and could not crash glusterd or glusterfs. Great job gluster devs!  :)


----- "JC de Villa" <jc.devilla at gmail.com> wrote: 
> Hi list, First off, sorry if this message seems to ramble about. It's been a long day that stretched through too many days. I'm currently reviewing gluster as storage for our servers. While not storing a massive data set (yet), it is starting to grow. The current setup is one that I inherited and basically has nothing going for it at the moment. No redundancy, back up policies are next to non-existent and if it all falls apart, I get to pick up the pieces and try to put them back together. I'm trying to get a requisition through finance at the moment for additional hardware. Anyway, we are running postgres for our databases. I was wondering how well gluster fares with DB's? Drawbacks? Recommendations? I'll be putting up and running a few VM's with gluster and run some tests to simulate the typical workload for a day. It's usually more writes through the day with sporadic reads when reports are generated. I've gone through the docs on the community site, but it's a bit short where DB's are concerned. Either that or I'm looking at it backwards and shouldn't be too concerned about running postgres on top of gluster. Any advice would be appreciated. Thanks! JC de Villa 
> _______________________________________________ Gluster-users mailing list Gluster-users at gluster.org http://gluster.org/cgi-bin/mailman/listinfo/gluster-users