[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" <skraw at ithnet.com> 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" <tejas at gluster.com> 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" <samuel.hassine at gmail.com>
> > To: "Gluster List" <gluster-devel at nongnu.org>
> > Cc: "Yann Autissier" <yann.autissier at anotherservice.com>
> > 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
> > Gluster-devel at nongnu.org
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> > 
> > _______________________________________________
> > Gluster-devel mailing list
> > Gluster-devel at nongnu.org
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> 
> 
> 
> 
> _______________________________________________
> Gluster-devel mailing list
> Gluster-devel at nongnu.org
> http://lists.nongnu.org/mailman/listinfo/gluster-devel