Re: [Gluster-devel] SQL databases storage

[Christopher Hawkins]

I am interested in testing this as well. What kinds of database corruption did 
you see, Samuel? I can try to replicate what happened and will also report the 
results of my own testing. 

I can see how accessing the databases concurrently from two or more different 
clients can cause problems. A mysql instance expects to have exclusive access 
to the database files... But what about using replicate to mirror the database 
to another server for DR? That is what I had in mind. In this use case, only 
one server instance would be accessing the files at any given time, but they 
would be then be available elsewhere in case of failure. 

Chris

----- "Stephan von Krawczynski" <address@hidden> wrote:

> Hello,
> 
> one should note that you should avoid using "performance/quickread"
> even in
> trivial db cases (like ascii tables) because it will eat your data.
> 
> Regards,
> Stephan
> 
> 
> On Mon, 22 Feb 2010 06:57:34 -0600 (CST)
> "Tejas N. Bhise" <address@hidden> wrote:
> 
> > Hi Samuel,
> > 
> > Gluster is known to work with databases because we provide posix
> compliance. However we only recommend use of Gluster for unstructured
> file data. 
> > 
> > Regards,
> > Tejas
> > 
> > 
> > ----- Original Message -----
> > From: "Samuel Hassine" <address@hidden>
> > To: "Gluster List" <address@hidden>
> > Cc: "Yann Autissier" <address@hidden>
> > Sent: Monday, February 22, 2010 6:22:59 PM GMT +05:30 Chennai,
> Kolkata, Mumbai, New Delhi
> > Subject: [Gluster-devel] SQL databases storage
> > 
> > Hi all,
> > 
> > I am trying to store MySQL and PostgreSQL files on the Gluster. I
> > started with MySQL and was suprised because it seems to work fine.
> > 
> > Firstly, is someone trying to do the same thing ? I am interested
> in
> > feedbacks or any kind of experience reviews.
> > Secondly, as I thought, I encoutered several database corrumptions
> but
> > MySQL repair tool works well and can fix these problems (however I
> have
> > to do that manually so it is useless).
> > 
> > @Gluster: are you intereted in database storage over GlusterFS
> > feedbacks? because we are trying to deploy MySQL, PostgreSQL and
> LDAP
> > directly on a GlusterFS space. Is it interesting to track the errors
> and
> > try to fix or this technology is not provided for these types of
> using?
> > 
> > Thanks for your answers.
> > 
> > Kind regards.
> > Sam
> > 
> > 
> > 
> > _______________________________________________
> > Gluster-devel mailing list
> > address@hidden
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> > 
> > _______________________________________________
> > Gluster-devel mailing list
> > address@hidden
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> 
> 
> 
> 
> _______________________________________________
> Gluster-devel mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/gluster-devel