<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I also don’t think Database and GlusterFS is a good combination cause of the performance issues related, unless performance is the last thing to concern about
or database is so small that it doesn’t make diference.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> gluster-users-bounces@gluster.org
[mailto:gluster-users-bounces@gluster.org] <b>On Behalf Of </b>Joe Julian<br>
<b>Sent:</b> 08 August 2012 17:55<br>
<b>To:</b> gluster-users@gluster.org<br>
<b>Subject:</b> Re: [Gluster-users] gluster taking a lot of CPU and crashes database at times<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">On Wed, Aug 8, 2012 at 4:30 PM, Philip Poten <<a href="mailto:philip.poten@gmail.com" target="_blank">philip.poten@gmail.com</a>> wrote:<o:p></o:p></p>
<p class="MsoNormal">Hey,<br>
<br>
running postgres (or any database) on a gluster share is an extremely<br>
bad idea. This can and will not end well, no matter what you do.<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
I still don't see why people keep saying this. I've been running mysql on a GlusterFS volume since the 2.0 days. I know Avati agrees with you though (though I keep trying to convince him otherwise).<br>
<br>
The only problem I've ever had was with creation or alteration of MyISAM files as they create a temporary filename, then rename it. This often causes an error as the rename (apparently) hasn't completed before it tries to open again (a bug that still seems
to exist in 3.3.0).<br>
<br>
InnoDB files can actually be quite efficient on a distributed volume if you create sufficient file segments to be distributed across subvolumes.<br>
<br>
The only real problem would be if someone thought they could run multiple instances of the database server. Regardless of what filesystem they're on, relational database engines are not built to be able to do that.<o:p></o:p></p>
</div>
</body>
</html>