<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>Hello Tony,<br><br></div>You need to understand what Gluster is intended for and nature of virtualization.<br></div>A database needs high iops rates because of continuous CRUD operations. <br></div>There are distributed solutions in the industry like hadoop.<br></div>For traditional database structures, it's better to keep database on a block storage.<br></div>Don't confuse with DB and Virtualization. These both are different worlds and has different characteristics.<br></div>Gluster is a file system not a storage appliance.<br></div>I recommend you to check block storage alternatives like iSCSI SAN appliances for DB specific tasks in cost centric perspective.<br></div>For vmWare environment, VSAN and Raw Device Mapping would serve you best.<br></div><br></div>Best Regards<br></div>Aytac Zeren<br><div><div><div><div><div><div><div><br><div><div><div><div><div><div><div><div><div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Feb 26, 2015 at 4:53 AM, Tony Harris <span dir="ltr"><<a href="mailto:nethfel@gmail.com" target="_blank">nethfel@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi all,<div><br></div><div>I've been experimenting with Gluster for about a week now trying to get a feel for it to see how it might work for us as a back end storage for our virtual hosts. While I was reading one day I came across this:</div><div><br></div><div><br></div><div><h6 style="margin:1em 0px 0.2em;border:0px;font-family:arial,arial,sans-serif;color:rgb(123,45,0);font-size:11.6999998092651px"><span>15. I am getting weird errors and inconsistencies from a database I am running in a Gluster volume</span></h6><p style="color:rgb(0,0,0);line-height:16.8999996185303px">Unless your database does almost nothing, this is expected. Gluster does not support structured data (like databases) due to issues you will likely encounter when you have a high number of transactions being persisted, lots of concurrent connections, etc. Gluster *IS*, however, a perfect place to store your database backups.</p></div><div><br></div><div>from the troubleshooting page. This concerns me a little, but I want to make sure I understand whether this will affect me or not. Ok, so my file store wouldn't be storing a database directly, but it would store a VM that within it would host a database (like MSSQL Server - and actually it would be a few VMs that would host databases, 2 MSSQL and several MySQL) - would this experience the same "inconsistencies" as if I had a database directly stored on gluster, or is it not a problem due to it being VM traffic rather than a bunch of separate connections to a DB stored in a GlusterFS? </div><div><br></div><div>For now I've had to cross off Gluster, but I began to wonder if I understood the warning in troubleshooting correctly.</div><div><br></div><div>Thanks in advance for any info!</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>-Tony</div></font></span></div>
<br>_______________________________________________<br>
Gluster-users mailing list<br>
<a href="mailto:Gluster-users@gluster.org">Gluster-users@gluster.org</a><br>
<a href="http://www.gluster.org/mailman/listinfo/gluster-users" target="_blank">http://www.gluster.org/mailman/listinfo/gluster-users</a><br></blockquote></div><br></div>