[gpfsug-discuss] GPFS for DBs..MySQL, PGSQL, etc; How about VMware?

[Wahl, Edward]

Can't say I've tried this in so many years it's not relevant.  But the IBM/TSM storage folks have a number of interesting reports over at their blog posted using Tivoli with DB2.  I recall it says right out there that the DB was on the ESS/GSS but it's been a few months.  Search for "storageneers tivoli" and/or "scale out tsm gss".  I think there were two or three of them last year.

Or poke Sven. ;)  Something tells me he'll know.

Ed Wahl
OSC

________________________________________
From: gpfsug-discuss-bounces at gpfsug.org [gpfsug-discuss-bounces at gpfsug.org] on behalf of Zachary Giles [zgiles at gmail.com]
Sent: Thursday, September 03, 2015 10:59 AM
To: gpfsug main discussion list
Subject: [gpfsug-discuss] GPFS for DBs..MySQL, PGSQL, etc; How about VMware?

Hello Everyone,

Medium-time user of GPFS, MySQL, PostgreSQL, etc here..  Decent sized
system in production, hundreds of nodes, lots of tuning etc. Not a
newb. :)
Looking for opinions on running database engines backed by GPFS.
Has anyone run any backed by GPFS and what did you think about it?

I realize there are tuning guides and guide-lines for running
different DBs on different file systems, but there seems to be a lack
of best-practices for doing so on GPFS.

For example, usually you don't run DBs backed by NFS due to locking,
cacheing etc.. You can tune those out with sync, hard, etc, but, still
the best practice is to use a local file system.
As GPFS is hybrid, and used for many apps that do have hard
requirements such as Cinder block storage, science apps, etc, and has
proper byte-level locking.. it seems like it would be semi-equal to a
lock file system.

Does anyone have any opinions, experiences, or recommendations for
running DBs backed by GPFS?
Also will accept horror stories, gotcha's, and "dont do it's". :)

On that same note...
How about VMware?
Obviously I guess really the only way would be via NFS export.. which
cNFS was .. not the best at (my opinion). Maybe Protocol Servers are
better? Maybe also a "don't do it"?

Thanks,
-Zach


--
Zach Giles
zgiles at gmail.com
_______________________________________________
gpfsug-discuss mailing list
gpfsug-discuss at gpfsug.org
http://gpfsug.org/mailman/listinfo/gpfsug-discuss