<html><body>
<p><font size="2" face="sans-serif">Hi Zachary,</font><br>
<br>
<font size="2" face="sans-serif">VMWare via NFS to GPFS is a great option as several new features have been added to GPFS to support VM workloads over the last couple years, including file-grained dirty bits (FGDB) for tracking updates at 4KB granularity and HAWC for buffering small synchronous writes in fast storage.</font><br>
<font size="2" face="sans-serif"><br>
Dean Hildebrand<br>
IBM Almaden Research Center<br>
</font><br>
<br>
<img width="16" height="16" src="cid:1__=07BBF426DFE669EF8f9e8a93df938@us.ibm.com" border="0" alt="Inactive hide details for Zachary Giles ---09/03/2015 08:00:07 AM---Hello Everyone, Medium-time user of GPFS, MySQL, PostgreSQL"><font size="2" color="#424282" face="sans-serif">Zachary Giles ---09/03/2015 08:00:07 AM---Hello Everyone, Medium-time user of GPFS, MySQL, PostgreSQL, etc here.. Decent sized</font><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">From: </font><font size="1" face="sans-serif">Zachary Giles <zgiles@gmail.com></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">To: </font><font size="1" face="sans-serif">gpfsug main discussion list <gpfsug-discuss@gpfsug.org></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Date: </font><font size="1" face="sans-serif">09/03/2015 08:00 AM</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Subject: </font><font size="1" face="sans-serif">[gpfsug-discuss] GPFS for DBs..MySQL, PGSQL, etc; How about VMware?</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Sent by: </font><font size="1" face="sans-serif">gpfsug-discuss-bounces@gpfsug.org</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<tt><font size="2">Hello Everyone,<br>
<br>
Medium-time user of GPFS, MySQL, PostgreSQL, etc here.. Decent sized<br>
system in production, hundreds of nodes, lots of tuning etc. Not a<br>
newb. :)<br>
Looking for opinions on running database engines backed by GPFS.<br>
Has anyone run any backed by GPFS and what did you think about it?<br>
<br>
I realize there are tuning guides and guide-lines for running<br>
different DBs on different file systems, but there seems to be a lack<br>
of best-practices for doing so on GPFS.<br>
<br>
For example, usually you don't run DBs backed by NFS due to locking,<br>
cacheing etc.. You can tune those out with sync, hard, etc, but, still<br>
the best practice is to use a local file system.<br>
As GPFS is hybrid, and used for many apps that do have hard<br>
requirements such as Cinder block storage, science apps, etc, and has<br>
proper byte-level locking.. it seems like it would be semi-equal to a<br>
lock file system.<br>
<br>
Does anyone have any opinions, experiences, or recommendations for<br>
running DBs backed by GPFS?<br>
Also will accept horror stories, gotcha's, and "dont do it's". :)<br>
<br>
On that same note...<br>
How about VMware?<br>
Obviously I guess really the only way would be via NFS export.. which<br>
cNFS was .. not the best at (my opinion). Maybe Protocol Servers are<br>
better? Maybe also a "don't do it"?<br>
<br>
Thanks,<br>
-Zach<br>
<br>
<br>
-- <br>
Zach Giles<br>
zgiles@gmail.com<br>
_______________________________________________<br>
gpfsug-discuss mailing list<br>
gpfsug-discuss at gpfsug.org<br>
</font></tt><tt><font size="2"><a href="http://gpfsug.org/mailman/listinfo/gpfsug-discuss">http://gpfsug.org/mailman/listinfo/gpfsug-discuss</a></font></tt><tt><font size="2"><br>
<br>
</font></tt><br>
<br>
</body></html>